Search results

I removed the Exit Sub then tried it again. and that's the message I receive after this line is highlighted: CurrentDb.QueryDefs("qrySelectedFields").SQL = strSQL When I remove the stop and run the code - it receives another run-time error: The SELECT statement includes a reserved word...

Namliam, That is a great trick - I have read many books about the line-by-line but no one has made it understandable and easy as this. Thank you. So, it went through each line, and when it got to: CurrentDb.QueryDefs("qrySelectedFields").SQL = strSQL a run-time error occurred: Invalid SQL...

it won't keep the indented lines indented either - but hoping it is better than the first try.

Sorry it didn't keep the format when I copied and paste, and got in a rush and click the submit button too soon. I hope this is better: Dim varItem As Variant Dim strSQL As String If Me.List62.ItemsSelected.Count = 0 Then MsgBox "Please select one or more fields.", vbExclamation...

Access 2007-10 Listbox created: List62 (I know I need to rename it, but for now) Multi-select: Extended Row Source Type: Field List Row Source: qryFieldList Open Query: qrySelectedFields (I added primary key to first column, just to have at least one destination field). Goal: to select...

I am looking for a way to generate a list of all fields within a table, have the end-user select which fields he/she wants to include, and then run the query. I am trying to create this within a form for a nice, easy to use GUI. Has anyone ever done this - and has examples? or can point me in...

Thank you Estuardo. The situation actually changed, so I am all set now. I appreciate your help! You actually helped me see how to use the call function.

Access 2007-2010 format Form, 9 bound fields, grouped together Smart Tag = "UnitGroup" Summary: Needing to run VBA whenever the value is changed within one (or more) of these fields. User could be placing new value (defaults at 0) or editing(changing) previous value entered. I am not good on...

I know Foe - thank you very much, I really appreciate the effort!!

I tried it - but when setting the LimitToList to No - I still get the same message - The first visible column isn't equal to the bound column. If I keep the LimitToList set to Yes - it still gives me the "The text you enterested isn't an item in the list. Do you want to edit the items in the...

Unfortunately, that just makes it where they have to select the first column value or they receive a message "The value you entered isn't valid for this field".

Foe - unfortunately, when you set it back to 0 the Limit to List sets back to yes. But thanks for trying to help me. I appreciate it!

The system actually won't allow me to set the Limit to List to no, because the first visible column isn't equal to the bound column. I do not want to change the first visible column to show the primary key (bound column), it doesn't mean anything to the user. I realize I am in error not the...

Thanks Paul - I added that back in, I forgot to do that. However, it does not affect my results - the popup message still comes up. I tried using the List Item Edit Form - the popup message changed a little bit, but same thing. I don't want the popup window/message at all. That's why I am...

THe combo box is bound and it is a query. I have never heard of this List Items Edit Form - tell more, please.

Yes, the code I provided is Not In List event. But I have tried multiple things, one being a macro on the form open event, setwarnings to no, and that didn't work either.

I apologize. The warning message "Not In List" is appearing even though I have the setwarnings to False. I can't seem to get rid of it. It happens right before the form is loaded/opened to add a new name. I don't understand why it keeps appearing when I have the warnings set to false.

I am working in Access 2010. A bound combo box, Not In List event. I have the following code. It opens up a form to add the new name in. The form opens and then the "Not in List" message pops up. I have tried adding the SetWarnings to both forms, created a SetWarning macro, to no available...

I am from the small town of Bowling Green. Home of the mighty Falcons - Bowling Green State University - 2013 MAC Champions! I graduated from BGSU with my bachelor in Management Information Systems and my master in Organizational Development. I currently work for a REIT organization, and am...