Search results for query: *

I wrote an application using Access 2002/XP, and my supervisor wants to have it upgraded to Visual Basic 6 with a SQL Server 2000 back-end. Is there a program or utility available that can automatically do this, or will I be stuck in re-writing the entire program from scratch. Please advise...

I have a user who is experiencing two errors with an application written in Lotus Approach version 9.8. The application is currently housed on Windows XP machine. The errors are: (1) Can not find the memo and picture plus file for C:\Lotus\Work\Approach\Cymaster.dbf (2) Warning...

I am working with another person on creating an MDE file out of a Access 2000 database. The program was written in Access 2002 using a default Access 2000 format. Whenever my co-worker tries to compile the database as an MDE file, the option is disabled. When the database is opened in Access...

I have an Access database which I recently upsized to SQL Server using the Upsizing Wizard. When I link to these tables in another Access database, the tables open up OK, but the data is read-only. I can look at the tables in SQL Server, and they are read-write there. Is there a way to move...

We have a large number of CR 8.5 files that involve a picture of someone's signature and their by-line being placed in them. We have recently had several cases of employee turnover in our organization and some of those people have had signatures on those letters. Is there any way to actively...

Can a SQL stored procedure be used as a data source for a Crystal Reports 8.5/9 file, and if so, how do you establish the connection between the report and the procedure? Please advise. Thank you.

I have an application written in VB5 that contains two CR9 report files imbedded as designer (.dsr) files. We have discovered that these CR9 files are linked to the SQL Server database using an ODCB connection. Is there any way to link the database to these two reports without using an ODBC...

I have an application written in VB 5 using Crystal Reports 9 for a couple of reports. In the code I am using the Report.Database.LogOnServer to set the DSN and database that the CR9 report is looking off of. We would like to be able to change the DSN and database between a production and test...

I want to be able to change a value in a text box, but I am getting a run-time error 2448 (You can't assign a value to this object.) Here is the code that I am currently using (the current value of the text box is a carat (^), and I want to change it to a letter A): Select Case PER1ID_11Value...

I am receiving an error while attempting to access the tables portion of one of my databases. Error text follows: Title Bar: SQL Server Enterprise Manager Error: [red circle with white "X"] Error 0: Numeric value out of range (with an OK button) Does anyone know how to resolve this? Software...

I am currently writing an application for importing text files into an Access database using import specifications. I wait to be able to do the following: 1. Allow the user to enter the name of the text file, with the full file location, folders and all. 2. Split the file into two parts since...

Is there any way that I can show the standard Windows dialog box for selecting a printer for a CR9 report in a VB5 application? Please advise. Thanks.

I am working on a VB program that is using several SQL statements intermingled into it. On of these statements is taking exception to a statement in a VB text box. At my last job, I was told that there certain characters that SQL Server just doesn't like, such as apostrophes (which is what...

I have finished modifying a VB application using CR9 for its reporting tool. I have two reports written inside the application itself as Designer (.dsr) files with a report viewer created for each one - these are the ones that were modified -- , and the rest of the original reports are still...

I recently installed Crystal Reports 9 on my machine and want to incorporate it into an application that I am working on. The application originally contained 5 reports that were created in an older version of Crystal Reports. I am going to create one giant report which will contain the...

My company has just acquired version 9 of Crystal Reports and plans to implement it in an existing application. We also purchased a laser printer with duplex printing capabilities. The boss wants to use the duplexing mode at all costs and I would like to know if the reports in this system can...

I just recently upgraded to Access 2002, and converted most of the applications that I had written. On one of my applications, I have several tables linked from SQL Server. Also in this database, are several reports that are dependent on those linked tables to provide the needed data. My...

I have a table with two fields. The first field is a "record number" and the second field is a separate "catalog number". I want to be able to view the items from the second field across so that they are in a separate field, so that there is a unique "record...

I have a table with two fields. The first field is a "record number" and the second field is a separate "catalog number". I want to be able to view the items from the second field across so that they are in a separate field, so that there is a unique "record...

I have a table with two fields. The first field is a "record number" and the second field is a separate "catalog number". I want to be able to view the items from the second field across so that they are in a separate field, so that there is a unique "record...