Search results

Yeah the site is messing up a bit. All of the elements would remain constant in the insert query from post #3 except the SubRegion. So we would apply all of those criteria for each SubRegion. Example: If they selected: Region:North America SubRegion:All Segment:Food Sector:Candy Product:M&Ms...

Lol...that is where the problem comes in Rural...I am not sure of the best way to change the query. Do you have any suggestions?

Also I get "(All)" to appear in my combo box for the choices by doing: SELECT SubRegion_Table.SubRegion FROM SubRegion_Table WHERE (((SubRegion_Table.Region_ID)=Forms!Formulation_Combo!Region_Combo3)) UNION SELECT "(All)" FROM SubRegion_Table...

I insert records using SQL in both VB and the Access queries. An example of a VB insert is: CurrentDb.Execute "INSERT INTO Market_Table (Region, SubRegion, Segment, Sector, Product, Market_Size, Percentage, Volume, Ingredient)VALUES ('" & Me.Region_Combo.Column(1) & "', '" & Me.SubRegion_Combo...

What would be the best way to do the following scenario: I have a form where users can select continents. Another combo box is autofilled to show the respective countries. In that same combo box there is also an "All" option. So for North America the combo box would be filled with U.S., Mexico...

Lol...that is exactly what I wrote above...the " & Me.Volumn_Text1 & " was in between the parethesis.

Well I found a work around to this issue by doing it a different way...but maybe someone may need help with a similar problem.

Also Me.Volume_Text1 should be allowed to be NULL as well.

CurrentDb.Execute "DELETE MkFrmFunc_Table.Region, MkFrmFunc_Table.SubRegion, MkFrmFunc_Table.Segment, MkFrmFunc_Table.Sector, MkFrmFunc_Table.Product, MkFrmFunc_Table.Percentage, MkFrmFunc_Table.Volume, MkFrmFunc_Table.Ingredient FROM MkFrmFunc_Table WHERE ((MkFrmFunc_Table.Region = '" &...

I was wondering if anyone knew of a way to do this: I have a list of about 10 text boxes that I want to be autofilled based on a query I have. The query will return various numbers of results (never greater than 10) and I want each text box to be filled with one result of the query. The user...

That worked! Thanks Rural...you came through in the clutch, lol.

I apologize Rural...Mk/Frm/Func_Table IS a control source for my form.

Keith: I did rename the table and that didnt help. Rural: Mk/Frm/Func_Table is just another table in my db.

I am getting the error that says "Microsoft Office Access cant find the field 'l' referred to in your expression" It happens at this line of code: If ([Mk/Frm/Func_Table].Market = Me.Market_Combo2.Column(1)) Then Mk/Frm/Func_Table is in brackets due to the '/' being part of the table name. Any...

Man...it still gives me that error even after adding the WHERE statement Ryan wrote of to address where to place the update.

Can u give me an example of how to use the join in my statement Brian?

Joined you say? Can you elaborate a bit.

Yep, I can change/add new records or data...any more possible solutions?

Nah...those were just pasting errors. I wish that was the issue though, lol...it would be easier to figure that out.

To give a bit more info I want all the locations in the "Food_Table" that match my conditions in the WHERE statement to be updated to the new "Delivery_Size" when a user puts in a new delivery size in my form.