Search results

Hi, I have a bookmark in my word document. In the code, I need to attach few files into the bookmark. What I am trying to achieve is the following: For each attachment, add a line to the range of bookmark saying "Attachment1" and so on; and also insert a page break after the previous...

Hi, I am trying to insert a PDF File (as attachment) into a Bookmark in the Word Document. How do I do it? Following is the code I used, but it doesnt seem to work: FileSystemObject.CopyFile sourcefile, appDoc.bookmarks("Bookmark1").Range Thanks

Hi, I am trying to use HTML tags in an Unbound Text box for Bullets (with specific type) and Indentation. I used the following: ="<ul style='list-style-type:square'> <li>UL List1</li> <li>UL List2</li> <ol type = 'A'> <li>OL List1></li> <li>OL List2></li> </ul>" I am getting the default lists...

Hi, I am trying to create a report footer to include the symbol of a telephone, along with other text. How do I do it? Also, how to create a text box with 2 columns - similar to have a 2 page view in a book? Thanks in advance WS

Hi, I have a form with 6 combo boxes in it. I have a command button, which should display the query results when clicked. Now, my challenge is to build the query based on the 6 different fields. ie. query should be: WHERE Field1 = "Value" AND Field2 = "Value" AND FIELD3 = "Value" AND FIELD4...

Hi, I have a Distribution list in my Outlook Contacts called "Test" Is there a way I can send email to this contact group? Currently, what I am doing is this: Dim strMailList as string strMailList = "email1;email2" .To = strMailList What I want to do is instead of strMailList, I would like...

Hi, I have a table with 2 sets of fields: Plans and Actuals. Plan Fields have values and Actual Fields are empty for the user to fill in from the Form. I have a continuous form with Record Source as the above table. When the Form opens, the Plans are displayed on the Form and User enters...

Hi, I need to close 3 workbooks from the current one. So in the main workbook that I have open, I inserted a button, and added the following code to it: Sub btnClose_Books() Dim objXLBook As Workbook For Each objXLBook In Application.Workbooks If objXLBook.Name = "Book1" Then...

Hi, I am trying to run a query, and export the data to an existing spreadsheet. I would like to replace the existing data in the spreadsheet with the new export. The reason being, there are other sheets which never change. Is this possible with Docmd.TransferSpreadsheet? I used this...

Hi, I have a table with First_Name and Last_Name. I have a query to concatenate the 2 fields. The query is: Name: [First_Name] & " " & [Last_Name] When I run the query, the Name field displays only the First_Name. Strangely, when I double click each row, I can see the concatenated...

Hi, I am new to this forum, and new to Access too. I am trying to generate a report, and I would like to have a Label with flashing text saying 'report is being generated'. I have set a Form timer at the interval of 1000. In the timer event code, I have this: me.lblmsg.visible = NOT...