Replies

You would use the MS Office Developers Edition Tools in ’97. Unsure in 2000.

I believe than when your databsae approaches 1 gig, you will be reaching the limits of Access. I am not sure how many records this is.

I did create a set up and I did include the ocx file in the runtime. I have tried to create the runtime again, but with no success.
The app contains other ActiveX controls (that work fine). I noticed that with the other controls, susbsequent support files were needed. Do I need anything else for my ActiveX other than comdlg32.ocx?

Also, I do not understand your method using the class wrapper. Where can I find info about this?

Thanks,

Jonathon

I believe I do have a license for the control and it is a runtime that i developed. The app runs fine on a couple of PCs, all with ODE tools installed, but does not work on a PC without ODE. I think I may have “setup/install/register” the control incorrectly (if at all). Please can you help with how to do this properly.

Thanks.

I am coming across 2.

On making MDE files and occasional compiling I get:

“There was an error loading an ActiveX control on one of your forms or reports.
Make sure all of the controls you are using are properly registered. More info, press help”

Pressing help only demonstrates how to register ActiveX.

I have also tried to unregister and re-register the ocx comdlg32.ocx. I then get this message:

“C;Windowssystemcomdlg32.ocx was unable to add/remove itself to/from your system. Install/remove the control using a separate utility”.

I do not know which utility to use to do this (regsvr32?)

Any ideas?

No joy with new db. Any other ideas???

References were still there. Re-referencing them cleared the errror on compile, but not when creating MDE.

Had tried the first 3 and there was no success.

On compile, I got the original message again. After registering again, this error cleared, but not when the MDE file was attempted.

I am creating a new db now and will let you know.

Done!!

Form_frm…. .comdia1.CancelError = True

On Error Resume Next
Form_frmTimeInDept.comdia1.ShowSave
If Err.Number = cdlCancel Then
‘MsgBox “Cancel button clicked”
GoTo ErrHandler
End If
On Error GoTo 0

DoCmd…..

ErrHandler:
‘User pressed the Cancel buttonExit Function

To eloborate, my Access97 on Windows 98 does not recognise .CancelError. Can any please help regarding the references I need?????

The problem is that I build the filename for the user, specifying it as commondialog.FileName. I am not sure if the method you offered will work for me.

I am looking at commondialog.cancelError now but struggling.

Any more help?

Still no joy.
The Common Dialogue part is being used as an output for transferspreadsheet action, with the path to where the spreadsheet is to be saved to being the result from the common dialogue.
I don’t think the docmd.save will work for this.

Cheers for the reply, but I am a little more confused.(I am using the ShowSave).
What do you mean by UNC?

Thanks for replying, but i have now sorted it. I was applying it to a datepicker object, and have no realsied my mistake

Ignore me Rory – I have done it. Thanks for your help.

I’m going mad here!!!