Search results for query: *

The field resolves to #Error with no error messages of any kind! Thanks. Lynn S

I have a form created in access 97. There is a field on the form populated from a table using this code PD: Format([PlgrDia],"0.00") The field PlgrDia is a numeric, double field. This has worked for a couple of years but suddenly it stopped. I have tried the Format([PlgrDia],"###0.00")and...

Below is a vary simple problem description of what I am trying to accomplish I have a table with 3 fields in it: Formula - text A - double B - double. The value of each variables is: Formula= A * B A = 2 B = 4 I want to read each record in the table and apply the formula to the numeric...

I have a long string similar to the following Dim sSql2 as String sSql2 = "INSERT INTO MyTable ( Var1, ..., var13)SELECT " & T1 & " as Var1, ... & T13 & " as Var13;" DoCmd.RunSQL sSql2 The resulting value of sSql2 is approximately 400 characters. Access truncates...

I am trying to write a query to append records to an existing database ie. Dim sSql2 As String sSql2 = "INSERT INTO MyTable ( Field1, ..., Field13 ) SELECT " & T1 & " as Field1 , " & ........ & T13 & " as Field13;" DoCmd.RunSQL sSql2 The problem is that...

I am trying to use an Access application as a sort of menu system. The user selects the file from a combo box. The columns in the combo box then furnish the program needed to open the file, the file path, the file name and the file extension. This works pretty well until I run acrose a file...

rac2 Your post was helpful. It helped me arrive at the solution that I finally used. As you can see from the code below I wanted to use a variable dependant upon the current record being viewed, [Forms]![Header]![GroupId]. When I put my variable name in place of the GroupID variable in your...

I am using the following code to read a sub set of records from the data table. I need to find the minimun and maximum values of Xdim and Ydim. How can I use the Dmin and Dmax functions to find the Minimum and Maximum value for the values for variable rs(2) and variable rs(3)? SQL =...

Any ideas on how to limit access to an approval field on a form to only authorized approvers?