asked on

Access 2013 - & Android Tablet Checklist

Using Qpdf Notes with an Android - Issue with Book Marks

I am trying to generate forms for use on my Samsung Android tablet for field inspection.

Currently I export access forms as PDFs (up to 700 pages long) that are customized for each inspection.

I use this code to bookmark the PDF:

Set Rst = dbs.OpenRecordset(strsql)
Set gApp = CreateObject("AcroExch.App")

Set gPDDoc = CreateObject("AcroExch.PDDoc")
If gPDDoc.Open(reportpath & ReportId & " " & rptnmlng & " " & RptMo & "-" & RptDay & "-" & Year(Now) & ".pdf") Then
Set jso = gPDDoc.GetJSObject

Set BMR = jso.bookmarkRoot

' if the cover/toc is included then we add this in and
' the integer makes sure the bookmarks are assigned right
' further down if the cover/toc are included.
If blnIncludeCoverTOC Then
BMR.createchild "Report Cover", "this.pageNum= 0", 0
BMR.createchild "Table of Contents", "this.pageNum= 1", 1
intWithCover = intWithCover + 1
End If
With Rst
Do Until .EOF
varBMName = "this.pageNum= " & CStr(![pagestart])
x = ![pagestart]
varBM = ![CheckListIndexRecId] & " " & ![CheckListTitle]

BMR.createchild varBM, varBMName, x
.MoveNext
Loop
gPDDoc.Save PDSaveCopy, reportpath & ReportId & " " & rptnmlng & " " & RptMo & "-" & RptDay & "-" & Year(Now) & " BkMrkD.pdf"
gPDDoc.Close
End With
End If

Set gPDDoc = Nothing
Rst.Close
Set Rst = Nothing

When I contacted Qpdf notes help they told me that I need to create a “Normal” PDF Bookmark (I’m not sure what the difference is) or that I could export forms in FDF, XFDF, XDP, and XML, and then import them into Qpdf Notes to use in the field.

Does anybody have any experience with these issues or a better solution to have my Access database interact on an android tablet so can fill out data in the field and directly import to Access.
13067.000-01--All-in-One--Standa.pdf

PatHartman

If their software can work with XML, I would go that route. Access has an export for XML so you probably need to build a query and use that in one of the Transfer.... options. Probably TransferText.

To export from the GUI to see if the file will work, right-click on a table or query and choose the xml option.

rogerdjr

ASKER

Thanks

That will take some figuring out - I'll let you know how it works out

PatHartman

It's just one click to try it from the GUI. Once you know if it works, you can write the one line of code to export it.

rogerdjr

ASKER

Interesting

See the attached - xml that exported

This is how I export as a pdf - can you help with the command to export as an xml?

DoCmd.OutputTo acReport, rptnm, acFormatPDF, reportpath & ReportId & " " & rptnmlng & " " & RptMo & "-" & RptDay & "-" & Year(Now) & ".pdf", , , , acExportQualityScreen

The report is pretty complicated - see attachment from the 1st post, with sections, headers, etc.

Thanks
StandardCheckList-FieldWkgListRp.xml

ASKER CERTIFIED SOLUTION

PatHartman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Access 2013 - &amp; Android Tablet Checklist

Access 2013 - & Android Tablet Checklist