Search results

I have a command button to add a record to a query that is based on 3 different tables. Right now, as soon as I type something into the fields, it updates the table. Is there any way to make it not update them until the Add button is clicked? There is probably a simple answer that I am...

I have a custom menu bar that I have as the startup menu bar. There is also a form that opens at startup. If I maximize the form, it covers the menu bar. Is there any way to avoid this? I've tried setting the form MenuBar property to the custom menu bar, but it didn't work. Thanks for any...

I was wondering if there is a way to open a query in Excel without having to save it to a file?

I have a Main form with an Add Record and Delete Record button on it. Then there is a subform on the Main form. When I press the Delete Record button nothing happens. Is there something that I need to do to tie the subform to the command button? Thanks for any help!!

I have a form(frmMaintenance) that is called from the menu bar that contains a subform(department). The subform should change according to which menu item is chosen (Dept., Location, etc.) and this is the code that I have in the module being called for location: Public Function Open_Loc()...

I have a form that is based on a query in which the user enters data. Is there any way to make the form open to a blank record instead of the 1st record in the query? Thanks for any help!!

I have a query that I am calling through a recordset statement. When it hits the .addnew line an error message comes up that says "Cannot update. Object or database is read-only". I have checked every possible thing that I can think of that could be marked read-only, and nothing is. Does...

I have a form with around 20 fields, but I need to save the info. that is entered by the user to be saved into 3 different tables when the Add Record button is clicked. Some, but not all, of the fields go into each one. Is there any way to do this? I was thinking of using recordsets, but it...

I have a form with like 20 fields that are combo and text boxes. There is an "Add Record" button at the bottom. I need the info. that is entered on the form to be saved into 2 seperate tables (some fields go to one and the rest to the other). Does anybody know what I need to do? Thanks in...

I'm trying to autofill a textbox (txtdeptname) based on the value in a combobox (combodeptnum). I have a department table that has the info in it (dept_num, dept_name). I tried DLookup, but it keeps giving me an error that the "Object doesn't support this property or method". Thanks in...