Search results

You could have a small form that has one (or more) textbox control where the desired date information would be entered. Then all the queries would have the WHERE criteria set to the value in the textbox control(s).

Using a Macro here gains nothing, just adds another layer. I don't use macros for anything except exection of Menus. I don't agree with the suggestion of using Macros, in this case, especially because it adds nothing to the app, or in most other cases as well. VBA is much more efficient...

Me.Title.SetFocus ... should be ... Me!Title.SetFocus

Hello all - I have a table I build with DAO code, then need to add fields and set a Text field to allow Zero-Length strings. I can not figure out how to set the field's property to allow this. Anybody know how to do this? Here is the code so far (Dims not included): Set tdfNew1 =...

why not post your code?

Sure - Put a Toggle button on the Form. In the Loop, add an IF that checks the state of the toggle. Example: Do .... .... If Me!Canc_toggle = True, then Exit Do .... Loop

You could use the 'Name' function. Name currentFilename As newFilename

The function you want is NZ(<field>,<value_if_Null> )