Recent content by gmann

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]...

Try This Dim ExcelApp As Object With ExcelApp .Application.Run "'M:\Macros.xls'!TransposeReport" Greg

DimExcelApp As Object Dim strSaveFileName As String Set ExcelApp = CreateObject("Excel.Application") strSaveFileName= 'your file path and file name With ExcelApp .workbooks.Open strSaveFileName .Visible = True

When you get the invalid use of null error and hit debug what line of code is having the problem. Its most likely the one with the subject, since not everyone puts a subject. The problem i think your having is your setting string variable to null which is no good. You should check if the objects...

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

Basically i want it to display the records based on what the user picks in the combo box. Its easy in a form, but i want to do it in a data access page. The code you wrote is in VB, u need vbscript for data access page. 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 =...

Nermind Alex I got it to work, just needed to use DoCmd.RunCommand acCmdSaveRecord Thanks for your help

The main problem i'm having is referencing the newly created record, if I use .Last its the last record before the newly created one. Do u know how i can reference the new record? Thanks Greg

Hey Alexandre, I attached an image of the related relationships. The tables that it deals with are Chemical, Chemical Details, and MethodChemical. Basically what i want is when the method entered in the chemical table, new records are created in the chemical detail table based on the...

Alright so I created another table called MethodChemical, it has two fields method and parameter. Ok so how do i get it to automatically add records. The whole idea is so people who are inputing data don't have to add these chemicals. The thing is that each paramater has other fields...

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...

First rstD.ChemicalDataID is a Long Secondly about making a table seperate for methods and chemicals that would be ideal if there wasn't like 2000 chemicals and 50 some odd methods(tests), which would have a lot of repetive data because many of the test use some of the same chemicalls. Thanks...

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'm sorry, i wasn't clear, I'm not using a Make Table Query. Its just a regular query; the form i use, has a command button that makes the table, because the table i need couldn't be made with the make table query. Here is the code, if u want to take a look. Private Sub...