Search results

Hello, I'm having trouble getting this sql statement to work in VBA. strSQL = "SELECT Projects.siteid, Stations.[sequence numer], Stations.Station, Chemical.Details, Stations.Elevation, Stations.RiserLength, Stations.Screen_Length, Chemical.Date_Collected, Chemical.[Time Collected]...

I need to have my DAP combo boxes the ability to add things that are not in the list. I have this done in the corresponding table with the LimitToList property, but they don't have that for DAP. Does anyone know a way around this? Thanks Greg

I need to use combo boxes to look up records based on the selecton for the combo box. I know u can't have it find records like in access forms. I found some code on microsofts website, but it doesn't seem to work. <SCRIPT LANGUAGE=vbscript FOR=CustID EVENT=onchange> <!-- Dim rs Set rs =...

Is there a way to have multiple records display at once on a data access page or ASP? I have this table that has this field paramater, which deals with certains tests, each test uses a number of paramaters, so the way the DB was developed is that the different paramaters are listed dowm...

Trying to get vba code to enter in repetive data. Basically there is two tables that this deals with, Chemical and Chemical Details Table. Chemical has this field called Method, which determines what chemicals are tested, hence the parameters field in chemical details, which has a record for...

I have this code, that uses a query to make a new table. It works fine if u enter the criteria in the query itself. But i want the user to be able to select what they want using combo boxes on a form, so i made a new form with the same code as the other one. I put [Forms]![Lab2]![Combo10]...

I have this module that creates a new table based on a query Chemical_DataID is the only unique value in the query, so i genereate the table using the Chemical_DataID If (rst.Fields![Chemical_DataID] = rstnew.Fields![Chemical_DataID]) Then For Some Reason It doesn't Work But If i Use If...

Can anyone give me an idea how to use combo boxes as a query. I know some SQL, but i'm confused on how you reference the value in the combo box and how to correlate that with the Table being queryed Should this be AfterUpdate Private Sub Combo10_BeforeUpdate(Cancel As Integer) Dim dbs As...

Having Trouble with an Array, ChemicalArray(65) Basically i want this code to search through records for unique values (chemicals) in this one field (parameter). and create a new table with the values in the array as fields. For Some reason the first paramater is the only one that gets...