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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using openargs
I have a combobox with a list of reports that opens that report when updated. I want to change the source of the report based on the combobox value. I have a table that has the report names and the associated queries in it. Can I use a dlookup to the table in the openargs to set the source to...- ImChard
- Thread
- Replies: 1
- Forum: Microsoft: Access Reports
-
-
Time difference
I have a table with a couple fields in it for entering times: [Resp_Notified] and [Resp_Arrival]. In the table the property is set to Date/Time , format set to Short Date and mask set to 00:00;0;_ In the query I have - DeltaT: DatePart("n",timeduration([Resp_Notified],[Resp_Arrival])) to get...- ImChard
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
Passing parameter to query from VBA
You da Man!!!! Thanks- ImChard
- Post #3
- Forum: Microsoft: Access Forms
-
Passing parameter to query from VBA
I have a form that opens and displays records based on a select query. I want to add a button to the form so thet when clicked there is a prompt comes up that aske for the [Last_Name]to filter the records on and then refresh the form to reflect this.. I can do this in the criteria of the query...- ImChard
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
-
Query parameter from VBA
I have a form that opens and displays records based on a select query. I want to add a button to the form so thet when clicked there is a prompt comes up that aske for the [Last_Name]to filter the records on and then refresh the form to reflect this.. I can do this in the criteria of the query...- ImChard
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
