Recent content by texasgrandma

:) Thank you Grand-dad!!! It worked!

IIF statement with Dates functions [Solved] My goal is if the current date = 1st - 4th of the month to return the failure_date if it is >= 1st of the prior month and <= 4th of the current month (ie, 01/01/14 - 02/04/14) this works: >=DateSerial(Year(Date()),Month(Date())-1,1) And...

Using Access 2010

Table: DailyExport Field: FailureGrouping (actually is offices) I want to export all the fields from DailyExport each of our 9 offices to Excel, whetjer or not they have date in the DailyExport table. So if not, the exported workbook would only have columns headings. I need help to loop...

I made the changes you suggested. That got rid of the #errors but now I have all 0's in my ranking column. Here's my correct formula: Ranking: DCount("*","[tblTimeCNV_AgeGroups]","'AgeGroup'=" & 'AgeGroup' & " and timemaxHR <= " & [timemaxhr])

Query is based on 1 table" tblTimeCnv_AgeGroups Fields: AgeGroup Time Ranking 30-& under 11.22 1 30-& under 10.41 2 30-& under 9.22 3 30-39 11.32 1 30-39 9.53 2 30-39 9.34 3 30-39...

Scan; PDF; to Access Thanks....it will be a couple of weeks before I start this project. Thanks for the "startup" directions!

Questions answered? How's your VBA skills? AVERAGE (on a scale of 1 to 10; a 5) Does all users have a scanner attached to the pc? (only 1 computer with 1 scanner needed at "checkin location"; database on LAN; PDF available to other 3 PCs) Have you got any ocx controls that will allow scanning...

We are wanting to have our entry form open; click a button that scans a document; to a pdf file; then attaches a hyperlink to that pdf to that record. If that record was ever retrieved; we could simply double-click the hyperlink to access the pdf file. Is this possible? Could you give us some...