Search results

I have two combo boxes on the same form and for some reason one recalculates and updates and the other one doesn't. The control source for each is as follows: =DLookUp("[03_END_PREP].[END_PREP_DESC]","03_END_PREP","[PDS_PREP] = '" & [PREP_A_subform] & "'")...

I have a form and in the form is a subform. When I add a record with the following code, the subform detail scrolls in such a way that you can't see the record you just added...only a single blank new record. Can you set the scroll position so that I can see all the previous records including...

I want to create a button that executes an SQL statement in a form. The reason I can't just save a query and run the query from the form, is because the SQL statement needs to use a combobox value from the form. I've learned that docmd.runsql will not work for a simple select query.....does...

Hello all:) I have a form that has a combobox with table names in it. I want to execute a very complicated SQL statement but I want to put the table name (from the combobox) into the SQL statement. I'm planning on making a button to do this, but I don't know how to put the SQL statement in VBS...

Hello all, I am trying to export the data from a form to a textfile by using the following simple piece of code: Private Sub Command188_Click() DoCmd.OutputTo acOutputForm, "CC_MAIN_PROJ" End Sub it works, but gives me the data like this...

OK, I've read how to do this...really I have. I have a combobox value that I want to use which then based on the combobox value shows the value of another field for that respective record. Should be very simple - note, the recordset for the form is not the same table as I want to get the value...

I am assigning a recordset using vbs code. The variable "CB_proj" is a combobox value. The problem comes when the combobox is null, the program errors out and even if I try to exit the routine with an if statement, it still compiles the line of code and errors out because the object doesn't...