Results 1 to 7 of 7
  1. #1
    dr_destructo is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    17

    How To Create A 'One Time Use' Form

    Here's the rundown: I have a form with a subform for taking orders. With the click of a button, this information is transferred to a report which we will use as an invoice. At the top of the invoice, we have all our information(address, email, phone etc..). What I would like to do, is be able to make a form where I would only have to input the contact information once, and have it appear on all invoices we print out. Where I'm running into issues(which are pretty obvious), is there is no set relationship between this contact information and the report. Is what i'm looking for even possible, or am I stuck designing the report and entering the information manually?

    Many thanks in advance!

  2. #2
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    Correct me if I am wrong but you need to put your companies information on the report like address, email and phone number. Assuming this is the same for all invoices why don't you go to the design view and use labels to display these information on the Invoice.

    if this solves your problem mark the thread solved else please give more details.

  3. #3
    dr_destructo is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    17
    Great question, I should have given this info previously. The company I work for has hundreds of accounts that could all potentially use this. So I'm wanting that specific piece of the invoice to be customizable from account to account.

  4. #4
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    so basicaly let me get you straight for different accounts you will use different info. Is there a specific relationship in this. like accounts A,B,C will use info 1 accounts D,E,F will use info 2

  5. #5
    dr_destructo is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    17
    Negative. Each account is located in different cities & states with different people in charge of taking orders. So each account would need their own personalized information.

  6. #6
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    so basically here is what I need to do. Orders are catagorised according to location depending on state and city. After the cassification is made it has to be assigned to an account of a person aganist whom the order is to be registered i.e. he wil be responsible see the order requirements are met. Kind of chain marketing concept. If I am right just let me know.

  7. #7
    dr_destructo is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    17
    Essentially, you are correct. Though the orders aren't actually catagorized. Think of it more as each account creating their own letter heading.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to create a Password Form
    By heman85 in forum Forms
    Replies: 1
    Last Post: 07-07-2011, 11:49 AM
  2. Create a report based on a pop-up form
    By p4ck3tl055 in forum Reports
    Replies: 1
    Last Post: 03-29-2010, 09:38 AM
  3. Create Textbox with VBA in an existing form
    By ferrarih in forum Forms
    Replies: 0
    Last Post: 02-24-2010, 06:17 AM
  4. create calendar form
    By nwalke in forum Forms
    Replies: 0
    Last Post: 06-30-2009, 10:35 AM
  5. Replies: 1
    Last Post: 03-02-2009, 11:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums