DateDiff PM to AM the Next Day 1 304 (3/9/2007 3:58:16 PM)
I am using DateDiff to calculate minutes between two times. If the times are AM and PM, it works great, but if I am trying to get the elapsed time between PM and AM, it does not calculate what I expect so I mu...
deefish99

select record in main form using subform 0 154 (3/9/2007 3:08:22 PM)
I have a main form "Magellan" and a subform "Household Members." "Magellan" form is based on a table, the "Household Members" is a query which finds all records in Magellan with the same number or text in a co...
joebeagle

Stephen Lebans A97ReportToPDF 0 139 (3/9/2007 2:52:35 AM)
Is this still available? I am running Access97 and don't have a later version with which to open the current version and then convert to A97? I currently email out reports to multiple email addresses as RTF fil...
Piri

Forms with parameters to pass to cross-tab queries 3 1104 (3/6/2007 12:59:19 PM)
Hi, I have a cross-tab query built on another query. I have created a form to display the cross-tab query. Now, I would like to restrict the results of the cross-tab query by passing a couple of params to t...
DeepTrouble

Required Field Msg Box loops. Can't close form...help 3 137 (3/8/2007 6:55:13 PM)
I have a form with some required fields. When they fail to enter data in that field, it pops up a message box. It takes them back to that field. What if they don't know the information and they want to close ...
sdh31873

DSum Criteria Question 0 273 (3/8/2007 7:21:37 PM)
I've got one table that lists contract payments for multiple monthly payments. Each record has contract number, payment date, payment amount In another table I have all the contract info: contract number, co...
Utf

Populate Acrobat pdf file from Access 0 379 (3/8/2007 3:59:06 PM)
I have a database that I created a few years back that uses the activex installation of the old Adobe Acrobat FDF tookit. My code creates an fdf using fields from my form and then opens the corresponding pdf...
Todd

open a form to child record using bound text box "on click" 1 388 (3/8/2007 1:50:24 AM)
Here the problem~ I have a field "JobName" in a continous view, sub-form "sfrm_Jobs". The sub-form is in "frm_Customers". I want to use the"JobName" field's "on click" event to open "frm_Specs" and have it filt...
lenox

Results listed in rows vs in columns 3 144 (3/5/2007 8:02:08 PM)
I have a report that shows the athletes in a sporting event and their coach’s name if the coach is also a judge/referee at this event. The poupose is so that when seting up the competition we can ensure the...
Utf

Domains - Aggregating, Averaging and Counting 10 96 (3/6/2007 6:09:08 PM)
Hi, I have a table that is going to have a date stamp for each record, a book like Canada Equity and a Market Value Amount. What I want to do is find the Month to Date Average Market Value Amount. The month t...
Jackson