Search results for query: *

Can any one help me with the following problem that I am having with CR ver 8.5. I am trying to export a CR report to PDF & RTF format within VB6 code. The pdf is being genrated successfully upon a developer's PC, but not upon a user, with error message 'PC ActiveX component could not be...

If I password protect VBA code used within a Access 2007 and then lose/forget password, is there any way of finding out the valeu of the password ? Any feedback would be appreciated. Moben.

I have a application developed in VB6, with Access 2000 as backend, using CR8.5 for reporting, running upon W2K and Office 2000. Application working correctly. Tested same application upon Vista and Office2007 PC. VB6 side of application working correctly. However when I select a report from...

I have a VB6 application with Access 2000 backend, using Crystal Reports 8.5. On occassions i get a run time error 20533 invalid parameter field menu when selecting a CR report from the VB application and app crashes. Log back in, attempt to run same report again and it works ! This is an...

I have several VB6 applications with Access 2000 as back end, running on Windows 2000. We will be moving to Vista next year. Question:Will the VB6 application run on Vista, if not what changes are required ? moben.

Dear All, I have a spreadsheet saved with a 'csv' extension. The 1st column contains incrementing numbers 1058, 1059, 1060, 1061 etc. I link this file into a Access 2000 database and proeceed through the link wizzard no problems. When I view the linked file within Access, the numbers look the...

I have a datagrid in vb6 which is linked to a recordset query from Access2000. Data display ok, but is sorted incorrectly. The query 'feeding' the grid is simple i.e. select * from xtable order by xnum. Unfortunatley the data is orered incorrectly within the datagrid. Is there a sort...

I have a simple VB6 application which call (allows the user to view reports within Crystal Reports 8.5). These reports obtain data from tables contained upon a SQL-Server 2000 database. During design it was ok to login to SQL-Server. When attempting to run the reports from VB6 I am getting a...

I want to be able to work out the dates of time changes in March & October (last Sunday). E.g. I want to be able to compare a date in March against the date when the times change i.e. the last Sunday in March. Can anyone shed any light ? Regards, Moben.

Dear All, I have a Access 2000 database application. I want to add dates to combo/list box (which ever is easier). The values will be the current day, current day +1, and current day +2. If the current date falls on a Friday, then Current day+1 should Monday etc. The user can select one of...

The following is a simplied version of the problem that I am experiencing when copying a Access 2000 database from one server & client environment to another (live site to disaster recovery site) Some queries stop running at DR site. Upon investigation it appears that within the design view of...

I have a append query, where a field is an expression consisting of some fields which return a date of format 29SEP06. I actually want a value of 290906 to be saved to a field of type Date within a table. I have tried the following to no avail i.e. nothing saved...

Hi, Does anyone know how to extract the decimal portion of a real number, is there a function i.e. 100.25 I only want the .25 part. I want to perform a simple calulation and then add (concatanate) the result to the integer part of the entire number. I thought here might be some fucntion...

I have a VB6 application which call Crystal Reports ver 8.5 reports. Application is running ok, problem occurs when I try to run a report, run-time error '20532' Cannot find database DLL occurs and the application crashes. The machine in question is running on Windows 2000 and the application...

Suddenly my VB6 application is displaying the following error message : Disk or network error. OK Clicking OK and the message window (containing a red cross) disappears and the application function as normal. I can't even trap the error. Ideally would like not to have the error, as it may...

Does anyone know how to call and run a Access 2000 macro from within a VB6 application. Any help appreciated, Regards, Moben.

I am linking a Excel sheet into a Access 2000 db. Some data values display '#Num!' value when viewing the linked data within Access. If I view the spreadsheet within Excel, the data seems fine. The fields in question are numeric, but when I go through the Access linking wizzard I change their...

I am getting this error 20535 (error in file 'reportname.rpt'... unable to connect:Incorrect session parameters) on a client machine running Windows & Access 2000. The error occurs when attempting to print/preview the report from a VB6 application which has a Access 2000 back-end. The VB6...

I have a VB6 application which uses a Access 2000 database. I want to be able to connect to a SQL-Server table (can't link into Access DB, as SQL-Server table has too many indexes, which I can't delete). I am accessing the SQL-Server table using the following code. Dim rsFutures As...

How does one get the date/time stamp for a file (on a Windows networked file server) within a vb6 application ? I need to compare file of the same name being replaced every 15 minutes ? Any responses very much appreciated. Regards, Moben