Search results

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

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

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

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

Hi. I recently created SQL SERVER backend for my MS ACCESS app. (I upsized ONLY the tables, so the ACCESS app contains linked tables). The SQL SERVER resides on a different machine than the MS ACCESS app. Every time that I run the ACCESS app, it fails to connect to the SQL SERVER ("Login...

Hi. Your help is very appreciated. I want to upsize large MS ACCESS(2002) app to MS SQL SERVER 2000. [ By "large", I mean 250 queries, 78 tables, 110 forms]. The app will be used by 25 concurrent users.(therefore the need to upsize). I have time constraints of 2 weeks to deliver. My questions...

Hi. Thanks a lot for your help. In my ACCESS app, I'm detecting at run-time the user's screen resolution. If it's lower than 1024*768 I'm modifying it to 1024*768 and then I maximize the ACCESS window (NOT the forms). My problem: After changing the resolution, maximizing the window will...

Hi. Your help is highly appreciated. I recieved an aready made ACCESS 2003 application that I need to distribute (build installer). 1. This app uses ActiveX controls. Is there a way to get a list of all the ActiveX controls that the app uses? 2. How can I install ActiveX components to the...