Search results for query: *

I need a creative way to save the last printer that a user chose for a particular report in an MDE. The problem is that there is currently no user logins to store a printer to that person in a multi-person environment. Any ideas are appreciated...

I'm using Access 2003 with connectivity to an SQL server. My question is, when I create an ADE from my ADP it appears that users can not save settings for printers. In particular I need a user to set a specific printer and have that printer never change for that report. The problem: access...

This should be easy I know, but it is frustrating me. I can write all sorts of stored procedures but can't figure this simple sp out. All I want to do is to open a form and have a SP set as the recordsource. Here's the problem: when the form is opened there are two fields that are hidden...

I am working in Access 2003 (ADP) with SQL Server 2000. Before upsizing to an ADP I used a local table on each user's front end mdb to perform some minor record changes. Question: In an ADP how do I create a temporary table and what effects would a temp table have regarding size. Do I create a...

I am working in Access 2003 (ADP) with SQL Server 2000. Before upsizing to an ADP I used a local table on each user's front end mdb to perform some minor record changes. Question: In an ADP how do I create a temporary table and what effects would a temp table have regarding size. Also, how do I...

I have a database that I upsized to an ADP. I'm using Access 2003 and SQL Server 2000. When I connect to the database as an administrator everything is fine. The problem occurs when I login as a different user. For some reason reports and some stored procedures will not run but they are present...

I have an access project ADP connecting to an SQL server that I'm rolling out to a bunch of users. The problem: I need to incorporate some sort of simple user interface to allow users to modify the connection properties to the SQL server. The Data Link Properties window (in access 2003, go to...

I have an access project ADP connecting to an SQL server that I'm rolling out to a bunch of users. The problem: I need to incorporate some sort of simple user interface to allow users to modify the connection properties to the SQL server. The Data Link Properties window (in access 2003, go to...

I've been working for days on trying to import a simple text file which is in the format below (16 columns, each separated by a ;) MF;;Admin;;;21152;SB WCTR LAB;11/07/04;21:44:44;1;;;;;;0 I've tried the following command which doesn't work because this looks for commas as a delimiter. This...

I've been working for days on trying to import a simple text file which is in the format below (16 columns, each separated by a ;) MF;;Admin;;;21152;SB WCTR LAB;11/07/04;21:44:44;1;;;;;;0 I've tried the following command which doesn't work because this looks for commas as a delimiter. This...

I have a large task to undertake, or atleast I think I do. I have an access bar coding program that I wrote a number of years ago in Access 97 which consists of a front end (forms, reports, modules, etc) and a backend (.mdb) which consists of all data. The company would like the program...

I have a large database in which I'm trying (or will be trying) to access data from SQL 2000 from an Access 2000 front end. Currently the system has an Access 97' front end and an Access 97' back end (data only) in which I plan on taking the back end to SQL 2000 and the front end to Access 2000...

I have a large task to undertake, or atleast I think I do. I have an access bar coding program that I wrote a number of years ago in Access 97 which consists of a front end (forms, reports, modules, etc) and a backend which consists of all data. The company would like the program transitioned...