Search results

That is fine, I dont have to have the access to a previous record to make changes. I can always just go to the table it is populating into and manually change it. What about the error? Is there a way to change the ON CLICK button to not try and go to next record? (Since now it is running a...

OK, I cannot put my db on here for confidentiality reasons. I did do the Me.Requery event After Update and the form is definitely reloading and pulling the next available lot code for a completed selection. I no longer have 4 of 4 records or can go back to a previous record for a change...

Alright, I understand what you are talking about. I am using the multiple records recordset I believe. I have a table that has records saved in it from 10 years of history. When I open the form and enter in (for example, 4 records), a number at the bottom of the form will say 4 of 4. I...

I have a production form that I enter data into daily. On this form, I have a combobox that autopopulates a lot of the fields. I have also designed a command button for each material used that I can click and update some of my receiving of materials tables. I will click this command button...

I actually got it to work pretty well! Here is the new queries and how it runs now. You can make changes in the table to see if it works the way you want it. Just figured someone could benefit from this and not deal with the headaches I have had for a couple of days.

In case anyone was wondering I found this website that explains why you cannot base an update query on an aggregate query. http://support.microsoft.com/kb/116142 I had to make a temp table for the totals query to feed into and then run an update query based off the temp table. This is...

If you cannot open that one, here is a zipped version of it. PLEASE HELP if you can!

I have a sample of my database attached. In the sample, I have a Receiving table that gets updated when a material (Boxes/Bags) is received. I tried to create an update query so that I could run it on open of a form. This update query will run so that when something is received or...

I am running an update query on an "On Load" macro for a form. Is there a way to get rid of the 2 message pop ups stating that you are about to run a query, click yes and how many rows will be updated, click yes? Is there a way to bypass this and automatically run the query and make yes be...

Never Mind! I found that all I had to do is select the macro from a list and it runs the "On Load" event for the macro. Thanks again Bilbo, will add to your rep.

You are definitely helping me! There is an issue I am running into. I created the Macro and called it "Macro Update Lot Code". Here is the On Open Event for the form. As you can see, it is already running another procedure On Open. How and where should I write the code on here so that it...

I see where it is. Can you tell me the correct format to run an update query On Open in code? Thanks!

I have an update query that I need to be ran on open of access or a particular form in access that gets updated daily. I know I could get a command button to run the update query, but I was hoping to avoid this and just have it update automatically. Thanks!

Would it help if since I am already updating and have updated all completed lot codes, that maybe instead of having it select a current lot code, that I should have the minimum date received as the selection for the Coffee Lot Code? This way when I update a coffee lot code, it then will select...

Ok, so I got the UPDATE query to work! Everything is working so far. I have another thing I would like it to do. The way my form is set up is: When I select a Coffee, a Coffee Lot Code is updated auto based on the coffee selected in the form and the CurrentLotCode Yes field in my...

Ok. I think I get where you are coming from. Is there a way to join them without invoking an SQL query. Right now the Record Source says "tblDailyProduction". I never had a query for it. If I go to change the Record Source, it invokes the SQL. I have roughly 35 fields that get entered...

Not very familiar with parameter query. Do you mean set a query up put something in the criteria? Will this be something the operator must enter? Is there an example of what i can do? Thanks a bunch!

I have a material Receiving Material Table that gets updated based on entries when material is received in each having a specific lot code number. I also have a Daily Production Form that I enter in a customer's materials used. As of now, when a customer's material is used up, I go to the...

Actually, I figured it out. I just added some more codes to the item code table, but made the reference combo box be the corresponding materials combobox. Thanks for the help.

I may not be using the correct terms, but I am 'autofilling' the other fields based on a combobox called cboItemCode. This combobox pulls data from a table (tblItemCode). This table has everyone of our customer's specific materials on it. When the combo box item is entered or selected, it...