Search results for query: *

It was a datatype mismatch due to how I created the field within an SQL query. I corrected the query and it works great. Thanks for all of your help! Julie

I have the following for/next loop in my project. When I enter a number for the fields value (ie.ADOSO.Recordset.Fields("Due") = 20), the update works. When I enter the variable 'y'(ie. ADOSO.Recordset.Fields("Due") = y) , it gives me a run-time error :Multiple-step...

Doug, Thanks, that solved the Datatype problem. Now it is erroring out in my with statement: With tblNewQiNum .Edit !QiNum = IngBigQiNum !QiDateTime = Now() End With It says method of data member not found and highlights .Edit...

I am trying to replicate a code in Access 2000 that works in Access 97. The statment "Dim Mydbs as Database" is acceptable in Access 97, but gives a compile error (User defined type not defined). Any help would be appreciated. Thanks, Julie

Michael, There must be a difference in the syntax for 2000. I tried it in 97 and it worked. I'll start a new thread for help with the 2K syntax. The next question I have is how do I get the QiNum into the Qi field for the new record I create? I tried: With tblWaiver .edit...

I use a Visual Fox Pro ODBC driver to link tables in an Access Project. When I do a query that uses more than one table I get the error: Could not execute query; could not find linked table [Microsoft][ODBC Visual Fox Pro Driver]Fil(#173) If I take one table and do a make-table query, I can...

Michael, When it errors, it goes to the "Dim Waivers as Database" line. I have created tblNewQiNum and qSelQiMax as you listed in the FAQ. I changed Mydbs to Waivers and Basic Data to tblWaivers. I call the function on the click event for a command button. Public Function...

Michael, Please bear with me. I am getting a compile error (User defined type not defined) for the "Dim Mydbs as Database" statement. (I did replace the variable with my database name.) Thanks in advance for your help. Julie

I am developing a database that allows multiple users to access and enter information into a form. If they are entering a new record, the form will be numbered incrementally (like autonumber). The problem exists when two or more users are accessing the form at the same time. I am trying to...

Brian, I did the "Report Definition" that you suggested and it gave me all the formula information I needed. Thanks for your help, Julie

I have just completed a rather complicated report using several formulas with several shared variables. I need to document the process I used to obtain the final result. 1. Is there a way to print the formula infomation for a report other than copy and paste? 2. Is there a way to print...

Ken, Thank you for your help. I'll give it a try. Julie

(CR7) I create several reports with a landscape orientation. My users access and print the compiled reports through a network drive. The default for the network printer is portrait. Is there a way to have the report save the orientation/page size changes and override the default of the...