Search results for query: *

I am trying to put together a procedure to first add data into one table and then I need to return that primary key and have it part of the record set that will be added to another table. How do I retreive that recordset? Im looking at something like this.... Set db = CurrentDb Set rs =...

There are over 600 chemicals that could be identified for each sample. I just used a short set to show an example. hope that helps. Thanks in advance. Mychal

I have a table for analytical results. the table structure consists of a location, date sampled, analyte, concentration, and reporting limit value. There are 0 to many recordsets for each location and date sampled for the various analytes. Example: B-1 6/23/97 Benzene 1300 ppm B-1 6/23/97...

I have one main form, mainA and two subforms lets call subA and subB. when I add or update information in subA I want to requery a combo box on subB. I put this in an after_update event in subA, but it doesnt seem to work. Form![mainA]![subB]![cbobox].requery the error message that I get is...

Hello Jon thanks for the reply. well I originally started out with bound controls. Problem that I was having when I wanted to add a new record, I used e.g txtLab = "" for each textbox to clear the current information. What I didnt realize since it was a bound control it also...

I am trying to on event click in a listbox to populate the fields on my form. I have made each field unbound and I am trying to use this code. Private Sub lstLabName_Click() Set rs = db.OpenRecordset("SELECT * FROM tblLabratory WHERE tblLabratory.LabratoryID = '" & Me.lstLabName &...

Hello All, Im pretty new to programming. I have a project using an access DB using forms generated with VBA. I ran into a problem that seems simple but I cant figure it out. What I am trying to do is add a record to the DB. Process that I am using to clear my controls is this Private Sub...