I am developing an Access 2003 application using Access as the front end and SQL Server as the back end database.
How would I be able to go to the following website based on the click of a...
Hi - I've recently converted an Access 2003 database (. mdb) to Access 2003 .adp front end / SQL 2005 Server backend and in the main it works very well. When I uploaded the Access 2003 .mdb ta...
Hi i am trying to open a form show records from today, the last 7 days and the last 30 days depending on which selection is mad in an option group.
I have tried the following with no joy...(j...
Hi All
we have just been experiencing a problem with our ADP imported files to a computer. when we import this file - in the properties on the general tab - open with adobe acrobat 6.0 is ...
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 am working on an application the has an Access adp as the client and SQL Server 2000 as the database. I want to control access to certain forms and reports as well as access to certain fiel...
I am using Access to develop an Application using Access as the front end and SQL Server as the back end database. In the following VBA code, I export an Access table to Excel and the applicat...
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,...
What causes Access to jump into debug mode when there are no breaks nor bookmarks set?
Decompile and then recompile will fix it, but what causes it?
This happens in my Access 2007 adp as w...
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'm finally fed up with Access ADPs and Microsoft's lack of proper support. ADPs have hit the end of the development road in MS's mind and I can't handle the lack of productivity (due to crash...
I have seen some posts on the internet (i.e. Expert Exchange) regarding this, but would like to try a new question. I am having the same problem.
I have an Access 2007 project that was once...
When developing an Access application using Access as the front end and SQL Server as the back end database, can the following 2 queries be combined or would they have to be executed separatel...
Our client runs an Access XP ADP which connects to a web-based SQL Server 2000 database. At the client's site they are experiencing frequent connection drop outs, and receive the following me...
Hi
I have a potential client who is willing to pay quite well for a database to be developed. It will run on Microsoft SQL 2005 as the back end, with a Microsoft Access 2000 ADP as the fron...
I'm using a checkbox in a Access 2007 form in an ADP file connected to SQLexpress 2005. The underlying field is currently a tinyint, but I have tried everything I can think of including a flo...
I do have now Access2007 and can't import/convert my adp-db, therefore have to do all new. I just made my first form where nothing works with my former instructions, even an event to change th...
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...
O.K. my brain is about to explode. I have the following code in an Access ADP (2003):
Private Sub cboSelectTag_AfterUpdate()
Dim db As DAO.Database
Dim rs As DAO.Recordset
...
I have a problem with an Access ADP that I am trying to modify. I did not write the app originally and I'm learning as I go.
The problem I'm having is that I need a subform within a form to...
This is from an Access ADP application - Access 2003 / MS SQL Svr 2000
I am using the code below to perform an update query when the user clicks a button on a form. The update query works g...
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...
What is the vba syntax to get the name of the current SQL Server Name and Database Name being used?
I want to pull that data and change the color of my main form based upon the value in the...
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...
