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

  1. jamesaarnold

    QUERYING ON PART OF A FIELD!

    I am using access 97..I have a table with a field that has 2 pieces of information in a single field.. 1. supplier name 2. engineer name example.> basf-fred smith I'm trying to query on the second part of the data only example.. tell me all suppliers for fred smith I know it would probably...
  2. jamesaarnold

    MSAccess97 form resizing and screen resolution problems!

    Just wanted to thank you Chrissie..the form resizer worked great! Jamie is brilliant! I would recommend this to anybody with a similar problem.. Thanks Again! James
  3. jamesaarnold

    MSAccess97 form resizing and screen resolution problems!

    Thanks! I'll give it try
  4. jamesaarnold

    MSAccess97 FIELD SIZE DILEMMA!

    Actually I was wrong about the second part... So I went into one of my queries (yes a grouped query), that is when I got the error (Can't group on memo or ole object) and it refers to the field that I just changed to a memo field in my table) So if I change the field back to a text field...
  5. jamesaarnold

    MSAccess97 FIELD SIZE DILEMMA!

    I'm sorry I should have been more specific. After I changed the field property from a text box to a memo, I saved the table..It saved ok..When I went into the data input form, it would still only save 255 characters (not unlimited characters)..That was my first problem. So I went into one of...
  6. jamesaarnold

    MSAccess97 FIELD SIZE DILEMMA!

    I've tried that but when I run my queries I got a "can't group on memo or ole object"..So I went into the query and changed it to and expression, and several of the other options...and it doesnt work properly..It wants something in the "total" field in design view of the query..
  7. jamesaarnold

    MSAccess97 FIELD SIZE DILEMMA!

    My problem is I have an MSAccess97 database with several text boxes in the forms..What I need is to exceed the field size of 255 characters. My users have to be able to input text that exceeds 255 characters in each of these text boxes..But I have no idea how to make this is happen..Is it...
  8. jamesaarnold

    MSAccess97 form resizing and screen resolution problems!

    I was wondring if you can give or get me some help with a problem I ran into?? I'm using Access97 (don't ask why our software is so antiquated). I currently have 4 forms in my database. They are named: NEW UPDATE FORM, SQE ISSUE UPDATE FORM, UPDATE REPORTS, UPDATE SORT/REWORK/STATUS...
  9. jamesaarnold

    I NEED HELP DISPLAYING FORMS!

    I have a access database in access97..We have approx. 50 workstations. The problem is: When I view the my forms on my workstation they fit the screen perfectly, but when some of the other users view the forms on their workstations the forms are oversized, and they have to scroll to see the...
  10. jamesaarnold

    Help with report fields

    This is the expression I'm trying to use. =(DCount("[TRACKING NUMBER]","DAILY LINE UP","DateDiff('d',[DATE],Now()) > 14")) & " - " & (DCount("[TRACKING NUMBER]","DAILY LINE UP","[DATE] Between Format('1/' & Month(Now) & '/' &...
  11. jamesaarnold

    Help with report fields

    This is the expression I'm trying to use. =(DCount("[TRACKING NUMBER]","DAILY LINE UP","DateDiff('d',[DATE],Now()) > 14")) & " - " & (DCount("[TRACKING NUMBER]","DAILY LINE UP","[DATE] Between Format('1/' & Month(Now) & '/' &...
  12. jamesaarnold

    Help with report fields

    =(DCount("[TRACKING NUMBER]","DAILY LINE UP","DateDiff('d',[DATE],Now()) > 14")) & " - " & (DCount("[TRACKING NUMBER]","DAILY LINE UP","[DATE] Between Format('1/' & Month(Now) & '/' & Year(Now),'m/d/yyyy') And Now"))
  13. jamesaarnold

    Help with report fields

    yes, actually it was =[TXT204}, Just for grins I just tried it again and got the same results. Thanks again, I'll keep pecking away! Jim
  14. jamesaarnold

    Help with report fields

    I apologize. I do want to do a count. I need one field with a count of ytd records, and another with month to date records. I just tried your recommendation and it gave me an output of 1 in the field I desginated. One interesting thing it did, when I was setting the running sum, it did not give...
  15. jamesaarnold

    Help with report fields

    I don't get it? This did nothing for me! As I stated I'm Already using the code to get 14 days past due, =Dcount("[TRACKING NUMBER]", "[DAILY LINE UP]","DateDiff('d'[DueDate],Now()) > 14") It works Great. Now I need to be able to create duplicate fields on my...
  16. jamesaarnold

    Help with report fields

    I figured out the proper way. =Dcount("[TRACKING NUMBER]", "[DAILY LINE UP]","DateDiff('d'[DueDate],Now()) > 14") But now I'm stuck on how to get these same records sorted by month-to-date, and year-to-date on my reports. Any Ideas????????? Jim
  17. jamesaarnold

    Help with report fields

    I figured out the proper way. =Dcount("[TRACKING NUMBER]", "[DAILY LINE UP]","DateDiff('d'[DueDate],Now()) > 14") But now I'm stuck on how to get these same records sorted by month-to-date, and year-to-date on my reports. Any Ideas????????? Jim
  18. jamesaarnold

    Help with report fields

    I have created a database with a normal date field. In my report one of my fields needs to do a count on how many records are older then 14 days (past due). How do I have this field populated automaticlly on my report. I have been able to get sum, and dcount attributes to do totals, but the 14...
  19. jamesaarnold

    Help with report fields

    I have created a database with a normal date field. In my report one of my fields needs to do a count on how many records are older then 14 days (past due). How do I have this field populated automaticlly on my report. I have been able to get sum, and dcount attributes to do totals, but the 14...

Part and Inventory Search

Back
Top