Search results

Can you email me the database as a zip file please? Providing the form referred to is open when the code is run, I can see no immediate reason for its failure. (I assume you are using the intrinsic constant acViewPreview and not just acPreview as you have written, by the way). And I also...

Can you email me the database as a zip file please? Providing the form referred to is open when the code is run, I can see no immediate reason for its failure.

Put a breakpoint on the DoCmd.Open Report line of your code. When the code breaks, inspect the values of the criteria on both sides of the WHERE clause by hovering the cursor over them. Report exactly what they are and we'll take it from there. PS- you shouldn't need the full syntax of the...

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q242889 Yes, it is documented after all...

Compact your database. Size bloat is an inherent feature of Access.

Try a Debug.print of the recordcount. If it returns zero rows, do .Move Last .MoveFirst after opening the recordset, to make sure that the correct number of rows is returned.

Using Access 2000 MsgBox function, I can't use the @ sign to format the prompt message, as I always could with Access97. The ampersands print as literal characters. Even the code sample in the help topic prints wrongly on two different machines. There is no article on MKB to help. Perhaps there...

What is [ICTStatus.DFee number] referring to?

inspect the properties for your form. Is Data Entry set to YES or NO? If it is set to yes, it will only be possible to display the current record, not the complete recordset.

If a field in your subform already has the focus, you don't need to include the reference to your subform. Just use Me![Assoc Type] etc in your expression

My solution will work if all the rules are followed, (preceding equals sign, valid field names, square brackets round field names if they contain spaces, etc). Calculated fields on the form are not bound(ie they are not stored in the underlying table). However, this is all academic if the data...

You can do this by having unbound calculated fields in place of the actual fields in the subform. A typical calculation would be: =IIf(MyField>0,MyField, "-")

This is going to sound unhelpful, but did you install the wizards in the first place? The setup procedure in Office2000 allows four options: Run from Hard Drive, Run from CD, Install on first use or Don't install. You need to go through the tree structure in Setup and make sure the wizards and...

This is nothing to do with a license, but is a bug caused by the Hattenschweiler font. It is documented on Micosoft's Support Site on the Knowledge base. I can't supply a link , as the site is not functioning properly tonight. Just type in the phrase and the fix will be revealed...

There is no reason I can see why you should have to put the same data twice into one table. But assuming that you do actually have some obscure reason to do so, you would at least be using a form to update the table. So on the After Update event of your "First field" on the form put this code...

It would help if you posted the query. You will probably have to express your query as an SQL statement in a function.

I would say you only need two tables. Your events should be in a separate Events lookup table, which is joined to your member table in a one-to many relationship using an EventID field. You can then use whichever dates you want to calculate based on the eventID.

Not really applicable In this case, it wouldn't really be logical. There's a combo on a form, and that combo provides the parameter for the query. When the combo is selected, code calls the query. The query can't call the form because there is no "code behind queries" in the same way as there's...

Doc_Man has more or less summed it up, I think. In any case, you seem to have a well-thought-out plan of action. If you want to adopt a more measured approach, you could consider using the Common Dialog Control, which gives you a familiar interface for navigating to, and selecting files...

It would be better if you were to stop your user selecting the wrong file at the outset, I think. Is it possible to give your files some identifier which would have to be present to initiate the import?