Recent content by jamesaarnold

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...

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

Thanks! I'll give it try

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...

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...

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..

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...

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...

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...

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) & '/' &...

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) & '/' &...

=(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"))

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

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...

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...