Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RichM1

    Changing printers in MDE or ADE

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

    Changing printers in MDE or ADE

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

    Printers in ADE

    I think I can figure it out for now. Thanks for your help.
  4. RichM1

    Printers in ADE

    Anyone?
  5. RichM1

    Printers in ADE

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

    Recordsource - Input Parameters

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

    Recordsource - Input Parameters

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

    Recordsource - Input Parameters

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

    Recordsource - Input Parameters

    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)
  10. RichM1

    Recordsource - Input Parameters

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

    Recordsource - Input Parameters

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

    Multiple users - temp table

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

    Multiple users - temp table

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

    Multiple users - temp table

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

    Multiple users - temp table

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

    Temp table - multiple users

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

    Multiple users - temp table

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

    Record Source Qualifier DBO??

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

    Data Link Properties window ADP

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

    Data Link Properties window ADP

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

Part and Inventory Search

Back
Top