Search results

Hi Jabba, My Access DB creates weekly Checklists, my customer has a variable number of items in a daily, and weekly section and has an optional table at the bottom of the document. My program inserts a header and footer and then uses the entire remaining space with tables which contain...

Hi Jabba, I think you have two options here. 1. create a report which replicates your word form, use a sub report to return the variable number of associated sub records. The Report can be saved as a Word document if required. 2 Create an Access VBA Module which would create a word document...

Have you had a look at the DCount function. This will count the records of a table based on the search criteria dCount("Field", "DBTablename", "Criteria Field A = ? and Field B = ? etc")

Just found the code I used [Code] Sub PrintMailMergePreviewRecord() Dim MyLoop As Integer If ActiveDocument.MailMerge.ViewMailMergeFieldCodes = -1 Then ActiveDocument.MailMerge.ViewMailMergeFieldCodes = wdToggle End If For MyLoop = 1 To ActiveDocument.MailMerge.DataSource.RecordCount...

Hi Stuart I have had this problem before and this is my solution. Setting up the printer to be used to be the default printer and the default Printing Preferences set to produce the booklet. When you are in a mail merge document, it is possible to preview the results and you can also view the...

The quickest solution is to produce a Report directly within MS Access. Use Grouping on Agriculture in the data to have all sub records display. You can then export the report to Word if you need to do additional work to the document. To achieve the same result in a mail merge would require...

Check that the Paper size for the document is the same paper size available on the connected printer and as specified in the printer driver.

Currently I use 2013 - however splitting the database has been in every version I can remember from Office 98 - Under Database tools you will find the option to Split the database all links are auto generated for you. The tables are then linked from the Backend to the Front end, you can have...

You could look at having a timed event that would alert the user and if no response then shut down. If it is only the forms your are editing then I suggest you use a front end (Forms) and back end (Data) see help and splitting Database for more info.

Why would you want to do this?

Yes this line runs on an 'On Click' event for a button on my customers form.

here is a line from my code but I have modified to your data, that outputs to a pdf and displays the PDF document, to stop display delete 'True' but leave the comma DoCmd.OutputTo acOutputReport, "rptTransactionInvoiceExcVAT", acFormatPDF, "C:\Users\JEFF1\Documents\" & Me.txtAmazonBuyer &...

What you are seeing is probably the Navigation pane with the document structure, headings etc. Select the VIEW tab at the top of the Word window and you can choose all the options for what can be displayed. as you click on items you will see them appear or disappear.

Perhaps you should consider creating your document from Access. I have an access database that creates my Word Documents, all the elements of the document are stored in Access and it includes my customers logos Set a reference to MS Word dim wordApp As Word.Application dim con as object...

What are the fields in you table? and what Event happens and (the event code or macro instructions) when you select the combobox and change between AM and PM. Perhaps if you can attach a copy of the Form and the Table.

if you have separate fields that show the sales then create a new control to calculate the total. in the property "Control Source" of the new control enter the following =[amtotal] + [pmtotal] the fields holding the totals must be formatted as a number or else you will get 22 instead of 4...

Your Normal.dot(m) template file is located C:\Users\"YourUserName"\AppData\Roaming\Microsoft\Templates Edit this with care. if you just delete the second page you should not have problems. The (m) suffix is placed there if there are macros attached to you Normal template.

Set the rowsource for the combobox to retrieve your towns where (I presume is another combox for country) then on your town combobox, set the Event - 'On Got Focus' for an [Event procedure] set the code as follows me.[combo Box Name].requery This will refresh the data as soon as you click...

I use the WITH statement to insert and manipulate my logo onto various documents Sub ChangePicture() ' ' Change Picture properties Macro ' type a '.' inside the with statement to see all the options available ' With ActiveDocument.Shapes.AddPicture("FilePath and Name") 'change the...

I would use the combo box to populate a list box ) with their patient list(Set the Multi Select Property in Other to 'Simple' - i.e. only one record can be selected in the listbox. On the [After Update] event property on the combobox, requery the listbox, I would then use a subform to display...