Recent content by bosk0

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