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 have a form with a textbox bound to the field ClientID. I need to get the value of this field written to a field in another table. When the current record on the form changes, I need the val...
Can we have multiple users accessing a Microsoft Access .adp file within Citrix using the same Citrix login credentials? We know we can have a single .adp file with different logins, giving re...
I am developing an Access application in Access 2003 using Access as the front end and SQL Server as the back end database. I run a stored procedure that has a result set of approximately 43,0...
I am developing an Access application in Access 2003 using Access as the front end and SQL Server as the back end database. The following subroutine titled StartDocLN works fine in my applica...
I am using Access 2003 to create an Access application using Access as the front end and SQL Server as the back end database. How would you write a query to convert the following detail record...
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 creating an Access 2003 application using Access as the front end and SQL Server as the back end database.
How would you change the following routines to cancel a user action to change...
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 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...
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...
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.
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?
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...
