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 Rhinorhino 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: *

  1. kevinluebb

    duration ???/

    I tried the DateDiff but keep getting a data type mismatch. I need to display the number of days on a report. the data resides in a table. InDate is in date/time format ComDate is in date/time format I created a query that will update a field in a new table. the field(daysdiff) is numeric...
  2. kevinluebb

    duration ???/

    I tried that (or so I think). Let me give it another shot. Maybe I've got "fat fingers" today....
  3. kevinluebb

    duration ???/

    I have a table with an INDATE, OUTDATE, NAME fields. I need to calculate the average duration by NAME. Is there a function in ACCESS that will calculate the number of days if given the INDATE, OUTDATE???? Once I have that number, I can come up with the average.
  4. kevinluebb

    Access, Outlook or just Microsoft Office-

    I think I know what you're saying there. I created a macro using the SendObject. I left the object type, object name, output format, to, cc,bcc blank(I will get promted for the to address). in the message text i put something like....new request entered. When i try to run the macro, it...
  5. kevinluebb

    SQL/ACCESS or ???

    Not sure what category this would fall under..... I've created a database in Access that uses multiple input forms that track projects our team is working. Users can enter new requests. What I'm wondering.......is there a way to notify me via Outlook that there is a new request (new record...
  6. kevinluebb

    Access/Office or ????

    Not sure what category this would fall under..... I've created a database in Access that uses multiple input forms that track projects our team is working. Users can enter new requests. What I'm wondering.......is there a way to notify me via Outlook that there is a new request (new record...
  7. kevinluebb

    Access, Outlook or just Microsoft Office-

    Not sure what category this would fall under..... I've created a database in Access that uses multiple input forms that track projects our team is working. Users can enter new requests. What I'm wondering.......is there a way to notify me via Outlook that there is a new request (new record...
  8. kevinluebb

    excel macro

    Sub Macro1() ' ' Macro1 Macro ' Macro recorded 2/1/02 by ISD Range("a1").Select For i = 1 To 30 ActiveCell.Offset(1, 0).Activate If ActiveCell.Offset(0, 0).Value = "" Then ActiveCell.Offset(-1, 9).Value = ActiveCell.Offset(-1, 9).Value + " " + ActiveCell.Offset(0...
  9. kevinluebb

    excel macro help

    Sub Macro1() ' ' Macro1 Macro ' Macro recorded 2/1/02 by ISD Range("a1").Select For i = 1 To 30 ActiveCell.Offset(1, 0).Activate If ActiveCell.Offset(0, 0).Value = "" Then ActiveCell.Offset(-1, 9).Value = ActiveCell.Offset(-1, 9).Value + " " + ActiveCell.Offset(0...
  10. kevinluebb

    excel macro

    I know that but look at the output.....the series of data represented by B ....the second to last line of data in E is no longer associated with the original series.
  11. kevinluebb

    excel macro

    can i lop off a portion of the actual spreadsheet and shoot it to you? at least you can then see what I'm working with.
  12. kevinluebb

    excel macro

    the sort range would be a1 .. e6 sort key would be column a
  13. kevinluebb

    excel macro

    can I attach a portion of the original spreadsheet to an email? It would be easier if you can see what I'm doing.
  14. kevinluebb

    excel macro

    The data got messy when it was posted. A B C D E F 1 aa aa aa aa aa 2 BBBB BBBBBB BBBBB BBBBBB BBBB 3 BBBB 4 CCC CCCCC CCCC CCCCC CCC 5 CCC...
  15. kevinluebb

    excel macro help

    It would be sorted by column A. So as you can see the data in E before the sort would be lost after the sort.
  16. kevinluebb

    excel macro

    I've got data that is roughly structured like this: A B C D E 1 AAAA AAAAA AAAAA AAAAAA AAAA A B C D E 1 aa aa aa aa aa 2 BBBB BBBBBB BBBBB BBBBBB BBBB 3...
  17. kevinluebb

    excel macro help

    I've got data that is roughly structured like this: A B C D E 1 AAAA AAAAA AAAAA AAAAAA AAAA 2 BBBB BBBBBB BBBBB BBBBBB BBBB 3 BBBB 4 CCC CCCCC CCCC CCCCC CCC...
  18. kevinluebb

    Access or Excel????/

    This is something I've been trying to resolve for some time and was wondering if there is a way to accomplish this in Access (since my Excel macro building is rusty) sequence data1 data2 Row1 0001 ad row2 0002 ad row3 0002 ae...
  19. kevinluebb

    parsing a text field

    I have a field in an imported table consisting of FIRSTNAME/LASTNAME. I need to separate the first from the last and put those into their respective fields within the same table. Not sure how this is handled in Access. I tried to use CHARINDEX in an update routine but can't seem to get the...
  20. kevinluebb

    Last name and first name string

    Not what I remember but I'll sure give it a shot. Thanks!

Part and Inventory Search

Back
Top