MS Access New Record and Printing VBA Codes

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sinfulm3
    New Member
    • May 2010
    • 3

    #1

    MS Access New Record and Printing VBA Codes

    hello. i have an mde file where i want to copy the codes that i want to attach in to my new database or someone will give a sample mdb file.

    - in the "Repair Authority Form" if you click it there's a form that will pop-up. And there are two boxes. In the 2nd Box (No. of Workorders) in there i input the number of blank forms that i want to print and it will create new records and it will all appear in the print preview.

    For example if i input 10 it will create 10 new unique records since it is in autonumber(work order_ID) and all 10 pages will appear in the print preview.

    hope you guys can help me. thanks.
    Attached Files
  • slenish
    Contributor
    • Feb 2010
    • 283

    #2
    Originally posted by sinfulm3
    hello. i have an mde file where i want to copy the codes that i want to attach in to my new database or someone will give a sample mdb file.

    - in the "Repair Authority Form" if you click it there's a form that will pop-up. And there are two boxes. In the 2nd Box (No. of Workorders) in there i input the number of blank forms that i want to print and it will create new records and it will all appear in the print preview.

    For example if i input 10 it will create 10 new unique records since it is in autonumber(work order_ID) and all 10 pages will appear in the print preview.

    hope you guys can help me. thanks.
    After reading your post several several times, im not really sure what you are looking for help with??

    If you trying to get to the back end of your Forms in order to see the code in the forms and so on. You will need to get the orginal MDB file. The file you have posted is an MDE file which is a read only file and will not let you get to the back end of the forms.

    Hope this is a start for you

    Comment

    • missinglinq
      Recognized Expert Specialist
      • Nov 2006
      • 3533

      #3
      As slenish has said, you have to have the MDB file that your MDE file was based on, in order to access the code.

      Posting your requirements and/or attaching an MDE file and basically asking someone to design your form/app is not how things are done here, or at any other Access forum, for that matter.

      From NeoPa:
      We don't do full-code solutions here. That's not what the site is about. We help YOU to code and/or learn how to code... If there are any specifics you need help with please feel free to ask. This may well include some code samples for illustration purposes that you may even find you can use, but it will not just be done for you.
      As NeoPa said, we'll be happy to help you with your project, but we're not going to do it for you.

      Welcome to Bytes!

      Linq ;0)>

      Moderator

      Comment

      Working...