Search results

David, I had the same problem recently.I did get it to work, but it wasn't pretty. On the current event of the form, which changes each time the pointer goes to the next record, I saved the values of the pivotal information in a global variable(s). You could save them on the form header or...

I had that once, I used an Access Project with the Jet engine. There was no reason for this since the SQL server allowed the add and edits. I ended up combining the tables. But if you are using either Access tables or SQL tables on a server. I would open the query and see if I can add from...

The reason that you see record X is that your filter is still set for that. Update your filter to the new record you want to see and that should solve the problem, you can also use the recordsource property. You could put a query in there that was tied to a field on your form, that contains the...

In general Access is not very good with large sets of data. My suggestion is that you take some intermediate steps. You can use make table queries and so combine information or if your backend is a SQL server you could either write some stored procedures, or make an SQL statement in VBA and run...

If the search strings are mutually exclusive, you could upon one field getting the focus, make the other search fields "" and when the user pressed the command button you can check withone of your queries to run. If the search can be combined, you will have to do your query by SQL string and...

I have a form in datasheet view. The objects on the form are either textboxes or checkboxes. If a particular checkbox on a row(record) is checked, I would like to disable some of the objects on that same row, so the user cannot enter data there and see that he cannot. Do you know of a way to...