473,289 Members | 1,840 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,289 software developers and data experts.

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(workorder_ID) and all 10 pages will appear in the print preview.

hope you guys can help me. thanks.
Attached Files
File Type: zip Robust_Computers_Modified.zip (228.8 KB, 109 views)
May 30 '10 #1
2 1827
slenish
283 100+
@sinfulm3
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
May 30 '10 #2
missinglinq
3,532 Expert 2GB
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
May 31 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Samuel Lee | last post by:
Could anyone convert the following vb 6.0 codes into vb.net version? '************************************************************************ '** Button to print a sales receipt - spool print...
3
by: Vic | last post by:
Dear All, I have been developing a small access database, but I am new to security concepts with access. This is a multiuser database, I have a table which will be written by various users...
0
by: Megan | last post by:
Hi- I have a question about the Microsoft Access Record-Locking Information Icon. Whenever I, or my friends, open my MS Access database, the Microsoft Access Record-Locking Information Icon...
0
by: htmlgeek | last post by:
I'm adding and updating records in an Access .mdb via WWW .asp page. Authored in Dreamweaver 2004 MX. Help is welcome on this one. I have a great set of pages that work fine, but it seems that...
3
by: ChadDiesel | last post by:
I've been posting questions here the last week, but if you don't know my situation: I have a "Print Labels" button on the subform that sends the appropriate box information on the subform to a...
0
by: Randyb | last post by:
I have an Office XP Access Database with a report "Weekly TimeSheet" in it. I am trying to print out the report from vb.net(2003) without having the users to run access and print the report...
8
by: PW | last post by:
Hi, There is code in Alison Balter's excellant "Mastering Access 2003" to create a list of error codes and descriptions but it only generates error messages 3 through 94. Is there a website...
0
by: john | last post by:
When I copy an Access record to the clipboard it automatically copies the field names along with it. In this particular case I don't want that to happen. Is there by any chance a way to only copy...
1
by: pkibefa | last post by:
I have been asked to develop a database that will hold all the records for mails in the department that I work with. I am using MS Access and having problem to print a report, say weekly of all the...
1
by: pusparaj | last post by:
I had developed an application using MS Access 2003 and in my reports I have no problem whether viewing or printing it in one page from my PC or Notebook. Also no problem when I opened this...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.