Search results for query: *

Hi Gus I appreciate you taking the time to respond to me. The problem is that the control is a check box and this does not have an On_Change event. I have tried all the events that I think could fire for the control and for the form and none of them are registering an error. Any other...

Thanks for the suggestion - the problem is where do I put the code to trap this error? I have put on error code into every event for the object and for the form and none of them caught an error - they just all displayed a message to say they were fired. When all the events had fired, the message...

Thanks for the suggestion, but I had already tried that and it makes no difference - the message still appears. In fact, if I change the form RecordsetType from Dynaset to Snapshot, the message does not appear, but the message "This recordset is not updateable" does appear and I cannot...

I have a form based on a query where one of the fields displayed on the form is based on an expression - if the user clicks on this field (it's a check box), Access beeps and displays message "Field 'xxx' is based on an expression and cannot be changed". Is there anyway to suppress or...

Hi Pammi Sorry for the delay in getting back to you. Assuming you have the Crystal Report Control available (as per instructions in last reply), create a new standard EXE project, put a report control and a command button on the form. Let's assume the report is called CR1.RPT and that it's in...

Hi Pammi Have you purchased Crystal Reports separately, or are you using version 4.6 that is supplied with VB6 Ent. Ed.? The version supplied with VB (although well hidden on the 3rd CD and not installed by default), does integrate itself with the IDE so that the Report Designer option appears...

Hi Paul Thanks very much for the quick reply. Unfortunately that article didn't help as it just indicated I should change the Connect property which I've already done. It allows me to change the Connect property and I can display the new value in the VB app but when the .PrintReport method is...

Hi folks I have a report created with CR 4.6 (that comes with VB6) which connects to Access 2000 via ODBC. It runs fine within CR and via VB using Crystal ActiveX control. However, I want to be able to dynamically change the Access database that the report connects to at runtime. This is...