Search results

Sketchin, I'm don't know what the problem was. Yes, was set to visible in all locations I could find. As it wasn't a very busy form, I created a new one, literally copied the cells from the original form to the new one, (cut and paste), copied the code to the new module and it works...

I have copied the working form from the access version into the database with the same results. One by one, I have removed the data fields from the form, commenting out the appropriate code. All that is left is a form with labels on it. It still will not show! What am I missing? Thank you!

Hi, Sketchin, Yes, there is data in the tables. While walking thru the code, I can see the "rs" values as the values are processed i.e. as in Me.cmbOwner.AddItem rs("PetroID") I can see the value by putting the cursor on the rs in the above code and by putting debug.print rs("PetroID") in...

Hi everyone! I've got a 2010 access database that was coverted from an access backend to an sql backend. There is one form in the sql version that will not display. It works correctly in the access version. In the sql version, it produces a tab and a blank screen. If I go into design mode...

Pat, Understand. In the string, all text fields were '" & rs(?) & "', (single quote, double quote, & ... & dq, sq) the numeric fields were " & rs(?) & " (dq & ... & dq). And there are dates referenced as well. Your last 3 lines probably hold the key. I will config accordingly and...

Bob, Here is the SQL. rs.Source = SqlStr rs.Open Do While rs.EOF = False iCnt = iCnt + 1 sUserId = FillUserId() SqlStr = "Insert into tempExportsForMerge values (" & iCnt & "," & rs(0) & ",'" & rs(1) & "','" & rs(2) & "','" & rs(3) & "'," SqlStr = SqlStr...

Thanks for the help, Pat! I appreciate it! The majority of the queries seem to be functioning correctly, just a couple I've found so far that are being obstinate. I'll make some changes and see what develops. Thanks again! Earl

Hi, all! I have an Access 2007/2010 database that is being converted to use SQL tables. I have one insert query that is giving problems. By using debug.print, I can grab the query, drop it into SQL Server Mgt Studio and run it w/no problems. But when trying to run it thru Access, it errors...

Agree w/AccessMSSQl... Have same situation here. Users running Office 2010 and 2007. Coding is done in 2010. Open the database in 2007, go into vb, check for missing references, replace with correct ones for that version of office. Compile it, create accde and implement. Maybe not the best...