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 Chriss Miller 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
  • Order by date
  1. zipur

    SQL underscore Fields in Pervasive SQL 2000i

    That got it working. Thanks, I think I tried everything other than that :)
  2. 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...
  3. 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...
  4. 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...
  5. zipur

    stLinkCriteria &amp; Query

    Never Mind... I created a new report which groups by customer and then I removed the detail area of the form and used the group summary. Gave the desired result... if there is another way to do this, let me know please.
  6. 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...
  7. zipur

    Pass Values To Report Printing Silently

    k, that works BUT is there a wat to use Defined Variables from the form in the report? If not I could create some hidden form fields and transfer them that way OR create a global or something. Just wanted to know if you can Define a Variable in a form and then pass it to the report?
  8. 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...
  9. zipur

    24Hr Time Format - How?

    I love this forum!!! You guys are great, thanks! [2thumbsup]
  10. 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]
  11. zipur

    Load Variables With Current DB Data

    Cool, I tried this and works great!! Thanks Much! Dim Rs1 As ADODB.Recordset Dim SQLCode As String Set Rs1 = New ADODB.Recordset SQLCode = &quot;SELECT COUNT(LTicketNum) As test From TransIn&quot; Rs1.Open SQLCode, CurrentProject.Connection Rs1.MoveFirst...
  12. zipur

    Load Variables With Current DB Data

    Ok, that gives me some ideas... but what I really need to know is the proper way to load variables from the tables for use in calculations/field population/inserts/etc. Since my post I have figured out: Dim Rs1 As ADODB.Recordset Dim SQLCode As String Set Rs1 = New ADODB.Recordset...
  13. 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