473,568 Members | 2,964 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

VBA - send access data to WORD doc using Access FORM

2 New Member
Hello,
I am new to VBA programming - thank you for your help. I am using a form in Access 2007 to update my database. I use a submit button on the form to send all the values into Access. I want that button to do two additional things, open a pre-defined word document, import a few values into that word document in specific places. These values were entered into the Access form.

This is a for a school and we use Access to track teachers who are borrowing laptops and what equipment received with the laptop. The form uses 5 boolean yes/no checkboxes to identify sundry equipment but often times the teacher does not get all 5 pieces - it is therefore important to track exactly what the teacher did get as they are made financially responsible for missing items.

thanks!
Aug 18 '10 #1
0 1430

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

Similar topics

1
1762
by: Aravind | last post by:
Hi guys, In c#, How to dispaly the records from a AccessDB to a Windows Forms DBgrid.. Is there any need of creating datasources like in VB data access.
0
457
by: BerkshireGuy | last post by:
This code, opens a mail merge and prints to my default printer. How can I modify this code to print to a specific printer on the network and a particular printer tray? Dim WordObj As Word.Document Set WordObj = GetObject("C:\MyMerge.doc") WordObj.MailMerge.Destination = wdSendToNewDocument
0
1605
by: choknut | last post by:
guys i am a newbie in vb.net programming and want to seek help regarding my current program..i have an existing access database and want to use vb.net as to generate a report.question is how can i access a certain data(say "account") in a table named "customers" so that when i click the "search" button on the main form, all of the data in...
4
2589
by: freeskier | last post by:
Currently I have some letters set up in Word which merge off of an Access database. A window pops up and asks for the parameters of the query to be entered in a text box. Is there any way that I can use a combo box instead? If I merge directly in Access using VBA will I be able to use combo boxes? I have read that using VBA in this manner may...
3
1432
by: Boogie | last post by:
I watched my friend do this about a year ago, and was just wondering if someone could point me to an article. THe database that im making is extremely simple. I do not believe there is even 1 calculation. its all just personal information about clients and there computers. Any pointers would be very helpful thanks!
7
1976
by: Finger.Octopus | last post by:
How to access data from MS Access? I tried ADOdb for Python but it doesn't seems to work. Even the official examples dont work, like this one: import adodb conn = adodb.NewADOConnection('access') # mxodbc required dsn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=d:\\inetpub\\adodb\ \northwind.mdb;" conn.Connect(dsn)
2
2137
by: rajaaryan44 | last post by:
how can we transfer data from one access database to another databse . the table name is same for both the database . in one table some records are there (rs say e.g.) now another table has say rs+10 records . now i have to pass there 10 values to another table with same name . can anyone help me with this. i m usinf DAO . i wrote some codes in...
1
2312
by: marinos | last post by:
I have found a small access file which mass mails based on a table (created by Jerry Whittle some years ago). In that same file, the user can select to send tables or queries of the same db in rtf format. Is there a way to choose an attachment from a different location (i.e. a pdf file) and send that as an attachment to all? Thanks ...
4
2003
by: chowdhury | last post by:
Hi, I am new in visual basic. i want to know how to connect and access data to MS Access or MS SQL database from a visual basic form.plz write me the code. Regards, chowdhury
3
4999
by: brat33 | last post by:
I am trying to use a command button to automate a process for creating mailing labels from a query in Access 2007, going into word 2007. Current code looks like the following: 'Start MS Word Dim objWord As Word.Application Set objWord = CreateObject("Word.Application") 'Make Application visible With objWord .Visible = True ...
0
7916
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7660
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7962
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6275
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5217
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3651
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2101
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1207
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
932
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.