Recent content by alastair69

Hello All, I would like some help on how to get a stored file name out of access and into word, there could be mulitible pictures to a site i have a table called tmakSamplePhotos that holds the filename which is called "file". The output of the pictures should go into a table with in word (see...

One option is to have buttons to click on to go forward and backwards how would you feel about that

just a sec i will look at it

Have a look and let me know if you need anymore help

ok i am changing the bits now and i will repost it to you.

Is there a reason why you are using a macro to add a new record or was it just you did not know how any other way

Are you talking about the text on Employment information screen?

you could use a formating statment by specifying your column and the time format for that cell

Rabbie, I am leaning so much from the have ago approuch and it seems to be working so far touch wood, it difficult to know were to put the code to get it in the right place. Thank you so much for your help and understanding.

I have got it working by the following code: 'check for existenc of previously saved letter in documents folder, 'and append an incremented number to save name if found strSaveNamePath = "Report Ref " & Replace(Str_Address, ".", " ") & Replace(Str_Area_Number, "/", "") & ".doc" intCount = 2...

I end up with a file called Report Ref No. 19, Priory Street, York.E001docdoc, and will not open by double clicking. 'check for existenc of previously saved letter in documents folder, 'and append an incremented number to save name if found strSaveNamePath = strDocsPath &...

The code below is what i am using to save a file name from access into word, the problem is that str_Area_Number contains the following value E/001. what i think i need is a way of removing the "/" so the value would be E001, RuralGuy gave the possible answer as using the replace () comand i am...

Hello All, I a very simple question and i know this has been covered before but any help as ways. I have a room number that is entered like this E\001 the table name [tmakProperty] and field name is [Area_Number], it could be upto two letters at the front of the \, i am saving the room number...

Bob Cheers for explaination and keeping the spamers out. Alastair

Hello John, Welcome to the forum hope you find it usefull. Alastair