Recent content by jpember

I must be going nuts because the help I've got refers to 'Adds a list item to the specified command bar combo box control'. I have a normal list box and when I click on a button, I want the selected item to move into another list box. When I use the AddItem method, I get an error saying that the...

is additem supported in Access? I can't seem to get it to do so on my listbox. Thx, Jacqui

I have managed to programmatically change the printer from the default to the PDF writer and then back to the default in Windows 2000 and Windows XP. The code I used for this was elsewhere in this forum - thanks by the way! But, Windows Me seems to be different. It doesn't have the same...

Thanks for the info guys. Basically because I'm prototyping in Access, i.e. front and back-end's are Access.mdb's, I can't use coc86's suggestion until I move the database into SQL Server - Access won't let me do a pass-through query to another Access database. In the meantime I was doing what...

Yes, so I have read. However, when I create the recordset in the Report_Open event and then try and assign it to the reports recordset/recordsource property, I get errors such as invalid property or type mismatch etc. The problem is that there is plenty of statements around to confirm that this...

Can anyone point me in the right direction to create a report based on a recordset built from a SQL Server Stored procedure? I am using Access 2000 ADO.... Thanks in advance, Jacqui

I've got the Treeview control working beautifully in my Access app, but the next step has thrown me! I need to produce a report on the same hierarchy that I'm using in the treeview. Can someone point me in the right direction please? Thanks in advance, Jacqui

I know this is an obvious one, but are you sure you (or your webserver) have permission to read files in that directory? Jacqui

If you create a query with all the key fields of all the tables you're wanting to use in the form, and then base the form on this, it should work. It may sound like you'll have redundant data on your form, but you can hide these so that they aren't visible to the user - just make sure that they...

I have saved my report without data as you suggested and also added the CurrentValue lines of code (I first tried replacing the AddDefault but this didn't work either). With rdcReport .ExportOptions.FormatType = crEFTPortableDocFormat .ExportOptions.DestinationType =...

Ken - here are the answers to your FAQ: 1) 8.5 2) ODBC 3) VBA - Access 2000 4) RDC (CraxDrt.dll/CraxDui.dll) Thx, Jacqui

My problem is that it has never worked - but only the exporting pdf format bit. I can send the report to the printer without any problems. I haven't and don't want to install CR on the machine in question, just the dll's for the export to work. It all works on my own PC, but that's because I...

I'm using CR8.5 and I'm still not winning on this one... Seems like there are loads of us in the same boat out there. Ken, have you got any more suggestions? Jacqui

I am having the same problem and have got the CRXF_PDF.DLL installed. Any other ideas? Jacqui

Thanks Rick - I understand what you've given me. How does this fit in with the form object that I'm using to pick up the values? i.e. how can I refer to the list box or array using the Request.Form("fieldname") method/function? I want to evaluate all the values on the server side after...