Search results for query: *

For curiosity, I set it up to use Ms. O'Brian in the NAME1 field. It did not care. It printed out the page with her name on it. Alan

Great Post, That was it. Thank you. Your help is greatly appreciated. Here's a well deserved star. Alan

I have a form that gets its information from a query. There are 4 fields that are unbound that will be filled in by the user. When a button is pressed it is suppose to take all the information shown on the form from the original query and the filled in information and insert into a table named...

Duane, Thank you. That did it. Have a star

I need to update a field in a table named ClientContacts. The field needing updating is named CARef#. There is a second filed in named CCRef#. I have a table with contains only 2 fields they are CARef# and CCRef# named PopCARefField. An example of the date in the PopCARefFiled table is...

Duane, The T01CLILO is numeric. I removed the single quotes and it works like a champ. I cannot thank you enough for all of your help. Alan

Is the missing parameter error because there is no Where clause? Should there be something like "Where T01CLILO = rs("T01CLILO") after the From line in the code and before the db.execute line?

Found that problem. The Microsoft DAO 3.6 object library was not listed in References. That error has been taken care of Now when it is run it gives the following. Too few parameters. Expected 1.

I have added the code to a module. I added a button to my form and put the following code on it.Private Sub Command17_Click() On Error GoTo Err_Command17_Click Call MakeTables Exit_Command17_Click: Exit Sub Err_Command17_Click: MsgBox Err.Description Resume Exit_Command17_Click...

Sorry for the confusion. What I thought was that I had to specify the number of times that the loop was to run. The single numeric value that was returned was that number of times. An example - X = 1 to that value. Do something, then X = X + 1 loop etc. I am not real versed in this, so I...

These are simple queries that I thought could be used to control what happens. The first query returns the sub accounts.SELECT DISTINCT [Report Temp].T01CLILO FROM [Report Temp]; I then use that query to feed the second query to get the total of sub accounts.SELECT Count([Differnet...

Duane, thanks for the response. we may be doing this the hard way. One thing I did not make clear is that the number of sub accounts is always different. I am not sure I follow, can you give even a very bare bones example that I can look at as a starting place. I have made separate queries that...

What we have is a table that contains data for multiple sub accounts. Right now we are using a make table query to manually make a new table from each of the sub accounts so that they can be exported for some other stuff. The current table has 33 sub accounts. What we would like to do is have...

PHV and Majp Thank you to you both for all of your help. The final piece was the missing )

I found that there was an & _ at the end of the first strSQL line. When that is removed the error returned changes to: Run-time error '3134' Syntax error in INSERT INTO statement. What now appears in the immediate window is: INSERT INTO [Report Temp] (T01DESM, T01DATE0, T01SSN, T01NAM...

I have cleaned up the functions. I have also added a remark to each telling the type. In the Immediate window it just says false I get 1 of 2 errors when run. I am unsure whether the the proper usage should be: CurrentDB.Execute strSql or DoCMD.RunSQL strSql each gives a different error...

I really appreciate all of the help. After adding the single quotes to the functions. It still gives the same error. This is the code on the form Public Function getT01DESM() As Variant Dim frm As Access.Form Set frm = Forms("RDAOR") getT01DESM = "'" & frm.T01DESM & "'" End...

I changed the strSQL statement and if I understood correctly, the functions needed to changed to Public Function getT01DESM() As Variant Dim frm As Access.Form Set frm = Forms("RDAOR") getT01DESM = "" & frm.T01DESM & "" End Function when it is run it gives a "runtime error 28 out...

The Blue section is all of the functions that were set up for the fields on the form. All are set up like Public Function getT01DESM() As Variant Dim frm As Access.Form Set frm = Forms("RDAOR") getT01DESM = frm.T01DESM End Function When the button is pressed I get runtime error...

MajP, Thank you for your response. I was able to set up the various public functions for the fields on the form. If you would be able to point me in the right direction. I have made a button are attempting to run the sql code from the on click. I am having trouble with the code. I get compile...