Recent content by John Roberts

Hi David, I would add a screen shot to show what i'm looking at but i can't seem to attach it for some reason. However, the Data Source you refer to is called TaxiLicence.odc. I have a feeling that when the data was selected to be available in the Mail Merge, Vehicle wasn't one of the fields...

How will Word know if the the word Vehicle is not included in the drop-down "Mail Merge Fields. Surely it has to be added first so it then becomes availble for selecting and inserting into your letter. Thats my problem.

The database was already here when I took the job on so the letters were already linked to it. Trying to run the demo of Merge Access data with Word but keeping getting buffering issues and it stops :( But thanks for your help. Regards John

We have a database for Taxis and every year they have to renew their licence. The database is linked to a letter created in WORD which you just click the button and up it comes but, the merged fields dont include the one thing i want to add and that's their vehicle. I would like to add it and...

Hi Folks, Have'nt been on here for a long time but need to try and update my skills as we have no one inside at our place of business that can help with Access. My problem is I need to add a field called "vehicle" so that it appears in the "Insert Merge Fields" drop-down when I link it to a...

took out the email address as Dave aka Gemma-the-Husky, pm'd me and we are in conversation. However, if Dave is unable to assist I'll re-post again. Regards John

so now i'm on my eleventh and if someone would care to pm me I'll attach a word doc with the screen print and a brief explanation. Regards John

sorry this didnt sound quite right but when i removed the email address i just left the rest. Regards John

If anyone wishes to email me at I can attach the screen print which will show what i trying to explain. Kind regards John

Thanks Alan but as its a local government in-house system i don't think they would take to kindly to me exporting any part of the data base outside of the network. Regards John

Thanks for the help people but unable to zip the screen shot any smaller than 139 and as the limit is 100, I'm stuffed. Regards John

I wish i could give you more Alan but it's my knowledge of Access that limiting me as to what i can and can't do. The terminology you use on your side of the big lake is loosing me and it's purely down to my lack of understanding the back-end of the product. As a person with no one in-house to...

I've opened it in design form with the vehicle name box highlighted i need to alter, also the property sheet to its right is open along side. Once again I have tried to attach a screen print. Regards John

A column which i can widen in a form

sorry folks but i did try to upload a screen print as an attachment for people to see, but i don't know where it went. It would be easier to explain with an attachment present, but it is a column titled "Vehicles" with all the types of vehicles used as taxis in the column below. I've only got...