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

So you confirm it is feasible to obtain a password used to protect VBA code within an Access DB ? Thanks for the confirmation, appreciated. MOBen.

I'm not looking at cracking passwords, more of a 'Yes' response i.e. tools exist which are capable of providing a solution for cases where VBA code has been protected and password has been lost/forgotten ? MoBen,

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.

Hi Ed, Tried that in notepad. Could not see any difference between the other values. Very strange, just can' put my finger on it ? Moben.

Hi Jedraw, No I have checked the original file and that particular cell. For some reason Access is seeing it differently, but then why not all of the data, why only 1 record amongst 100s ? Thanks for you response. 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...

1. I'm using Crystal Reports 8.5 2. I've added a CR object called RptRecs from the VB6 toolbox onto my single form. 3. The report runs ok on my machine within the CR environment. Hope this helps ?

Hi Joe, All I have is one form with some 2 menu options to run the reports. Upon clicking one of these, the following code is run: frmLogon.RptRecs.ReportFileName = gx_path & "Report.rpt" frmLogon.RptRecs.Action = 1 The report nearly views, but then it gives the "Cannot open SQL...

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

Hi ArtieChoke, Thanks for your response. I realised that the following code was sufficient: x="31/Oct/" + current year i.e. 31/Oct/07 y=weekday(x) Note that for the values for weekdays for sun~sat are 1~7. The date that I require (Last Sunday in October) = x-(y-1) What do you think ...

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.

Thanks for your help. I used Pwise's code (modified it slightly to include current day i.e. [DigitID]-1 )and it works. Thanks, Mob.

Thanks for your help, I have not yet tried your solutions, aim to do so this weekend, will get back to you. Regards, Moben.

Thank you very much for the quick responses. I have managed to get a query to create the dates, but if I link the combo to the query.... only 1 row is returned (unless I increase the value of the column count of the combo box) i.e. can only scroll horizontally. I need the query to return the...

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