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

    Convert datetime field

    Hello, This is my first time using Crystal Reports. I have created a report from a SQL database view. there is a datetime field that I am using to query my report. This is a daily report that I need to run. I have just found out that the data in my view is converted to GMT time which is 5...
  2. dful

    Keeping records in order after cutting

    I need to print 4 records to a page, then after printing, cut the reports in half then quarters. I then need the 1/4 sheets to be in sequence. I am thinking I need to reorder the records somehow. I think the reports need to look like this: (3 pages) #1 #7 #4 #10 Next Page #2...
  3. dful

    Open program with path in field

    I have a table with paths to other databases ex. Company Path CompanyX "C:company\xdata.mdb" CompanyY "C:company\ydata.mdb" Companyz "C:company\zdata.mdb" I want to display the company name in a continouous form & add a sub to the field that will open...
  4. dful

    Subtract fields in detail

    I am creating a report that lists amounts in the detail from records in a table. ex. Year #1 #2 2003 5000 800 2002 4000 800 2001 3000 1200 I am trying to find the difference between the previous record. ex. Year #1 diff #2 diff 2003 5000 -1000 800 -400...
  5. dful

    Opening another database with Access (VBA)

    I am trying to create an Access application that opens multiple Access applications. I can get it to work on my home machine with: Private Sub Command2_Click() Dim stAppName As String stAppName = "MSACCESS.EXE C:\2003\database4.mdb" Call Shell(stAppName, 1) End Sub I can...

Part and Inventory Search

Back
Top