Our company purchased a new computer with Microsoft Office Pro 2007. We've been running a Microsoft Access 2003 ADP for years with no problems. Since Access 2007 has been accessing our Windo...
Experts,
I have a query in my Access ADP project where I want to check a series of dates who are in the future (including if they match today). I can not use now() or getdate() as they will...
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 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'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 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 running Access 2003 on XP 2002 SP2. Something wierd is happening. I have an ADP file that I have been working with for several years. Just today, when I attempt to open any module or form...
Optional Parameters in Stored Procedure Did Not Return Any Records.
Access 2002 (SP1) and SQL 2000 Server
I have an ADP form that have a combo box and a text box, and I wanted it to do the...
The title says most of it. I am using a module in an Access ADP file to create a new table and then I want to export it using the docmd.transfertext function.
Since it is a newly created t...
Hi!
How can I create a subform where the RecordSource should be a stored procedure with parameters, I don't want Access to ask the user for values for the parameters, initially the subform ...
I need to increase the default max records value in Access 2007, (as per http://www.experts-exchange.com/Microsoft/Development/MS_Access/ADP/Q_23314833.html ) but what is childs play in Access...
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...
We have 20 sites that use the same version of our Access ADP file. They all have there own SQL servers. We do a weekly update with changes and at the moment we have to log in to that site open...
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 am working on an ADP for my company. It links into a MS SQL Server 2000 database. I currently use SQL authentification because this adp is going to be used on two different domains. I hav...
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 a command button that sends a report as an attachment to an email. I would like it to send as RTF and HTML. How do I do both? Below is the code for sending in RFT that I use, can I make...
I have an Access Data Project (2000, SQL Server). The following error message is occurring randomly on an DoCmd.OpenForm: "one or more operators in the filter expression is invalid. For a val...
hello
i m working on ADP Project files in MS Access . So i want to know if there is any function to
create ADP Files programaticaly.
waiting for reply
I've got a sample MS Access Project (adp) file (2003 version). Have a function created that works against the database. Now, I'm trying to assign a variable pulled from the function. But it...
I am developing an Access application with an ADP file. I am using Access as the front end and SQL Server as the back end database. How would you modify the following routine to add a new fiel...
Question: I am working with an Access 2002 .adp that connects to a SQLServer database over a network. There are several of the .adp front-ends on people's workstations and are networked to ...
Can someone help me convert this line of code to sql? I'm converting access.mdb to sql and stumbling on this line of code..
SELECT tblDisbBilling.[CLIENT NUMBER], tblDisbBilling.SubNumber,...
I recently upsized my database to SQL server. Now I get runtime error 102, incorrect syntax. I am not sure on what to do. Isn't Access suppost to make the conversion from VB to SQL? Here i...
