Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: topone
  • Content: Threads
  • Order by date
  1. topone

    Query calculating days

    Hello I am supposed to write a query that gets the total of drugs dispensed in a day and also the total of the week (ends sunday) for a given period. I can get the first part of the query without problems. SELECT [Filldate], Count([Filldate]) AS itemused From CNumber WHERE RegionId=1 And...
  2. topone

    Program performed illegal operation while renaming .new to .exe

    Hi, I am getting an error - program performed illegal operation - exception 10h in module msvbvm60.dll when program checks for new version on server if exists downloads the program by closing the current program 1. App.exe -- calls AppUpdate.exe using shellcode 2. AppUpdate.exe terminate...
  3. topone

    Show Data Report with no printer

    Hello, I wrote a program in vb 6 to show some data reports getting data from access. I also installed a copy on my laptop. The program works fine on the pc but not on the laptop since there is no printer attached to it. The msdn library says that you need a printer to show the report, but...
  4. topone

    MSChart

    Hello, I am trying to convert an excel graph into a Visual Basic Graph. I do manage to get the data from either a db or a file.The problem that I have encountered is that I cannot display the value of the column in the graph. The Y shows only values like 10, 20, 30 so if the value of a...
  5. topone

    Sql error

    Hello, I am trying to write an sql statement but an error keeps coming up. I need to retrieve data from more than one table so I a using the INNer JOIN statement, but still no luck. The error is in the from part according to the error message. Any help welcome The code part is SQLStr =...
  6. topone

    Closing Delimeter Not Found rte 2147217900

    Hello, I am using VB 6.0 to access an Access 2000 db. The problem is when I run the program this RTE comes up. "-2147217900 (80040e14) closing Delimetr not found ...". I know what is causing the problem but do not know how to avoid it. some fields of the data contain the character "'". I...
  7. topone

    Insert data into Autonumber field

    Hello Everyone, I am having a little bit of troubles storing data into a database. I will paste part of the code for simpler explanations. I send data from a server to the host application and try to update it by using recordsets. The first to tables work fine but when I try with...

Part and Inventory Search

Back
Top