Thanks so much for the suggestion. I thought I did that last week, but I was getting so frustrated that I probably did not do a good job. I will try it again with a fresh mind today.
Thanks again.
I developed a VB program to handle order entry, originally for an Access database. Developement was done on a Windows 2000 machine, and the program changed to connect to a SQL Server database. When I install the package on a Windows 2000 machine, I get "Run-time error 53. File not...
Thanks for the suggestion.
I have been reading SQLBOL, and it has been helpful.
My son, who also programs, suggest I pick a small table with just one index to work with until I get it figured out. That has been my project this afternoon. So far I have not had any success, but I will keep...
I am new to SQL Server and hope I have any easy question.
After upsizing an Access database to Sql Server 7.0, I am unable to view the tables using the Enterprise Manager or access the data from VB programs that were working under the Access database. I am connecting to SQL server thru VB but...
I have just started using Sql Server 7 and am having a problem viewing the data that I upsized from Access 2000 or accessing it from working VB programs. I assume the data is in the database from the size of the file.
I upsized the data from Access 2000 to Sql 7 so I could include the indexes...
I have written an application using VB 6.0 SP5. It consists of many forms and is pretty complicated - order entry, billing and inventory control. It installs on the client machines without a problem and starts just fine. But when it calls a complicated form, I get "Runtime error 0"...
I am getting the error message "VB6 caused an invalid page fault in module VB6.EXE at 0177:0046fb01" every time I close VB. Thinking the problem was caused when I uninstalled a virus protection program - PC-Cillin, I reinstalled Windows 98 and VB6, downloaded and installed SP5 for...
Thanks for all the help. You can color me inept and inexperienced in Crystal Reports.
I had neglected to add a data environment and crystal report to my application. A reference to Crystal Reports on the form and the report with code on a command button on the form was what I had done.
I...
After working with the selection formula for several hours and using the Seagate utility to insure the both Crystal Reports and Access were using the same System.mdw file, I am getting the same results.
Further info: the order number field in the Access table is defined as a long integer.
I...
Thanks for the suggestions.
I commented the line defining the string selection and the same problems occurred, but I believe you are correct about the selection formula causing the problem. I will attack it that way today.
Again, thanks for pointing me in the right direction.
I am trying to print a picking ticket from data entered by an order taker. The data is stored in a database table using Access 2000, ADO, and VB 6.0 SP 4. I am able to view the data with Access and it looks correct. The table only contains the information for the order for which I wish to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.