Recent content by RichM1

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