Search results for query: *

I have developed an access application which contains lot of VBA for business users. In order to avoid the access database to get corrupt, I plan to create a .accde version and provide it to the business users. The business users need to query the database to perform their other function, but...

I am new to SQL server 2005 and I am trying to work on a project to invoke an existing webservice from SQL server 2005. (This webservice which is a .WSDL file is already being used by another Java application and this webservice connects to mainframe and brings data back from Mainframe). Can...

Thanks to all of you. The string definition worked.

It works if the object names are mentioned directly in the Docmd.Transferdatabase. But I was looking pass the object name as a parameter/variable in the command, because I would like to create the Table name every month dynamically, by concatenating a string of table name with the specific...

I got rid of all the quotes and ampersands. The command I am using right now is Dim TableToCopy As TableDef Dim TableToCreate As TableDef Dim myDB As DAO.Database Set myDB = CurrentDb Set TableToCopy = myDB.TableDefs("Report_Curr") Set TableToCreate = myDB.TableDefs("Report_Oct")...

I changed the 'as' to '=' Set tdf_create = db.TableDefs("tblcreate") The compile error goes away, but I get a run time error 3265: Item not found in this collection. Should I have the table created? But, I want to create a new table in the VBA code every time rather than have the tables...

I am getting a compile error for the statement. Set tdf_create as db.TableDefs("tblcreate")

I am getting a run time error 3011: The microsoft database engine could not find the object '& TableToCopy &'. Make sure the object exists and that you spell its name and path name correctly when I use the below command to copy a table with its structure and data in the same database. I am...

We have an access database with heavy VBA code in access 2007. This was originally developed in access 2003 and converted to access 2007. This database resides on the network location. Recently whenever users try to access this application (especially remotely) and for some reason they get...

Toyfox, Thank you very much for your reply. The Dec.16 2008 hotfix did help the performance of the Access 2007 app we had. The database started performing like it did in access 2003.

We recently migrated a heavy VBA Access application in Access 2003 to Access 2007. This application resides on a network. This application has lots of forms, reports and modules. This application is performing awfully slow in access 2007. When users are using the application, they have to...

We just migrated from access 2003 to access 2007 version. The form that was working fine in access 2003 is now giving Run time error 3021: No current record when doing a rs.movelast. The form opens a new record. After we enter a record and go back to the form again, when it is supposed to load...