Search results

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

Hi Pat. Originally the ACCESS app wasn't split. 20 people were using the same mdb file (which was UI as well as db). I know, it sucks big time and a major source of problems. However, even if it was splitted, it is still not reliable enough for my client's needs. That's why I chose to upasize...

Hi Pat. Thanks for your advice. You right, changing it to unbound forms is a big task . I will give it a go on MSDE MSDE. As to your question, I'm upsized it because ACCESS had 20 concurrent users, it kept on crashing, loosing info, and to run terribly slow. I had the option of trying to...

HI. Your help is very appreciated. *I upsized ACCESS 2002 (tables only) to use SQL SERVER 7.0 as backend. (linked tables). * Almost all the ACCESS forms are bound type forms. Now, I have two problems: 1. Other applications (not ACCESS ones) that use different dbs on the same SQL SERVER , are...

1. In the VB code, get a recordset with the data required for the output. 2. Write set of functions (each function corresponds to one required output format), that accept as parameter recordset row, and will format it accroding to the different formats that you require. Hope it helps..

Hi. your help is very appreciated. I upsized MS ACCESS 2002 app to SQL SERVER 7.0 (tables only). The problems: 1.ACCESS Queries that filter by checkboxes values on the form don't return correct results. i.e. "SELECT fld1 FROM tbl1 WHERE fld2 = Forms![frm1].chkboxControl " I...