Search results for query: *

RoyVidar: I went to the Microsoft link you provided and their workaround worked perfectly: DoCmd.Echo False DoCmd.Close DoCmd.Echo True Thanks again!!

AceMan1 and RoyVidar......thanks for your help on this!! It's been driving me crazy for days now. I'll let you know how I make out. Thanks again...Chuter

When I close an unbound form I receive a series of "Enter Parameter Value" boxes that reference some unbound text boxes on the form. The Close command button uses the code DoCmd.Close....no other code that would trigger a query etc. Form's On Close event is blank (not coded). Weird thing is...

Would anyone know why a query based on one SyBase linked table (ie no joins) with 3 primary keys would run so much slower (10 mins) when the parameter is a variable referencing a form control... compared to when the parameter is a literal value (5 secs)? Strangest part is that this performance...

Thanks for your feedback eclipse...i'll give that a try.

Has anyone ever run into a situation in MSAccess where a certain user's PC did not recognize selected standard functions such as "Date()" or "Format()"? I have a query that works fine on my pc but returns error messages relating to not recognizing these functions when I try...

Thanks for your input and ideas!

I am involved in a archiving project that will require backing up historical data from mainframe system tables.....some of which are huge (1 Million plus records and up to 100 fields). Just looking for some feedback that I can use in evaluating Access as a suitable back-end. I know there is a...