Search results for query: *

Mark, thanks for the reply. I can't use local tables since I'm in an Access Project connected to an SQL server. I like the idea of using a text file. Can you provide any assistance with working with a text file and storing printer information? Thanks

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 think I can figure it out for now. Thanks for your help.

Anyone?

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...

Yes, the recordsource is set as CreateBarcodeLabelsPG3. I did the watch and the input parameters are being set correctly with the correct values. For some reason the input parameters are not receiving the results. I tried changing the input parameters to this: @Initial=forms![create barcodes...

Still doesn't work for some reason. I tried establishing a filter when form opens which yielded the same results as when I tried using a SP, just a blank form with no buttons, boxes, etc. Long story short, max records wasn't set high enough. Is there something similar I'm missing on the server...

cmmrfrds, Serial Number should've been an integer not floating. Anyhow, I tried what you said and no matter what I try it won't work. When the form is opened it asks for the parameters to be input. Here is what I have in a round about way: Prior Form (prior to opening form with problem): dummy...

Oops the SP is this - sorry: ALTER PROCEDURE dbo.CreateBarcodeLabelsPG3 (@Initial float, @Last float) AS SELECT [Serial Number], Description, [P/N], Customer, [Customer P/N], [Claim Number], [Date Received] FROM dbo.Inventory WHERE ([Serial Number] BETWEEN @Initial AND @Last)

The input parameter is: @Initial = forms![create barcodes pg3]![initial], @Last=forms![create barcodes pg3]![last] I've also tried: @Initial = forms.[create barcodes pg3].[initial], @Last=forms.[create barcodes pg3].[last] The SP is this: ALTER PROCEDURE dbo.CreateBarcodeLabelsPG3...

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...

Is there anyway to set the temp table as the recordsource of a form?

cmmrfrds, two questions" 1) How do I create a temp table on the server using ##? 2) What happens if multiple users try to use or create a temp table with the same name? THANKS

cmmrfrds, I planned on using your concept but was just inquiring if a "local" or temp table existed in an ADP. A bit more work but it will work well. Thanks

What I'm trying to do is this. I have a number of users that are creating part entries in which a sequential serial number is generated. When a user creates a number of new serial numbers I immediately place these serial numbers into an inventory table so that another user doesn't use the same...

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...