Hi ,
i am a little bit confused. I am setting up an Watchguard Firebox X550e Core. I am using the System Manager Ver. 10.2.2 and i didn´t get the access via firefox to the www. My internet ...
Hi all - I recently converted an Access 2003 mdb database to an Access.adp(2003)/SQL 2005 client/server set up. I'm trying to add a new record to an underlying SQL 2005 table via a form in the...
I have a MS Access project that connects to an MSDE database on the same laptop. I also have the same MSDE located on a server. Merge replication is set up between the two and is currently c...
I am developing an Access application using Access as the front end and SQL Server as the back end database.
I use the following code to populate one table with some of the fields from ano...
i am working on a adp for my company. it is sort of a trouble ticket program that links back to an sql server. i have used api calls to make the acces application transparent and then resize...
Thank you for looking at my question,
I have a MS Access query that I want to translate to SQL Server.
The access query extracts production date data from one table and calculates a shif...
I'm currently developing an Access.adp/SQL (Express 2005) database. I have a combo box on a client side form which inturn is based on a server side view. If I limit the number of fields to 7 t...
I am working with an ADP and seem to be missing something obvious. I am working with one table called LevelOfCareHistory.
The Main form is for data entry with pull down menus for the vario...
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...
I have an Access 2003 ADP that is linked to a .mdb. The sysem outputs a complex word document and does so by calling numerous sql statements to retrieve data. When we upgraded from SQL2000 t...
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 ...
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...
Thank you for looking at my question,
I have a working report in an Access database that groups data by Week, Date and Shift. I have tried to translate this same format to and Access ADP re...
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...
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...
Hi,
I have an Access 2003 ADP file that hooks up to SQL Server 2005. When I bind the view to a subform in Datasheet View, the Order By clause in the view's SQL does not seem to take effect....
I am developing an Access application using Access as the front end and SQL Server as the back end database.
I have 2 tables that I join and I want to combine the dollar field [Original Com...
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...
I am developing an Access application using Access as the front end and SQL Server as the back end database.
I use the following SQL UPDATE statement:
UPDATE ztbl_Source_SSFIII_NONGP_EO...
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...
Is there a way to recover a prior version of an ADP file if you make a change and you want to revert back to a prior version before the last change was made ? A backup copy ?
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...
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...
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...
