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!

  • Congratulations strongm 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: Juppo
  • Order by date
  1. Juppo

    Reading data from USB port

    >How would I go about creating a simple USB link between 2 >applications running on 2 computers like you can with >MsComm I don't think you can use USB to directly link 2 computers you'd need a HUB but then Im new to USB (see above) and Ive also found a USB link cable...
  2. Juppo

    Reading data from USB port

    Hi Im new to usb and vb but have used C before. I was hoping someone could run through how I would read data from the USB port in Visual Basic. I've read/write data to serial port before in C but can't find much about VB/USB at the moment, Can anyone help? Im hoping to read data from the usb...
  3. Juppo

    New Records and Changed Records

    I guess you've got something like; Private Sub Form_AfterUpdate()Or a particular fieldbox Changed.value = True End Sub >Whenever a record changes, I want the YN field to be updated to True. I am currently using the form's Dirty property to do this. However, New records are being marked as...
  4. Juppo

    Reading/Updating Excel

    Hi I'v got it working but my update causes an error, whats wrong ? <% Filespec = &quot;C:\test3.xls&quot; Set objXL = Server.CreateObject(&quot;EXCEL.application&quot;) objXL.Visible = True objXL.WorkBooks.Open Filespec Set objWkBook =...
  5. Juppo

    Reading/Updating Excel

    Thanks FengShui1998 for the code but Im getting errors as it doesn't like the WScript, at least I have a rough idea about what Im aiming for.
  6. Juppo

    Reading/Updating Excel

    I can copy a template excel sheet (Purchase form) but need to be able to update specific cells (D9 - Customer Name,D11 - Address1 etc). I've searched and can find loadsa of ways to write to an excel sheet but really Id love to be able to; 1) Read in data from specific cells 2) Update specific...
  7. Juppo

    SELECT Query Question

    Probably something like SQL = &quot;SELECT id, title, publisher, location, description FROM tbllibrarypublications WHERE id BETWEEN (COUNT(id)-5) AND COUNT(id)&quot; but thats just my idea
  8. Juppo

    SQL problem

    I've got a problem with the sql I've just written. The error I get is Syntax error (missing operator) in query expression 'QUOTE NO = 6563' Im guessing its because of the field name 'QUOTE NO' that should really be called QuoteNo but is there some way to make sql accept that name? Have I just...
  9. Juppo

    change text area color

    Ah thank you !
  10. Juppo

    change text area color

    ok so Im using <TEXTAREA onFocus=&quot;bgColor='Blue'&quot; id=DETAILS title=DETAILS> to try and change the color of the text box when the persons clicked on it, but its not working so what do I need to use? Thanks
  11. Juppo

    No Read permission?

    I've created a data access page from a query table that queries a number of tables, one being called CUSTOMERS. I've shut everything down and opened this data access page but i get an error message Record(s) cannot be read; no read permissions on 'CUSTOMERS' Now I haven't set any permissions...
  12. Juppo

    How to Turn This Pic into a great one?

    Now I had to read that twice to make sure it wasn't an insult, but I agree that you need something good to start to work with.
  13. Juppo

    Counting Recordset problem

    ah, ok thanks swampBoogie
  14. Juppo

    Counting Recordset problem

    Cheers that works great, but why? Are you saying count rs from (0)? start at record 0 ?
  15. Juppo

    Counting Recordset problem

    Hi Im trying to make a user online counter (to count everyone viewing the site). Im a new to sql so obviously having trouble with things. In the internet database Im using a tabel called PPLONLINE with a field again called PPLONLINE. All I seem to be getting is -1 for a value even though there...

Part and Inventory Search

Back
Top