Search results

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?

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

There are 3 tables: Applicant, Application, and Apply_To. The information that the user types into the Main form is stored in these tables, but no 2 fields are stored more than once. Say there are 20 fields, 7 are stored in applicant (name, address, city, etc.), 5 are stored in application...

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

Thanks for your help!!