I have the attached code running on an access database. However when i move it to ADP with SQL backend it stops working.
Need help with this asap please. Any help is appreciated
Hi there, im looking for a way to use a button in an access ADP database that will drop all the data from an sql query to a excel file on our network.
I need the server to do the drop inste...
I have a database with 6 tables.
When creating a new record 3 tables will be populated at once, currently im populating the 1st table using the code attatched. This creates a new recorord a...
I have the attached code running on an MDB file which is linked to the sql tables. I am im the process of making a ADP file to run the database, the code below runs fine on an MDB but wont wor...
i am working on a help desk type of program for my company. i have an access adp where people can post requests for help, briefly describe their problem and such. well, admins can post comme...
I have an Access 2003 adp. Im trying to load another Access project from within where I build up the file name from a number of fields and parameters.
THe spaces in the path name is causing a...
i am changing my database to adp format with an sql backend instead of a purely access ldb/mdb file and i have come accross a problem with a report of mine.
The buttom that ran the report h...
We use an Access 2007 adp to connect to our hosted SQL database which contains a table holding the result of various online questionnaires (currently has around 350000 records) for our clients...
I'm creating a report from an Access adp which is output to Excel. Some calcuations need doing on the data once the sheet is populated. One of these is currently done by:
For x = 1 To rst...
I am developing an Access 2003 application using Access as the front end and SQL Server as the back end database. How would you write a SQL Statement to backup a table named
tblBranchFallExc...
I am using Access 2003 with Access as the front end and SQL Server as the back end database.
If you use the Access report writer and it generates a report of 70,000 records, is there a way ...
I manage an access adp and mdb solution that connects to an SQL Server 2000 database over a small LAN in a 10 person office. The database was upgraded to SQL Server 2005 over the weekend. We...
How would I go about adding a class called CExcelMonitor to an ADP file and add this code to it:
(Would I perform an INSERT ?)
-------------------------------------
Private mstrFilePath As ...
Hi experts,
I have an .ADP project that connects to an SQL Server database.
There is one form (Form1) with three fields: Year, Period1, Period2 and one button.
On the OnClick event of the b...
I have created a Data Access page in Access and when I browse to the page it seems to be in a Read only mode. I checked the help and it says If you do not have a Microsoft Office XP software l...
I have a long-established MS Access project that's linked to a remote SQL server installation. A recent system crash on my main development PC forced me to do a system restoration and to reins...
I have an adp database that i am trying to build at the moment. Ive got all the search functionality etc working, however when i try to edit any of the data in the ADP it is all in read only m...
I have an ADP upsized from and mdb. Some of the queries are not allowing changes to the data. I have found that the queries that are created from more than 3 tables give a "the Recordset is no...
Does anyone know where I can find a free SQL Server Database on the internet where I can practice writing ADP Access applications against it?
Any good documents on how to convert from Access 2000 to Access 2000 Project (or later). I've got a lot of code to convert.
I am developing an Access 2003 application with Excel.
I create an Access table via a stored procedure and transfer it to an Excel file for user viewing with the following statements.
Do yo...
