Search results

Well, at any rate, thanks! It's working for now!

Thanks!!! That worked! The full field is "OFF", but I tried your suggestion and seem to be getting the correct results now! All that is in the field is either "OFF" or nothing at all. Are there other 'invisible' characters being added to the fields that don't show up as text that cause the...

Thanks for the suggestion...I tried that with no luck. :( If I leave the criteria box blank for the field in question, I get results where (in the field I am concerned with) some of the records have "OFF" and some have no entry. Why doesn't <>"OFF" give me all the records that don't have "OFF"...

Thanks for the reply....I tried putting both criteria in a single box (I'm using the Design View) like this: (<>"OFF") OR (Not Null) I'm still getting no records returned!!! All I want are records that do not have the word "OFF" in that one field, and I'm not sure why simple string comparison...

Hi, I am having a similar problem in Access XP, and the above suggestions do not seem to be working. I have a query that needs to select all records except those that have the word "OFF" in a certain field. This field either has "OFF" or is unpopulated, however, someone could put in an "OFF"...

Hello all, I am trying to find a way to put a header on my report that extends all the way across the page, while the body of the report maintains 1" margins from the right and left sides. Is this possible? My company really wants their letterhead graphic inserted at the top of the report...

Removing the word "Distinct" from the sql worked. I guess I didn't really need it anyway, since I have my autonumbered primary key being selected as one of the fields. Thanks! Ed

It's too big to post, and the data is sensitive client data for my lawfirm. I can post the structure with no data, though. I'll be at the office later this afternoon (Saturday 11/13) and attempt to do so. Thanks Ed

Additional information I have discovered that the field is being truncated due to a query: SELECT DISTINCT tblCharges.CHGATTY, tblCharges.RESPATTY, tblCharges.CLNTNO, tblCharges.FILENO, tblCharges.DATE, tblCharges.RecordNumber, tblCharges.CHARGE, tblCharges.UNITS, tblCharges.RATE...

Hello all, I have discovered a very disturbing problem in my project. Some of the memo fields are being truncated when my report is being generated, even though I have CanGrow set to Yes for this particular textbox. The data is retained in the table, and displays perfectly on the form, but I...

Thank you for the advice. I was not aware of the different binding. I will reasearch this and try to rewrite my code. Is there a speed advantage to early binding? Thanks, Ed

Is there anyone who could help me? Please? Thanks Ed

Please see http://www.access-programmers.co.uk/forums/showthread.php?t=63432 for a details about this problem. I'm not sure how to turn a find duplicates query into a delete query. Thanks, Ed

I wrote this code to cycle through my table and delete any duplicates. I'm having two problems with it, though. For testing purposes, I've redirected some output to the immediate window. When run it appears to be working, however no dupes are being found. I find this odd, because a find...

It turned out to be a reference error. I've got the code running right now on a test copy of the data. It's slow. Very slow. However, after a bit of tweaking, it seems to be doing the job! Thanks for all your help, everyone. Ed

O.K. I've worked up some code, but my inexperience with VB is frustrating me. Can anyone tell me why I am getting error 13, "type mismatch" on the line that begins "Set rs = ...."? Here's the code: 'Find dupes in tblDocket, remove dupes with shortest comment length Public Sub DelDupes()...

Kodo, That gives me the same error as posted before. Is there a good way to accomplish this programmatically? The only method I can think of seems very inefficient, but here it is: 1. Open recordset 2. Compare all the records to the first record 3. If a match is found, delete the first...

Well. I tried making a copy of the originall table's structure and then modifying my query to be an Append query.....the exact same error message shows up. The field "COMMENT" is a memo field, however... Is there a way to set the destination field type from within the SQL? Thanks, Ed

I tried the following SQL statement: SELECT DISTINCT tblDocket.DUEDATE, tblDocket.CLNTNO, tblDocket.FILENO, tblDocket.ACTREQD, tblDocket.PRIORITY, tblDocket.MRKD_OFF, tblDocket.RATTY, tblDocket.COMMENT INTO d2 FROM tblDOCKET; This produced the following error message: "The field is too small...

OK, thanks. I'm at home now, but I'll try that in the morning. Ed