Search results for query: *

Hi, I've been looking around the site for someone who has a similar problem to this, but I can't find one. I would like to generate a message in a text box, but only in the event of the existence of a particular value in a subreport. The value is "Hist" in a field called "Type". The subreport...

Hi all, About six months ago, I created a function in Access 2002 that would perform a mail merge based on a template file in Word. The mail merge portion goes as follows: With docWord.MailMerge .Destination = wdSendToNewDocument .SuppressBlankLines = True...

Hi all, I was looking around for a subroutine or function that would calculate the difference in days between two given dates, excluding weekends and holidays. I have used the faq181-261 as a starting point. I made an input form with an output message box showing the result in days. Everything...

Hi all, I would like the simplest and most straightforward means to disable a subroutine based on the event date. Let's say that the expiry date for the subroutine is January 1st, 2005. I would like the command to function until that date. Should someone use it after that date, I would like...

Hi all, I'm back with a problem with which I was dealing a while ago. The following vba code initiates a Word session, performs a mail merge, prompts the user to save the output file, closes Word and returns to a previous menu. Everything runs fine the first time. However, if I don't quit and...

Hi all, I have just implemented security on a database to restrict access to certain parts. This database is completey menu driven, so I restricted the access to a number of forms that guide the user to the various user forms and reports. My problem is that I get a vba runtime error 2603 ("You...

Hi all, I've added a popup calendar to an Access form, which is pretty straightforward. When I double-click a date, it will populate a field on my form and close the popup. I have been trying to play with the object properties to make it default to the current date, it doesn't seem to accept...

Hi all, I've looked extensively for an answer to this in the forums, but I can't seem to find the solution. In the following macro, I have created a loop that populates a Word table from an Access record set that ends after I reach the last record. Everything works find. However, something is...

Hi, I have two commands that go as follows: DoCmd.OpenReport "rptSingleQuoteforEmailEng", acViewPreview, , "ReqNo=" & [txtReqNo] DoCmd.SendObject acSendNoObject, , , strSentTo, , , "Request no. CAT" & [txtReqNo] & " for approval.", _ "Please approve request no. CAT" & [txtReqNo] &...

Hi all, In the following code, I am exporting data to Word, into a new table. To direct the data copy to the proper point in the document, I am using a variable called "rngInsertionPoint". The first time I run this macro, everything runs fine. The second time, I get an error '264' (Remote...

Hi all, I hope that this question hasn't been asked before, so here goes: I have a vba routine that opens an Excel spreadsheet, manipulates the data, saves the changes, then performs the 'transferspreadsheet' command. I run this routine from a menu button. At the beginning and end, I have...