Recent content by Hilton

Hmm. Looking into the form details, and I the following under the Data section: Record Source: Customers Recordset Type: Dynaset Fetch Defaults: Yes Filter: [Customer ID]=[Forms]![frm Search Results]![Customer ID] Filter On Load: No Order By: <blank> Order By On Load: Yes Data Entry: No Allow...

I believe I mentioned earlier that this had to do with an Add New Entry form. It is the same form used to edit the entries. Do I need to manually give each field a value when opening the form for a new entry? I thought VBA would be mature enough to deal with null values on its own. Every other...

That line still gives an RTE with the Nz() function, except now it is: Run-time error '-2147352567 (80020009)' You entered an expression that has no value. Another effect of the switch to Office 2007 I've found is that the Close buttons on the forms no longer work. (Not the titlebar ones...

Nothing has changed at all. Perhaps Access 97 just handled that null error differently (or not at all). I will try that tomorrow when I have the computer again.

I've figured out more detail... assuming the debugger is stopping on the exact line giving the error, I am getting this: Run-time error '2427': You entered an expression that has no value. on the bold line: Private Sub Form_Load() Forms![frm Customer Detail].MenuBar = "Item Bar"...

Okay, the toolbars ARE changing properly, but its because of VB code... however, certain functions are giving me RTEs. Although I am versed in programming, I am unfamiliar with VB or Access. I am getting an error on a line: If Me.CheckCustStatus = False Then Is Me a standard object of any...

Okay after my other stuff (see edited message above), the three options have no effects, except Allow Full Menus allowing the Create, External Data, and Database Tools tabs to display. The Add-ins tab only displays if I specify a custom toolbar, which seems to stay stuck in place no matter where...

Is it possible to install Office 97 and Office 2007 at the same time? It would be nice to leave a modern Office on the system and have Access 97 linked only to this program... or I guess I could install OO or something. --- Okay, I had a whole bunch of stuff written up about different things...

I have a "program" here written entirely in MS Access, and I need to figure out how to update it. For background, the program controls a database of people and items for the shop owners and police, runs in Access 97, and ran on Windows 98. And has for the last 12 years. They desperately need to...