Recent content by ngs88

Does anyone know if it is possible to copy a form design from one access database to another. I have 2 PC's one with a complete database and the other with one of the linked tables which is identicle on both PC's. I want to avoid having to design the whole form again.

Problem is that I want it to open a file that changes with the record by using the record number as the file name

Tried this by putting a command button with no event on the form and then using code builder putting in the code On the line strFile = Me. ------- I put the path to a file ie: C:\My Documents\ etc etc but it throws a code error something about brackets Am I missing the point John

I have a database form, from which I wish to be able to open a specific pdf file. The file name used is the same as the record number field (Customer No) ie Customer No 555, file required is 555.pdf Can anyone help with a method or code so that the file will automatically open the pdf file...

I have a database form on from which I wish to be able to open a specific pdf file. The file name used is the same as the record number field (Customer No) ie Customer No 555, file required is 555.pdf Can anyone help with a method or code so that the file will automatically open the pdf file...

I have a problem when opening an adobe acrobat file from an ole window on a form. The file opens ok but when I close it it leaves an error message that the "operation of the acrobat document object failed" and that "ole server may not be registered" Ihave carried out the method shown on the...

Well done Paul that did it thanks

Found the problem, It seems I had 2 versions of the database on the PC

thats how I did it but it is not in the list with the original tables

Tried =Count(*) in an unbound text box in the report footer but it returns error

On my data base I produce a report which gives a list of records based upon a query. How can I get it to print the number of records displayed at the footer

I have an existing database using access 2002 which has been split. In the part containing the data (back end I think its called) there are 3 existing tables which are clearly linked from the front end (forms queries etc.). If I now try to add another table in the back end it is not shown in the...