Recent content by DeeDee77

I fixed it by not setting the RecordSource on the form to anything. Thanks!!

By the time the command button is clicked, the fields that have been entered in on the form have already updated the tables.

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...

Nevermind, I figured it out. I just had to turn off AutoCenter.

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...

No, I want to click a button on a form in Access that opens an Access query in Excel.

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

Yes, only in the subform. It is in datasheet view, and I tried actually putting the button on the subform, but it won't be there once you get out of design view.

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 figured it out. I had the relationships messed up. Thanks!!

It won't allow me to add a new record to the query, because there isn't a new record to go to. It is full with the info. from the 3 tables, and there is no new record at the end.

New Record, Sorry!!

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!!

How do I check for aggregate functions or update permission?