Recent content by roypython

Thank you David. I'll give DAO a go.

Hi David. thank you for your reply. When I set the filter, it just throws error messages so it doesn't realy set the filter. I tried to use JRO, than looked at ADO - and it's not such a flash option either. After spending about a week trying to figure out a way, I just added to the menu barm a...

Thank you very much!

Hello. Your help is very much appreciated. I want to launch the "partial replica wizard" from code. Can it be done? (It is located in Tools -> Replication ->partial replica wizard Thank you. Cheers Roy

Hello. I am using Stephan Lebans code (A2000ReportToPDF ) http://www.lebans.com/reporttopdf.htm His contrubution is Wonderfull !!! I am having a bit of trouble with specifying filter for the report... when I try to convert MS ACCESS report to PDF, how can I set up a filter for the report...

Hello everyone. Your help is very much appreciated. I am trying to create partial replica from the design master. it all goes well until I try to set the filter using: repPartial.Filters.Append "Customers",jrFilterTypeTable,"Customers.Region = 'CA' " It throws an error: "Invalid expression in...

Hello everyone. Your help is very much appreciated. I am trying to create partial replica from the design master. it all goes well until I try to set the filter using: repPartial.Filters.Append "Customers",jrFilterTypeTable,"Customers.Region = 'CA' " It throws an error: "Invalid expression in...

thank you for your quick reply. Printing the report using DoCmd.OpenReport stDocName, acviewNormal prints the report but crashes access immidiately afterwards. "OutputTo" method is used to save the report as file (which save the file and then crashes access as well) I'll try replacing the...

thank you. that's a good suggestions. The problem raised 2 application events in the event viewer. 1. source "Application error" event id: 1000 type: error Faulting application msaccess.exe, version 10.0.2616.0, faulting module msaccess.exe, version 10.0.2616.0, fault address 0x00035c14. For...

Hello. Your help is very much appreciated. I am using ACCESS 2002 (XP). I have two access files - one program (with link tables) and the other one is the database. I created ACCESS report. When opening the report for viewing - it's all good.( DoCmd.OpenReport "_rptDetails", acViewPreview ) When...

Hi. Your help is very much appreciated. I am trying to write a web service client in MS ACCESS XP/2002. The web service that I'm trying to connect to is protected with WSE2. I couldn't find any WSE package for VBA. It's all .NET packages. Is there any way to connect to the web service from...

Hello. Your help is very much appreciated. Because of printer limitations, I need to make sure that my report has even number of pages. Therefore, the code needs to check how many pages the report has, it it's odd number of pages - add blank page at the end. I tried to put page break control at...

Hello. I'm using a filter that contain # as one of the characters that the field might contain. I get some very inetersting results. using "select fld1 from tbl1 where fld1 not like 'D#%' " Lets' say that the values for fld1(text type)...

Hi. Your help is very appreciated. I'm using ACCESS 2002(XP). I upsized my Access app(s) (.mdb) to use SQL SERVER 7.0 as backend (through linked tables). There are about 40 users, each running his own instance of the front end (Access app ), all connecting to the same sql server 7.0 db. As a...

Yes. Sorry about that. :o