Search results

Really :banghead: haha well in that case i dont understand the second piece of code you showed

Same mdb file (database)

I mean multiple tables in one mdf file. sorry for the confusion thanks

Hey, Thanks for the help... im not sure what to put as the paths.. all the databases are in one .mdb file if that helps sorry if i was being unclear.

I have a selection of databases that the combobox chooses from. the user will need to select the database using the combobox then simply press the command7 button (labelled Archive) and it will make a copy of that database and rename it with the date so that the original database can be re-used...

Sorry i think i was unclear.. when i say i want to rename a table i ment a database e.g. CP001 when they press Command7 i want it to copy CP001 database and rename it with the contents of Text18 added.. e.g. CP001/2012 Thanks again for the help

I have a button that is supposed to Archive the tables as they get changed every year. the button is called "Command7" i have a combobox "Combo16" which selects which table to archive. I also have "Text18" which the user will put the date into. The archived table will be the orignal table...

I am looking how to create a button that will create a report from the chosen table in the format of my template. one of the table is called CP001 Field and Plant and the template is called CP Field and Plant Template I would also like an archive button which would save the databases with...

Below is my code, which works perfectly... Private Sub WorksReport_Click() Dim LWordDoc As String Dim oApp As Object Dim MWordDoc As String MWordDoc = "Z:\WorksReport\V" & Me.VisitNumber & ".docx" 'Path to the word document LWordDoc = "Z:\WorksReport\V" &...

Ive been using the Insert Field button on microsoft word. My access database writes to the word document. the probem is when the words are longer than the field it pushed everything down instead of starting on the next blank line. is there any way of setting it so that it starts on the next...

Can anyone help?

Hi thanks for the help, ive tried adding the library you have mentioned but it gave me an error. After searching the error i found that it isnt needed in 2010 so thats not the problem.

Ive searched the internet and this link http://www.techrepublic.com/blog/msoffice/how-do-i-fill-word-form-fields-with-access-data/164 best describes what im trying to achieve. Unfortunately ive tried following but the code gives me an error as in the first line... Dim appWord As Word.Document...

Thanks for any help in advanced. What i want to achieve is i have a form with combo boxes thats show.. Visit Number Date of Work Quote Number Type Of Work Enigneer Name Customer Name I have a template of a visit sheet, and if possible would like for when the user presses the button on the form...

Its not that i dont think i need it, i dnt know how to link them together so when the user chooses a name, the Id is automatically selected

Because there isnt customer ID on the report and the report is what im filtering

Yes. but i want it to filter by the customer name not the customer ID

the problem i have is i select the name, when it filters however it filters by ID, i want it to filter by name.

either way would work, whats the simplest way ?

is there any way of searching for the customer name as apose to the id? Alterntively make a box so that when the customer name is shown it shows the customer id that goes with it, so i can use that to search??