Create A Custom Word Form Letterdoc From Access Data
May 13, 2005
For keeping record of provient fund, I have made a access/(or excel) database with many fields like ID, Name,contribution for months eg March, April,..to..,Feb,etc.It contains 50 records.
Now I have to print the provident fund statements of my 50 friends. This statement consists of some text language and some data(It is a word form letter document).The statement also shows some data which has to be calculated from the data of database eg grand total, cumulative total, interests etc.
Now I want to print the statement for all or selected no of people. What I want is to make the statement proforma in another excel sheet and then merge and print the statements for selected no of persons eg for ID 1 to 20, 50 to 70 etc. I do not want to make statement in MS word and do not want to merge it there, but I want to do it in excel just as we do in MS word mail merge.
Pl help me how can I do it in access/Excel? Can i calculate in word or should I calculate before hand in access before merging data?
I was wondering if it is possible to create custom security permissions in access. For example I have created an employee database, with security. I would like to have it when a manager logs on, it will only display his employee's information and no other departments. Is this possible?? In one of the tables is a field for the department the employee works on, can it based off of a table field?
I want to create a new word doc, do a saveas to a specific path and file name, allow the user to edit the new doc, and then close it and return to the Access app. I can create the doc but Word opens without opening the New Savedas Doc. using this code
Dim oApp As Word.Application Dim WordDoc As Word.Document Set oApp = CreateObject("Word.Application") Set WordDoc = CreateObject("Word.document") oApp.Visible = True WordDoc.SaveAs ("TS-" & Me.Scriptnum & ".Doc")
I am working on a project where I need to upload selected data from multiple sheets of an excel file. Here is an example of what I want.
1. I want to create a table in Access with around 10 columns 2. Column 1 should be populated with the date field found in A2 cell of sheet 1 of the excel file 3. Column 2-5 should be populated with the columns B2-E200 in sheet 2 of the excel file. 4. Columns 6-7 would be populated based on values from columns 1-2 of the table. Basically Column 6 should be Column 1 date plus 60 days. 5. Column 8-10 would be user generated after the excel is imported and the user should have the ability to attach around 5 files to each row.
I'm strugling with transferring data from access to word template.
1. transferring single data fields works okay, with bookmarks etc.
2. transferring multiple records (e.g. orderlines) to a WORD template fails. The # of multiple records are variable. So could not be defined upfront how may records i have to transfer.
I tried to transfer the data in a word table both with bookmarks and with merge fields. The result was that all data was placed in de first cell of the table in WORD.Setting up de WORD template combining with the VBA code.
See VBA code:
Private Sub Knop17_Click() On Error GoTo Err_knop17_Click Dim sreportname As String Dim scurrentdir As String Dim stemplatedir As String Dim stemplatename As String Dim ObjWord As Word.Application Dim ObjDoc As Word.Document Dim bm As Object
I have a database for call outs, i had a problem with double booking, but cured that, my problem now is every time my work mates try to book me in that go into the debug box (accidently) all i need is a ok button only msgbox to say the time is already booked. can anyone plaease help.
I'm doing a project for my work. I created a few reports in Access. Some of these reports are simple graphic bars. How can I insert these reports into a word document template?
I have a table in MS Access 2010 with a Date field and 3 Memo fields. I wish to append data to the Access table from a MS Word doc that has a date field and 3 memo fields. My wish is to have a command button on the MS Word doc which appends the data to my Access Table.I am aware that a web page can append data to an Access table.
I often create contract using mail merge. I have an access file that I want to use as data source for word file. But it does not automatically.
Please see the attached file !
If there are 1 customer and 1 property, I do not need to do anything. Conversely, if there are many customers and many properties, I take time to manipulate.
Firstly, I open the word file. I have to copy and paste paragraphs that I want. Highlight of the original paragraphs is blue.
Secondly, I click 'Insert Word Field' -> select 'Next Record'.
In short, I want to use VBA in access file to automatically perform the steps that I have outlined.
I currently have a few tables that use an autonumber as the primary key, however, I would like the autonumber to start with a series of letters if possible. For example: instead of it creating an ID of 1, then, 2, 3, 4, and so on, I would like it to append lets say "ABC" to the front of it; ABC1, ABC2, ABC3, etc.
I am just having a heck of a time, in trying to make a custom help file.
Has anyone had any luck? I sure would like to see a sample database, showing a custom help file. I just about tried everything, but not to smart about setting one up. I have tried the wizzard as well. I know where I get hung up is, trying to map the help file, to the Help ID number.
I have a table with 715K records. Each record is an inventory product, and the sixth field of each record is a short description. The tenth field is a single-letter category designation, and is currently blank. What I want to do is search through the description field of every line, and where the word "Paint" is contained, enter a letter "P" in the category field.
I am looking to check, whether i would be able to "add an Message box with a "Message : "Executes all queries all is well.mdb before executing this query ?" , if yes, continue executing the query, else, Exit out of the database?
Thanks to some of the threads here, I have managed to automate inputting form data from a record into bookmarks in a word document template (a letter). What I am trying to do is to lock the letter allowing modification only to the form fields in that template. If the original template is locked (allowing entry only in the fields), the data does not flow through. So I was trying to accomplish this through the "ProtectedForForms" property. However, it does not work. The letter gets locked before the information flows through. Here's the code I am trying to use (borrowed from one of the users here):
Private Sub cmd_letWarn_Click()
' Check for empty fields and unsaved record. If IsNull(occupant) Then MsgBox "Occupant Name cannot be empty" Me.occupant.SetFocus Exit Sub End If
If IsNull(propad_no) Then MsgBox "Building Number cannot be empty" Me.propad_no.SetFocus Exit Sub End If
If IsNull(prop_ZIP) Then MsgBox "ZIP Code cannot be empty" Me.prop_ZIP.SetFocus Exit Sub End If
If Me.Dirty Then If MsgBox("Record has not been saved. " & Chr(13) & _ "Do you want to save it?", vbInformation + vbOKCancel) = vbOK Then DoCmd.RunCommand acCmdSaveRecord Else Exit Sub End If End If
' Create a Word document from template. Dim WordApp As Word.Application Dim strTemplateLocation As String
' Specify location of template strTemplateLocation = "T:PlanningPlanningEnforcementLogsuppfiles emp warn.dot"
On Error Resume Next Set WordApp = GetObject(, "Word.Application") If Err.Number <> 0 Then Set WordApp = CreateObject("Word.Application") End If On Error GoTo ErrHandler
I am using the follow code to import data from a Word form into my MS Access 2010 DB:
Code: Set dbs = CurrentDb Set rst = dbs.OpenRecordset("tmpSIRs", dbOpenDynaset) With rst .AddNew
[code]...
On the Word Form, these two fields are drop-downs with three options: blank, No, and Yes. If the users leaves them blank, then Access ignores them--which is what I want. However, if the user says yes or no, Access puts a "-1" in the database. Both the Word form and Access field are text.
I have created a command button through the wizard that is basically: DoCmd.GoToRecord , , acNewRec
Well, it puts all this code in the event:
Private Sub NewVerification_Click() On Error GoTo Err_NewVerification_Click DoCmd.GoToRecord , , acNewRec InboundQuestions!Page1.SetFocus VerificationNo.SetFocus Exit_NewVerification_Click: Exit Sub Err_NewVerification_Click: MsgBox Err.Description Resume Exit_NewVerification_Click
End Sub
Well, my PK field is one users enter in manually (please don't ask why). What I need is something that checks to see if the number in that field is a duplicate key, so I can tell users via msgbox "Duplicate Number, try again". Right now, it's not that descriptive, it says "You can't go to the specified record". I guess all i need is an If statment, but I don't know the code that checks to see if [field1]'s value has already been used in my table. Any ideas?
I have a normalized database with (let's say) the following tables:
tblProjects tblStaff tblProjectPhase tblOffice
I need a way to allow the end user to be able to create custom reports that show only projects in certain phases (let's say planning and construction) AND that are from certain Offices (let's say Office 1 and 3 but not 2) AND that were started between a certain date range.
What I'm envisioning is a checkbox-style form that has a 'create report' button at the bottom.
I have a rather large form that I created in Access. It is mainly a travel reimbursement form. It has numerous drop down fields for travelers, dates, etc.
My problem is, how do I email it? I would like for the receiver to see the "printable version". When I try and export it currently, I don't have the ability to send it that way. I can send it as an Excel document, but when I view it, it is about 10 pages wide.
Is there any easy way to make the screen view visible to the receiver?
Any help would be appreciated as my company is opening a satellite office and our administrative assistants will need to get these forms.
Hi all, Not sure if this is in the right section but heres my question.
How can i gett a button to open a word document and put in specific information. for example. to send a client a letter, the button would open a word doc with the specfic client data in it.
Also a button to start a mail merge with all client records held on the db.
How to create custom menus in Forms in MS ACcess 2010. For example, I have a form fmrMainMenu. At the top of the form I want to create a menu labelled "Reports" that when clicked or hovered it displays a list of sub-menu options of all the Reports available in the database. Once the user makes a selection the report is generated. The functionality that I am looking for is similar to the old menu options like File, Edit, etc., in MS Office.
copying all the contents/text from word document and pasted that in the Memo Field, I have a Recruitment database where I have 02 fields on is CV Path (Text Field) that stores the CV Path (Word Document Path) and another text box content (Memo Field) where I would like to copy all the data from the word document to the Content text box (Memo) field.
I have put a Command button on the form...the code to "Copy the content/text" from [CV Path] word document and add it to the "Memo" field.