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 bkrike 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: zipur
  • Content: Threads
  • Order by date
  1. zipur

    SQL underscore Fields in Pervasive SQL 2000i

    I need to access from a Pervasive 2000i server via ODBC. The ODBC is working fine but the data names in the table are causing problems. The datanames were named as _name, _address, _faxnum, .... I realize this is not the best naming convention, and it was a different company that did this...
  2. zipur

    MS Excel Hyperlink To Increment By Row?

    I have a spreadsheet that has a cell with the following value: (note: true file path removed to keep it clean) =IF('C:\[1025.xls]Information'!$B$63<>0,'C:\[1025.xls]Information'!$B$63,IF('C:\[1025.xls]Project Information'!$C$7<>0,'C:\[1025.xls]Project Information'!$C$7,&quot;New Job&quot;)) I...
  3. zipur

    Error - Mount failed

    Just installed a new Seagate IDE TR40 Tape Drive. The manual backups work fine, but each time I schedule a job for 11:55 PM I get this: ====================================================================== Job server: NTSERVER Job name: Backup 0001 Job started: Wednesday, September 18, 2002 at...
  4. zipur

    stLinkCriteria &amp; Query

    I have a form that is pulling records from a table and sending them to a report. All works fine. BUT I want to select records between #date1# and #date2# no problem... I wrote the sql like this stLinkCriteria = LDateOut>=#01/01/2002 AND LDateOut<=#08/30/2002# ... Unless I use the LDateOut...
  5. zipur

    Pass Values To Report Printing Silently

    I have a button that prints a report based on the data of a form. This works great, BUT... I want to label the report depending on the contents of the form... for example if the StartDate and EndDate of the report are based on 2 fields on a form, how can I show these values in the header of the...
  6. zipur

    24Hr Time Format - How?

    How do you format a Time for 24hrs with VB? The following uses 12hr without Am/PM: StartTime = Time Thanks Again [bigglasses]
  7. zipur

    Load Variables With Current DB Data

    OK, I have not done much with Access 2000 VB so here is the problem: I want to create a variable in VBA that for example loads the sum of a column in a table. Sounds simple, I know, but I am missing something. Any help is appreciated!!! [bigears]

Part and Inventory Search

Back
Top