Results 1 to 7 of 7
  1. #1
    Nate74 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2013
    Location
    Southern CA
    Posts
    10

    Can one button Save & Open a New Form?

    I finally have my quote generation form running. You enter a few variables into text boxes, select two things from combo boxes and several text boxes autopopulate with calculated values.

    My next step is to add a button to this form (Form1) that will take the current values of many of these boxes and put them into a second form. The second form is meant to be in a layout similar to our current quote format and won't show some of the customer specific (proprietary) information from Form1. I have the second form all set up with the links back to the Form1, but unless I hit CTRL+S on the first form, the second form opens with the wrong information.

    Is there a way to make one button on Form1 save all the information AND then open up the second form?



    Thanks.

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,847

  3. #3
    Nate74 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2013
    Location
    Southern CA
    Posts
    10
    Ummm... OK. Informative, but not helpful for what I'm trying to do now. I don't anticipate being an Access developer. I just need this beta version to work well enough to present to my bosses to secure budget to hire somebody to develop this thing fully. SO in this instance, I really just want a fish today, not to learn to fish for a lifetime.

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,847
    Then why not use something like powerpoint. Make few pretty slides, if it's only a concept.

    Good luck with your project.

  5. #5
    Nate74 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2013
    Location
    Southern CA
    Posts
    10
    It may come to that. But the first form is pretty slick, as it's pulling data from our actual materials library and our actual customer files. My thought was if I let the VPs mess with the interface a bit and actually see real information populating it, they'd be more inclined to a) believe what I want to do is possible and b) go along with it. After fighting my way through understanding of DLookUp for 2 days, I'm not retreating to powerpoint.

  6. #6
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,847
    Great! Forms are sort of a window into Tables. Table design and relationships are key to getting info in and out.

    If you want to post a version of what you have - no confidential info - and a clear statement or a before and after picture of what you want, I'll take a look.

    Have you looked at the Openargs for a form; and you can OPen the 2nd form by clicking a button

  7. #7
    Nate74 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2013
    Location
    Southern CA
    Posts
    10
    Thanks!

    I'll do my best to describe where I'm at and where I'm hoping to go. I apologize if I don't use the correct terms for things... I literally started this project 2 days ago and hadn't used Access for about 10 years...

    In this database, I have three tables. Two are material specific (tblAlloyData & tblAlloyPricing), one is Customer specific (tblCustomerData).

    The first form allows the user to select the Alloy to be used from a ComboBox that references the primary key of tblAlloyData. Then they put in key dimensions for the part so that an autocalculate can determine the volume of the component. This is shown in a text box. Another calculation occurs where the volume is multiplied by the density from tblAlloyData. This too is in a text box. Then that weight is multiplied by the $/lb of the alloy that comes from tblAlloyPricing.

    We now have an estimate of what the RFQ is actually worth and it's shown on the form in a nice red box.

    The second part of this first form allows the user to select the customer from a second ComboBox. There are several customer variables that then autopopulate (DLookUp) some boxes from tblCustomerData.

    The goal is to take a look at the Customer, their order history, payment history etc. and then look at the estimated value of this particular RFQ and decide if we want to quote or not.

    So if they "pass" the test, I want to have a button on that first form that will open a second form that will be the actually summary quotation (or maybe a report), that will have the customer's name, the alloy, the part description and the pricing (from the first form) along with some standard stuff like our company name, address, standard terms, etc.

    Longer term (or maybe I need to do this now), if the quote does get generated, I'd like to store it in a table. I wasn't going to tackle that for this demo version, but if it's needed I certainly can.

    Besides geeking out a bit on all this I'm realizing the more I learn about Access, the better suited I'll be to manage this project if it gets approved

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

Similar Threads

  1. Replies: 5
    Last Post: 12-19-2012, 01:05 PM
  2. Replies: 3
    Last Post: 10-08-2012, 08:40 AM
  3. What makes form 'design save' before open?
    By bhammer in forum Forms
    Replies: 2
    Last Post: 04-23-2012, 03:08 PM
  4. Form Button loses functionality after Save
    By gregu710 in forum Forms
    Replies: 2
    Last Post: 01-17-2012, 05:13 PM
  5. Replies: 1
    Last Post: 07-18-2011, 03:08 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