Recent content by S_Preston

MarkK, that worked! SELECT Len(Trim(YourField)) As LengthOfYourFieldTimmed FROM YourTable

ridders, thanks! I was not aware of that fact. Like I said, I'm searching for the quickest solution. arnelgp, I cannot create a autonumber ID field because I'm dealing with over 2 million records at a time. When I attempt to add autonumber field to the table I receive error message "file...

ridders, thanks. I'm looking for the quickest fix to clean up my data for reports. I'm dealing with over 3 million records at a time, VBA has been good for me in the past

"Tbl-1" has been replaced with Tbl1 in the code, that was a typing error that has been corrected. When I read the posting for this code https://www.databasejournal.com/features/msaccess/article.php/3077791/Delete-Duplicate-Records-From-Access-Tables.htm it appeared that I could insert my table...

I created a general module named DeleteDuplicateRecords. Tbl1 contains my duplicate records (it's a copy of the original table). The field to be evaluated is labeled license. I copied the code (listed below) that was initial posted by Danny Lesandrini. Sub DeleteDuplicateRecords(Tbl1 As...

NauticalGent (06-07-2017, 04:00 AM, Re: delete query, delete duplicates but keep one) I reviewed the article you posted (Posted Sep 19, 2003 Delete Duplicate Records From Access Tables - Alternate more flexible solution By Danny Lesandrini) and I have Q's. I'm new to Modules. I created a...

NauticalGent, results provided did not provide me with the desired result. The field size is set to 13 characters, and always returns the same number of records 323,992.

Markk - Your query produced results of "13" in all 323,992 fields.

Hello, I have a short text field called [license] in a table that is set to 13 characters; the total number of records in this table is 323,992. I wish to capture only data in [license] where the data in this field is equal to 13 characters. I have 5932 records where the value is listed as...

Arnelgp thank you for your assistance! With some perseverance and stubborn determination I was able to solve the problem. I’m going to share this with everyone because I’ve never encountered this type of second hand association before between forms. 1/1/2018 14:43 paraphrasing “Arnelgp...

Arnelgp - frm.Coach is a single form view, and the subfrm.coachassignment linked to frm.coach is datasheet view. One to many relationship. The frm.coach (single form view) displays the coach information name, address, certifications, etc. The frm.coachassignment (datasheet view) lists all the...

:banghead:I'm having issues opening the frm.coaches in single view format using the query we created. - Steve

Arnelgp thanks, the query is functioning. However new caveat; frm.Coach is a single form view, and the subfrm.coachassignment linked to frm.coach is datasheet view. A single coach may be employed by several sponsors at the same time. I would assume we modify the SQL query we just created to...

Arnelgp thanks for your prompt reply! I have created the query you suggested in SQL view as you suggested. Your last inquiry is accurate. For clarification purposes: Tbl.Sponsors has [MSF_RERP] doesn't have [MSF_Coach] both are long integer. Tbl.Coach has [MSF_Coach] doesn't have...

Does anyone have any suggestions how to solve this problem? :confused: