Search results for query: *

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

Can anyone out there tell me how I can read through all the values in a multiple select box in a loop? I have managed to get the user to enter values in a textbox, click on a button to add the value to the end of a listbox, but now I want to be able to insert a new record into my database for...

I tried that originally and again now that it's almost working, but the with AddCurrentValue, parameters are being ignored totally. I just get all the prompts as at the last time the report was produced successfully. At least when I use the AddDefaultValue, the parameters are being set and the...

Looks like I'm getting there myself! The date parameter has to be declared as a date variable in the VB program before adding it as a parameter. I've had to use the .AddDefaultValue method to get the CR to accept the values I'm passing it as the new parameter values. It all works fine except now...

Well, it seems as if my first problem is that the collection is 1 based, so I've changed my array list to start from 1 to 5. Now I'm getting a type mismatch because the first parameter is a date. Any suggestions anyone?

I'm using the RDC in VB6 to export a CR8.5 report to .PDF format. The report is based on a SQL Server stored proc that expects 5 parameters. I've tried using the parameterfields method to add the parameters, but I get a subscript out of range error. Can anyone help me get the parameters thru to...