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 derfloh 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
  • 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

    Calculating Time

    I have never found a easy way to do date math, but this is what I use. I basically convert all of the time to minutes. the field with the times are [starttime] & [endtime] Use these fields in a query starthours:=Format$([starttime],"hh",0,0) endhours:=Format$([endtime],"hh",0,0)...
  3. dful

    Keeping records in order after cutting

    Awesome, Thanks!! I found another way to do it. If you are interested? I created a query "SELECT [table1].seqno, [seqno] Mod 4 AS Expr1 FROM table1 WHERE ((([seqno] Mod 4)=1));" Then append to a temp table (just like yours)with an autonumber field. This gives me the output like your...
  4. dful

    Keeping records in order after cutting

    Thanks for the reply. The print sequence number is determined by postal coding software. There will be various records. up to 60,000. This is just basic addressing data.(Seq, name, address, city, state, zip) the ordering needs to be dynamic depending on the number of records. if I print in...
  5. dful

    How To Display Global Variable On Report?

    Try ="variable" in the control source of the text box.
  6. dful

    Keeping records in order after cutting

    I think I need to explain more. I am printing postcards with address information 4 to a page. I am using columns in the page setup to get the 4 records on a page. The addresses are in a zip code order & I need to keep them in sequence. There is a field with the sequence number. My issue is...
  7. dful

    Keeping records in order after cutting

    Yes. There are only 2 options #1 #2 #1 #3 #3 #4 #2 #4 Next Page or Next Page #5 #6 #5 #7 #7 #8 #6 #8 This will not work when cutting the report into quarters
  8. 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...
  9. dful

    total in forms

    Single form or Continuous? Are you adding fields from different records?
  10. dful

    Open program with path in field

    It Worked. Thank you
  11. dful

    Open program with path in field

    I have made this work before with hyperlinks. This creates more problems for me though. When the hyperlink is selected the main form automatically minimizes (is there a way to control this because it does not happen on all machines?). The form is a pop-up that does not have min/max buttons which...
  12. 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...
  13. dful

    Opening another database with Access (VBA)

    Yes it does. Thank You
  14. dful

    Opening another database with Access (VBA)

    I found what the problem is but I am not sure how to fix it. the path is \\company\company files\2003\database4.mdb The folder name is "Company files" with a space. Is there a way to make this work? I can not change the name of this folder.
  15. 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...
  16. dful

    Opening another database with Access (VBA)

    The single quotes do not work either. Does it mean anything that the error: "Microsoft Access can't find the database file '\\company.mdb'" has company.mdb as the name of the file? I thought that was odd. I have tried similar code on other networks & it works fine. Could it be...
  17. dful

    Opening another database with Access (VBA)

    Still not working. I used the following path: stAppName = "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE \\company\companyfiles\2003\database4.mdb" This works on my home machine & my machine @work. It just doesn't work when I put the database on the network. I am getting...
  18. dful

    Opening another database with Access (VBA)

    Thanks. I will give it a try.
  19. dful

    Opening another database with Access (VBA)

    Is this what you mean? Dim stAppName As String stAppName = "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" \\company\companyfiles\2003\database4.mdb" Is this a valid path?
  20. 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