Recent content by databaser

I need to create a reference to a 2003 Access database's subprocedure from an Access 2007 database. I want to run the subproceedure then delete the reference.

I need to create a reference to a public subproceedure in an Access 2003 from a Access 2007 database. So, I can use the proceedure then delete the reference when I done.

My problem is when Excel saves a csv file and the columns on the end are null. The csv file has commas for all the columns for only about 16 rolls. After that it just stops putting the commas in for the null columns. How can I test using VBA to see if I am at the end of the line and no more...

That did it. Thank you!

Skip, Thanks for responding. Here is the code I create the query. Public Sub GetCrosstab() Dim db As Database, rs As Recordset Dim SQLCross As String, SQLCross2 As String, qfd As QueryDef Set db = CurrentDb On Error Resume Next db.QueryDefs.Delete ("VendorMonthYTD") gblVendorGrouphold =...

I have a query I create from VBA on the fly. It is timing out when I try to export it. I need to set the ODBC timeout property from my VBA code. Can anyone help with this?

I need to truncate all records from a work table that reside in an Access Project database. This works but there has to be a faster way. Strsql = "select * From DataWork" tblVendorSalesRpt.Open Strsql, CurrentProject.Connection, adOpenDynamic, adLockOptimistic If Not tblVendorSalesRpt.EOF Then...

I need to deactivate the Mouse Wheel while in a form.

I creaded a move next and a move previous command buttons. I want the move next to go to the first record when it moves past the last record and not to a new record and visa versa on the move previous.