I agree with Robert Stewart about the design issue. Separate point. Your query is unnecessarily complicated because of the repeated check on student cancelling or dropping. Ideally, you should have...

No. What you seem to be trying to do is construct dynamic SQL i.e.

iif(test, '> some  value', 'like *')

and Access doesn't really like that. What you can do is to...

Goto http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag01/html/BLOB.asp and have a look at the stream code.

Here's the ADO code:

Dim rst As ADOB.Recordset

Dim PF As ADOB.Recordset

Dim frm As [Form_Agency Info]

Dim loc As String

Set rst = Me.Recordset

Set PF...

ADO is supposed to be DB interface to the code right?

Yes, just like a phone is an interface to another person, however, you don't expect a phone to do...

Finally had a look at TransferDatabase. Need to check on some more complex databases to see if it behaves.

As to background, all three technologies ultimately rest on ODBC connections. ADO...

Two basic points.

When you link (not in code) you get asked what are the key fields. It is very tricky to do this in ADO so I tend to use...

No idea about TransferDatabase method.

The standard view is that DAO is optimised for Jet (i.e. Access) databases and ADO has the features to cope with just about anything else. ADO...

What about a udf which returns a table?

Yes. But watch how you handle what happens next.

Look at the help on the shell function which allows you to run another application. Look carefully at the note at the...

Look at the adox help on refreshing the views collection.

Doevents is a red herring. It does work, but not in the way you expect. The typical use of doevents is...

Same basic principle

Middle table will have fields:

Table - AcccountStatementUsageDescription

 

AcccountStatementUsageDescriptionID

AccountTypeID

TaxTypeID

StatementDescriptionID

And the Account table will simply have

AccountNumber

AcccountStatementUsageDescriptionID

Without seeing the model, this is only an initial stab.

An account has a statement type. You don't need either tax type or account type since these can be derived...

That's a *general* default. To set a column level default look at DRIDefault. Again quoting from bol

To set a DEFAULT constraint on a new SQL Server column

1. Create a...

An Access database can contain several types of table - local, linked Access, ODBC linked etc. The list of tables is held in a system table which is not normally...

Not that I know of. I'm using Access 2003 which has a good guide (for Access) to DAO.

Basically, the problem seems to be that if you use currentdb you are referring...