Search results

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

Cheers Doc Man i am messing about with it know, i will try that one

bluetongue, Following you code you supplied i have changed some of the items so i can see the data been passed to and from the data lines. The code i am using is below, i have an erorr 13 at the point of lngPhoto_Number (Marked in red) were i know that there is more then then one record to pass...

It could be the find next command that i need

would you need to count the number of records some how on the form and then reference that back to the vba code, i am not sure if i am on the right track.

Anybody got any idea on this one.