Search results

I am using the inputbox function to input the date into a field (strPayDate).

Hi Helper, I am using the docmd.openreport method to print 4 report from VBA. I have the date for the reports (all use the same date) in a variable. How do I pass that variable from VBA to either the query or the report form? This will prevent me from entering the same date 5 times (1 to fill...

Hi All, I created a report, which pulls data from a query. The user has to put in a date, which is displayed on the report header (that is all the date is for). It has worked well, because I always had records meeting the query criteria. Now, there is no record in the query, the date will not...

Text Box Thank you for your assistance. Just what I wanted.

Hi All I am using a text box to display a message on a form, if a certain condition is true. The box is not visible until then. It is unbound, and not enabled. It works well, except for the color. Because of the severity of the message, I want to display it in you-can't-miss-it colors (red...

Hey Pat, Thanks for saving me the time. No need for "a better way" to do this, then.

Hi. I receive a text file from a mainframe. It contains decimal amount (e.g. 14.99) recorded in the text file as 1499. When I import the test file in a field formated for 2 decimal, I get 1499.00. I have gone around this by writing a query to divide by 100. However, is there a clean way to...