Search results
-
J
Query By Form - using Text Boxes and Combo Boxes in criteria
"I have a query that uses unbound text boxes and combo boxes on a form as criteria. But when I leave some of the boxes blank on the form, no records are returned by the query. How do I make the query work when some of the boxes are empty?" Here's a solution to the above question. You can open...- Jon K
- Thread
- Replies: 1
- Forum: Sample Databases
-
J
INSERT INTO Excel range - all numbers become characters
When I use SELECT...INTO to create an Excel 97 file, all is fine. However, when I use INSERT INTO to place the same records in an Excel range, the numbers are all converted to characters in the Excel worksheet. The code I used was:- INSERT INTO MyRange IN 'D:\Dept\HeadCount.xls' "EXCEL 8.0;"... -
J
Storing a date in a form
I have a personnel database. I want to automatically update the age and years of service before the input/edit form is opened for the first time each day. I am able to do this by storing the "last updated" date in a single row table and comparing today's date with this date each time the form...