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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. maggieTan

    Output to .pdf ...cancel error in runtime

    The following code " Private Sub Label466_Click() DoCmd.OutputTo acForm, "QME Notification", acFormatPDF End Sub " works fine in full version A2007, however in runtime, if the user cancels the output to .pdf dialogue, an Onclick error is presented. The app continues to run, but the user must...
  2. maggieTan

    Jetcomp with Access 2007 backend file?

    This is for a runtime deployment to users with no full access version and little tech knowledge. The question is whether JetComp does anything to a .accdb backend file? As this new format has the attachment field etc and is not the same as a .mdb format backend. Is JetComp used on .accdb backends?
  3. maggieTan

    Backend Table Relinking in ACCDB

    This is used for installations in runtime, for non tech, non-full version users.
  4. maggieTan

    Backend Table Relinking in ACCDB

    I just rebuilt my .mdb backend in Access 2007 to the new .accdb format back end. All works fine..except... I had relinking code which allowed the user to relocate the backend file on start up. Now I tried using the code to relink to the accdb backend and the code fails. (it isn't as simple as...
  5. maggieTan

    Jetcomp with Access 2007 backend file?

    Does anyone know...is the JetComp utility still compatible with Access 2007 backend files? Google search yeilded zero info. I know that JetComp worked well on bloated backend .mdb backends...does it work with .accdb back ends?
  6. maggieTan

    Exporting reports to pdf files

    Thanks..I've been going crazy with this. Record source is a Query (ML Report Query) I tried the filter =Forms!carriernarrative!recnumber (the form "carriernarrative" is open and "recnumber" is the name of the feild "number". When I run this, the record in view displays and all records in the...
  7. maggieTan

    Exporting reports to pdf files

    Thanks PHV...the form in displaying only the individual record as specified by my filter: "[QME/AME Information]![number]=[Forms]![QME/AME Information]![number]" I have a button on the form with: Private Sub Label466_Click() DoCmd.OutputTo acReport, "intronar", acFormatPDF, , End Sub This...
  8. maggieTan

    Exporting reports to pdf files

    I still can't make only the record in view export to .pdf. I am using Private Sub Label466_Click() Dim strCriteria As String strCriteria = "[QME/AME Information]![number]=[Forms]![QME/AME Information]![number]" DoCmd.OutputTo acReport, "intronar", acFormatPDF, , strCriteria End Sub
  9. maggieTan

    Exporting reports to pdf files

    Hello, I am trying to use the Save as .pdf. I can get it to work with the .pdf add-in, but I can't limit the export to the record in view only. I tried using the same criteria I used for the printing....works fine for printing, but nothing happens using the following: Private Sub...
  10. maggieTan

    Access 2002 - upgrade

    Just went through a month of work moving our A2002 to A2007. THere were many little problems along the way. Reference issues, some cose issues and installation issues. Finally have the installation working using the 2007 dev. extensions. It was a lot of grunt work. We maintained the backend in...
  11. maggieTan

    Access 2007 code -references

    I am trying to launch JetComp via a button using the following in Access 2007 Runtime: Dim RetVal RetVal = Shell("JETCOMP.exe", 1) (I am aware that the user must close down before using JetComp...I am making it easier for non techs to find and use JetComp) The probelem is that this works fine...

Part and Inventory Search

Back
Top