Search results

I've got a form with Text boxes StartDate (datatype = Date / Time) and Interval (datatype = Numeric). Both text boxes are bound controls. I'd like to validate whether summing the StartDate with the Interval entered results in a calculated date, falling on either Saturday or Sunday. If so, the...

I'm trying to generate an email in Outlook Express version 6.00.2800.1123 Acces version is Access97 SR2. I want to use the CreateObject method ,not the SendObject method. I've created a form with a button. This is the VBA code attached to the On Click event of the button: Private Sub...

Hello, I posted this question earlier in the Queries Forum. Because it's more a VBA subject and I still haven't got any answers, once again: I've created a user defined function to get all the values which are selected from a MultiSelect listbox. The function returns a string containing all...

Hello, I've created a user defined function to get all the values which are selected from a MultiSelect listbox. The function returns a string containing all values. The function itself works OK. I try to refer to the function in an SQL statement in a WHERE clause: SELECT somecolumns FROM...

Hello, I've got a database (Access97) with customers. Of each customer the day of birth is registrated. When starting up I'd like to pop up a screen with all customer names which are celebrating their birthday within a period of 30 days. I've created a function to output the results of a query...

Hello, I need to transfer the results of a query to a textfile. The query is based on three columns namely Familyname, City and Accountnumber. The format of the textfile is predefined. The (first) value for Familyname should be in the first line of the textfile. The (first) value for...