Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by vicky1362002

  1. vicky1362002

    Password Protect MS Access Project (.adp file)

    Hello everyone, I have a MS Access Project linked with the SQL Server Database as the back-end. I would like to make the Access Project file PASSWORD PROTECTED. I tried doing it by going to Tools->Security->Set Login Password BUT it doesn't allow me to do so and it prompts this: "Microsoft...
  2. vicky1362002

    Counter

    Hi , I am trying to develop an out of box counter. I have a list which has auto incrementing field. Basing on that field I need another counter attached to a document library which starts from 1, each time the new document is part of the item in the list like 1001.Request 1------1001.1 Form1...
  3. vicky1362002

    Mail Merge Documents gets 1st record data

    Is there anyone who can help me out with the above? I would appreciate any help. Thanks, Vik
  4. vicky1362002

    Mail Merge Documents gets 1st record data

    Hello All, I am using mail merge to get the data on a word document and open it up. I am using this code to get the document opened up with the data of a particular ID: wks.MailMerge.DataSource.FindRecord Forms!Notice!Combo9, "ID" The above code is a part of the code i am using for a...
  5. vicky1362002

    Mail Merge from Access to Word changes the date format in word

    Hey PHV, Your small tip made it all work, i tried using the Format function in the query and it worked like a charm. For those who has the same problem, try this: Even if the query gives out the correct date format which you want, change the query in this way: Actual Query: select...
  6. vicky1362002

    Mail Merge from Access to Word changes the date format in word

    Thanks PHV for you instant reply. I am getting the correct format which i need in the Query output, but when i am merging it to a word document, the format changes to the standard format mm/dd/yyyy. The answer your question: NO, i haven't used any format function in the query because am...
  7. vicky1362002

    Mail Merge from Access to Word changes the date format in word

    Hello all, I am trying to do a mail merge, everything seems to be good. But, i have a date field in the access query, which is in this format June 19, 1994, this date field when merged to the word changes the format of the date in the word document, i mean to say that when i merge the access...
  8. vicky1362002

    Merge all the fields from Access Table/Query into MS Word

    Thank you Duane. It inserts all the data from the access table/query to a new word document. One last question, is it possible to use the same or similar code to insert the full data from the table/query to a document which already has some text in it....i mean say for example if there is a...
  9. vicky1362002

    Merge all the fields from Access Table/Query into MS Word

    I couldn't find any good code or i should say i did not understand the codes which i found on google. Can someone please help me in coding it for me, please. Thank you, Vik
  10. vicky1362002

    Merge all the fields from Access Table/Query into MS Word

    Hey Duane, I did the step 6 of 6, and it did merge it to a new word document with all the records BUT i had to do it manually, is there a way to do the "Merge to a New Document" automatically or with the VB Code. As i mentioned already that the merging should be done automatically when i click...
  11. vicky1362002

    Merge all the fields from Access Table/Query into MS Word

    Hey Duane, I did te step 6 of 6, and it did merge it to a new word document with all the records BUT i had to do it manually, is there a way to do the "Merge to a New Document" automatically or with the VB Code. As i mentioned already that the merging should be done automatically when i click...
  12. vicky1362002

    Merge all the fields from Access Table/Query into MS Word

    Hello PHV, How do i do the Catalog mailmerge ???
  13. vicky1362002

    Merge all the fields from Access Table/Query into MS Word

    Yes Duane, exactly, its similar to the report design in preview mode BUT even in the preview mode we have to click the > (right arrow) for the next records. My question is: Is there any way to get all the records from a query/table into an MS Word Document as a list. Or let me put the...
  14. vicky1362002

    Merge all the fields from Access Table/Query into MS Word

    It does the mailmerge, but gets me the 1st record from the query and then when i click the 'next record' in the mailmerge toolbar it takes me to the next record, but i need all the records to be displayed at once, like for example, if the query has this data: row1 Tim Knight Honda row2 Raul...
  15. vicky1362002

    Merge all the fields from Access Table/Query into MS Word

    FYI: I am using MS Office/Word 2003
See more

Part and Inventory Search

Back
Top