Search results for query: *

Put your code on the afterupdate event of the form Jesp

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...

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...

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

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

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

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...

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

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 ....

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...

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

maybe a PC system failure? Anyone??

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?

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...