Search results for query: *

I would like to be able to build code on the fly and execute it (somewhat like you are able to build a SQL statement as a string and then execute it). For instance, let's say I have the following: strFieldName = "Quantity" strTransactionType = "Sold" I want to use the...

I'm referring to the fact that in Access comments show up in green and certain other syntax shows up in blue on the screen. But when you print, it all shows up in black. <p>John B<br><a href=mailto:dad2mads@home.com>dad2mads@home.com</a><br>

I'm probably just missing something, but is there a way to print out your code in color in Access 97 if you have a color printer? <p>John B<br><a href=mailto:dad2mads@home.com>dad2mads@home.com</a><br>

Rob, thanks for all of your help and research. I downloaded the VB5 Date/Time Picker, but I didn't see the control source property. Am I missing something? Also, do you know if there is anyway to allow the user to enter the month / day / year without having to move between the different parts...

Using the mscal.ocx control on the form, I have no trouble hiding the control after the focus moves off the control. I set focus to the date field text box and then hide the calendar control where using the following code: Private Sub oleCalBegDate_LostFocus() dtmBegDate.SetFocus End Sub...

Thanks Rob. I found the library on my computer, but when I tried to add the control to my form, it told me that I didn't have the proper license to use the Active X control. <p>John B<br><a href=mailto:dad2mads@home.com>dad2mads@home.com</a><br>

I'm currently working on inserting the calendar control into a form that's activated from a button next to the date field. Am using the concept of changing the visible property of the calendar, but having trouble controlling it. Did anyone every find the &quot;graceful&quot; way to close the...