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 JoyInOK, The register edit that you referenced is exactly what is needed to resolve the error. I added the setting and everything is functioning normally. Thanks, Creo

Hi apestaart, I can't really speak for your code (frankly I don't think I'm good enough to figure out what soemone else is trying to do...), but I know that my code has been bulletproof for the last 7 months by writing it out as follows: ElseIf frmDocType = 4 Then 'Output the quote to a...

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

Thanks, It works fine! I have verified my results and they are excatly what I expected. Very cool! Thanks, Creosote

Hi MichaelRed, It definitely isn't a left handed compliment, as you say; I never use sarcasm when I need something. What I am saying is that the original function will return the calculated value between the days. That is fine if I simply want the value. What I need is a way to incorporate the...

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

I have tried this function as a subroutine in a form with two text boxes (start, end), and it worked, returning a value excluding holidays and weekends. How would I apply this to a query result in which I have several records with two dates (i.e. start date, end date) and wanted to calculate...

Hey Rob, Although this code is not perfect (users have had errors when they already have a session of Excel open), my immediate RAM concerns were resolved. It creates a really transparent and effortless Excel to Access import subroutine. The instantiation of Excel created during the process is...

This for job security. I suspect that I might be leaving the organization when my project is completed. If this is the case, I am planning on having the timer kick in around next February. I would like to explain, but I'll give you the gist: this is not malice, it is retribution. I have also...

Hi Skip! Short and sweet, the way I like it! Thanks, Creo

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

Again, thanks R-V, That totally did the trick. I added the appWord and my error 462 just disappeared. Your help was invaluable. Creosote

Thanks Roy-Vidar, You advice has given me direction. However, I find myself having the same problem, even with the object references that I make. At one point, I reverted to instantiation, but I can't figure out where, or how to resolve it. I even tried to deal with it through error trapping...

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

How do I disable a command button based on a workgroup?

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

Hey PH, That's it! Thanks Pierre

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