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 the SQLServe...
I was a stored procedure, which I use to return a recordset, which is then dsiplayed in a list box.
I wrote the code in the attached snippet. All works fine in Office 2003. However, on Office...
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,
I have a stored procedure which I use to extract recordsets for a continuous popup form. I pas parameters to this SP successfully and all works fine.
However, As the parmaters are ba...
Can you please advise how to create a public outlook folder (for emails) using Access vba?
I am creating an Access Project (Access 2003) connected to a SQL Server 2005 database. I need to present the results of a query (Stored procedure? -- ADO? -- View?) to the user on a form and ...
I am developing an Access 2003 application using Access as the front end and SQL Server as the back end database. I use the DoCmd.Transferspreadsheet command to transfer an Access table to Exc...
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
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 would like to know people's opinion on turnaround time when building a custom software app using an Access ADP versus VB.net and the further upside versus downside in deploying the software ...
We have a large Access 2003 database - the Customer table has 300K records and the Transactions has 325K - multiple transactions per customer. We have a form in Access that brings up all 300K...
I am having difficulty with a ADP project, specifically regarding ADO / SQL usage.
I'm currently in the process of writing a function to return a resultset from a SQL table (SQL Server 2005...
Is there a way to have the package wizard in Access 2007 provide a way for the end user installing my program to determine where the back-end will be installed? If not, is there a 3rd party p...
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...
I have a text box which I validate as "must be equal to Y or N" in a Before update procedure.
I the check fails I use a cancel = true.
This works fine if the user presses the enter or tab ke...
I have an Access Data Project that has an ntext field. I want the end user to be able to enter a word and have the database search the contents of this field for that exact literal string. I...
When i open my adp file i get the following message, Microsoft Office Access Security Notice, A potential secrity concern has been identified. becasue im using VBA code its asking am i sure i ...
I built a ton of 2000 databases and loved the Access ADP (Access Data Project) files as a development tool. I've started building some SQL Server 2005 databases. I tried to make a connection...
i have an adp that dumps data into an excel spreadsheet for a report. i use the adp to do some formating on the spreadsheet. Right now i am trying to get the page breaks right.
I know you...
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...
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...
First, I am an idiot in Accessjust struggling through! This is something I should know how to do, but it isnt working.
I am trying to build an if-then statement in my query. I have one fi...
I am developing an Access 2003 application using Access as the front end and SQL Server as the back end database. I use the following routines to transfer an Access table to Excel and display ...
I have a small access adp that I developed using access 2007. I tried to open it in access 2003 and it opens fine but all the command buttons quit working. Actually it seems that anything that...
Hello, I have an adp with a field in a tbale that populates the field automaticaly with the default value of todays date. The data type is smalldatetime length 4 and in the defaultvalue I have...
