Search results

I have been trying to get my crosstab working and have run into a spot of bother. I have followed the process detailed in SOLUTIONS.mdb to the letter but keep getting thrown out with the rejection Run-Time Error 2448 You can't assign a value to this object" at the line highlighted in the code...

Crosstab Report Hi Keith I don't suppose you have access to a 97 version of the crosstab report at all. I am having real trouble creating the dynamic totals for my report and any help would be greatly appreciated. I originally used the sample database from the Lebans homepage and a few tweaks...

scratch that comment. all code is required otherwise an error comes up stating that Object doesn't support this method

Hi, Thanks for the reply. The spaces in the code are from cutting and pasting into this forum. However, you are correct, the 2nd form word should not be there forms!frmoutershell.frminnershell.Form.frminnerinnershell.Form.Filter = strSQL The 3rd form declares the location fir filtering...

Sorry, my bad. The Required = No field is in the Table design, not the form. Anyway, in your IF statement there should be either a variable for the combo box value or a direct link such as Forms!myform.cbobox. This line is the one that needs to be omitted. (use a ' to switch it off and then test...

For you to have a message box telling you that all fields must bee completed, there must be an IF statement in your code which checks each field for data. As long as Required=No on your combobox properties then you should be able to omit the field from the check in order for the code to move...

Hi I have created a combo box with some underlying code to filter the results on my form by a specific field. In other words, I select a field from the list and the form is set to sort ascending by this selection. Well, that's what I would lilke it to do anyway. To do this I have been looking...

Hi all I have been using some code from this site to filter my forms and subforms via a selection of combo boxes. However, when I try to filter by either date or callid, I get runtime error 2001 and the debugger drops in at the first forms!filter line. This seems to work perfectly well for the...

Hi all I have created an email link for Groupwise in order to be able to send queries from my database to the relevant people. I would like to be able to open up my Groupwise address book and select the people to send to but I cannot find a way of pulling the information back from the address...

Hi all I am trying to filter one of my tables from code to match up with a reference on my opening form. This reference is a building code. Basically I want to select the building I work in and have the tables filter for those specific results. I then need to use this reference in any new...

Hi all I need to create a piece of VBA to stop data being entered into a particular cell unless certain other ones are blank. THis is is ensure that no data is entered for an overall category if anything has been entered for it's subcode. I.e. If cells E4 to E7 contain data then cell E3 cannot...

Crosstab report Ok, to get into the backend, hold shift whilst opening the database. To find the code, have a look at the code behind the Summary Report button on frmoutershell and the Output to Excel button on setdates Hope this helps Regards Jason

mboe Unfortunately, I couldn't fully work out how to write the code. Instead, I left the Excel Output in and use that instead. It is accurate, saves automatically to your My Documents folder and is printable from there. Regards Jason

Hi Tom I have created a work around for the moment which does the job. Our company is moving over to Outlook in a couple of months so I have had to start re-writing the code ready for that. Swines. Thanks anyway Regards Jason

Hi Tom Did you ever resolve this issue and if so, how? I am trying to get an address into my database using the ActiveX Groupwise Address control but I cannot figure how to pull the selected email into the corresponding text box. (or any textbox for that matter) Regards Jason

Hi Keith I did create a class called GW using the coding provided with the basGWdemo. However, I cannot find a method/function/property in there to do this. If I was going to create a new method within this framework, what would be the best way of going about it? I am fairly proficient at...

Hi I have created an call logging system for my company and have integrated the basGWdemo for Access 97 module into it. I have given it the ability to add multiple names for sending emails which is all well and good. However, at present, the mail is sent out without Groupwise actually being...

........:p

I didn't realise Angels had birthdays. Happy Birthday, Pat.

Thanks Paul Hopefully it should go without incident now but who knows. Regards Jason