Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Expression entered is the wrong data type for one of my arguments
Good Morning all you brillant programmers out there! I would appreciate another pair of eyes on this Sub. The process emails a report to a list of email address from a table. The report iterates through the set in the table however when it finishes before closing out to the main Form it errors...- MISCurls
- Thread
- Replies: 4
- Forum: Microsoft: Access Forms
-
Null Error in Report revised
This is a revision to the Parameters query Null Error Trouble Thread. I changed the query and am summing the quantity in the report only. The result of the report is still returning an error when the query does not produce a value for the Brand Name field when looking between the two specified...- MISCurls
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
-
Parameters query Null Error Trouble .
I'm using a form to run a 2 parameters query on pharmacy data The query is setup like this: BrandName Generic Name Strength Quantity [Forms]![F Drug Used within Dates]![BrandName] on the brand name(combobox) field and Between [Forms]![F Drug Used within Dates]![StartDate] And...- MISCurls
- Thread
- Replies: 7
- Forum: Microsoft: Access Other topics
