Search results

Actually I researched right after I posted and found that I got it to work using the WhereCondition arg of OpenForm.

I am working on an Access forms application where the user wants a modal dialog that shows data which has been filtered by the current values in the form which launches the dialog. It's been hours and I can't get it to work. I don't know how helpful it would be to show any code, but basically...

a while ago It was a while ago that I worked on that project. I think that I resolved that it was a MS bug, and I think I worked around it by avoiding the Currency data type for fields that get loaded into comboboxes.

autoexec macro You might set up a macro named "autoexec" to call a Sub when the database is opened. The Sub would open the initial form, so you would not set up an initial form via the Startup options. The Sub might use application.currentuser mentioned in the previous post to set up the...

An MS/Access bug I think I have encountered a real MS/Access bug. Here is how to reproduce it: --- Start of Example --- Set up a table (tblTest) with 3 columns: "Money" (data type Currency), "Year" (data type Number), and "LastName" (data type Text). Load a few records of sample data...

I have an unbound combo box that is sporadically failing with an error message when an entry in its pulldown list is selected. The error message is to the effect: 'The value you entered isn't valid for this field' . The record source for the combo box is a table/query which is updated by an...