Search results

I just spent the day creating a nifty page that writes a very long WHERE clause. I've tried to apply it to a form using: Forms![MyForm].Filter = "ReallyLongFilter" and using: DoCmd.ApplyFilter , "ReallyLongFilter" But I think Access is appending both attempts at around 256 chars... Does...

I understand, thank you. Steve

To understand this a little better... I developed the forms and tables in a single db, then used the splitter utility to split the tables from the queries and forms. I then moved only the tables to the intranet server, thinking that the forms would reside locally, the tables on the server. But...

Thank you. I'm not aware of having used any domain functions... I'm new to this and don't know what they'd be used for. I'll try to load info into the combo boxes with the enter event though and see if that helps. Thanks again, Steve

Are there any examples here you could point me to that would explain how to only load the combo box data when it needed to be updated? Steve

Hi, I have a form that looks at several linked tables. The tables are located on a different machine on our corporate intranet. One of the tables has 300 or so records, another has just over 1000 records. The form takes over 5 minutes to load. Is it taking that long because it has to load all...