Search results

I have a form where a user chooses different criteria from listboxes and then I run out and format the SQL statement. This is the query that I am trying to replicate using VBA code. Note: the Location_ID, Ship_Day, and Final_Dest come from the values in the listboxes. I am getting a syntax...

I have a form with a combobox called fraShipDay. How do I reference the value of the user's selection in a query? I've tried using Forms![Form1]![fraShipDay] but it's not working.

I have a main form where a user can choose a location number from a dropdown box. Once they have selected a location, I populate some other text boxes for address, city, state, etc. based on the selected location. This part is working correctly. They can then press a command button to query the...

I checked and all the labels are formatted as flat already. The form does have a single label (the one that reads "50 characters maximum"), and when I hover over it, oddly enough, all the lines I am having issues with disappear. I checked any events that may be on this label and there aren't any.

I've done some more testing and have found the following. The form has one label. Whenever I mouse over this particular label, the small lines around the radio button test get cleared. I've checked the events on this label, and there are none.

Here's a screenshot.

I have a form with a few labels that for some reason, very often will have a strange looking line above them after I am done clicking on them. I can't seem to find out why this happens. It happens on every label on this particular form. Please take a look at the attachment for a screenshot...

Is there a way that you can capture a return code after you issue an Insert statement using SQL? I have a script that does numerous inserts into a table and I want a way to make sure there was no issues with the insert.

I am trying to come up with a form to do the following. The leftmost column will have the headings shown below. The rest of the columns are blank. Each row needs to have a checkbox in front of it for validation purposes. I want users to be able to add data (parameters) for a given location. I...