Search results for query: *

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...

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...

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

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...

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...

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...

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...

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...

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

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...

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...

Hello PHV, How do i do the Catalog mailmerge ???

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...

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...

FYI: I am using MS Office/Word 2003

nope...i DO NOT know how the catalog mailmerge works. PHV, can you help me with this, please?

Thank you dhookom for your reply and question. I have tried to do the normal mailmerge using the Access Query, but as you know it inserts one record at a time, but i need all the records, all the rows to be merged to the word document at one time. It works with the database toolbar, using the...

I have a strange issue. I have a query which pulls the data with some criteria on the date, and it runs well. Now, i want to merge the data which i get out of this query into a Word document, i should be able to merge the entire data of the query, not just one row or one record, i need the...

Ok MajP, Thank you for all your help. I really appreciate it. You have a wonderful day. Merry Christmas and a Happy New Year. -Vik

MajP, I am still trying to do what you suggested but it isn't working. I created a query with the SQL: select * from tableA WHERE (((TABLEA.ID)=[Forms]![printmenu]![Combo9])); But the Word Doc doesn't care, it still opens the alphabetically first entry from the Access Table. I dont know what...