Search results

I have VBA code (Access 2007) that first copies a file using UNC convention and later uses a MergePDF procedure to consolidate that initial copied file with the generated PDFs... On my PC, Windows 7 Professional 32-bit, it works fine... On other people's PCs, the FileCopy does not generate any...

Not so simple... The criteria for extracting the one field (description) is based on multiple fields and the value being within a range... The exact syntax I have right now is: QARR Desc: Nz(DLookUp([QARR Measure],"QARR Definitions",(([Procedure_Code] Between [QARR Definitions]![CPT Begin]...

I hope I can explain this clearly... I have a query that based on certain codes in a record does multiple joins to pull in other codes... I want the query (based on these pulled in codes) to do a lookup in another table to extract 1 field that has a description... Can I do this in one...

Solved... It seems that on my final crosstab that is the source for the report, it changed one of the fields into an expression so the report did not know what that field name was... I changed the crosstab to once again be the field name (and not an exprerssion) and all is working again...

I'm using Access 2007 and my DB was 2000 format... I just updated it to 2007 format... Now, the following statement in one of my reports has stopped working: DoCmd.OutputTo acOutputReport, "Encounters by Location and Department - ALL", acFormatPDF, XFile There is no error message or...

I see many people have had this same issue in the past but I haven't been able to find a solution... Using Access 2007, how can I link (or import) Foxpro tables that I can access in Excel using OLE DB??? Thanks...

I am having this problem too... How did you solve it, i.e. to get Access to connect to the Foxpro tables...