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!

Register Log in
  • Congratulations Chriss Miller 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. djjesp

    code to update field on another form

    Put your code on the afterupdate event of the form Jesp
  2. djjesp

    fatal error form with tabcontrol in Access97

    Hi, I created a form with a tabcontrol with 6 pages in Access2000. This works fine. When I convert the mdb to Access97 and then try to open that form (runtime or design), I get a fatal error (op0177: 30219724) and Access is terminated. When I convert the mdb back to Access2000, it works fine...
  3. djjesp

    Retrieve ALL data during creation of report

    I'm using DoCmd.OpenReport. The problem is that the reports are partly based on temporary tables. Tables I populate when the user wants to view a report. When a second user, in the same moment, wants to view the same report, based on different selectioncriteria, I overwrite the data of the...
  4. djjesp

    Retrieve ALL data during creation of report

    Hi, I want to retrieve all data for all pages of a report(and its subreports) in one time. So no db-activity when navigating through the different pages of a report, it should already be in memory. Does anyone know a property or some VB-code to get this done?? regards Jesp
  5. djjesp

    reports & runtime version of Access 97

    So, you mean the people in my company that distributed the runtimeversion of access? I will check that. Thanks, Jesp
  6. djjesp

    Adding total fields from subreports - empty fields cause error

    Try something like: Grandtotal: IIf(isNull(Total1;0;Total1)) + IIf(isNull(Total2;0;Total2))+ IIf(isNull(Total3;0;Total3))+ IIf(isNull(Total4;0;Total4)) or Grandtotal: IIf(isEmpty(Total1;0;Total1)) + IIf(isNull(Total2;0;Total2))+ IIf(isNull(Total3;0;Total3))+ IIf(isNull(Total4;0;Total4)) Jesp
  7. djjesp

    reports & runtime version of Access 97

    Hymn, I'll try to explain how it's set up in this company. We're not exactly creating a runtime version. We just put the mdb on the netwerk. Depending the authority,userrights of the user he can access the mdb with a runtime version or a normal version. In case of the runtime version, we have...
  8. djjesp

    reports & runtime version of Access 97

    Hymn, how, where do I add those components to an existing mdb??
  9. djjesp

    reports & runtime version of Access 97

    Thanks Hymn, I'm gonna check if I added all those components. Due to authorisation, security and so, I won't be able to test it until tomorrow. So thanks for your help, although I don't think it's the answer to the dateproblems ....
  10. djjesp

    reports & runtime version of Access 97

    Hi, We created an application with Access 97 and distributed it to users who only have a runtime access version. Two problems when running the runtime version: 1. There's no printing option in the filemenu for reports(there is for forms), although shortcut crtl+P works. 2. Dates are not...
  11. djjesp

    MSAccess applicationerror after sending an object to Lotus Notes

    Ben, That was what I was looking for. I gave it a bit more functionality, like automatic opening of Notes, CCC and BCC sending, but it showed me the way, Thanks Jeroen
  12. djjesp

    MSAccess applicationerror after sending an object to Lotus Notes

    maybe a PC system failure? Anyone??
  13. djjesp

    MSAccess applicationerror after sending an object to Lotus Notes

    I tried above with outlook express and that goes fine all the way. So must be a problem between Access and Notes. Maybe I'm missing a reference?
  14. djjesp

    MSAccess applicationerror after sending an object to Lotus Notes

    Hi there, I'm getting an MSAccess applicationerror after sending an object to the Lotus Notes mailaccount. My code is as follows: DoCmd.SendObject acSendQuery, "query", acFormatXLS, toAddress, , , subject) Lotus notes opens correctly, the xls-file is created correcty and the subject...

Part and Inventory Search

Back
Top