Search results

Thanks for your input. This is a relatively minor project, not worth audit trails, etc. I can handle the VBA code.

I have a current table and also have saved copies from previous dates. I want to compare records in two tables (older and current) and display just those records that have been changed. I have created 2 queries: 1) the first selects all records and fields in the older table; 2) the 2nd...

Sorry, but no, this didn't work. I'm not sure it should. You added the line to the Notes_Enter event sub. I believe (but am not sure) that this code runs AFTER the field has been entered, at which point the selection has already been made. FWIW, in playing around with this, I created 2 more...

Thanks for jumping in. This has gotten to be a long thread, but if you look at my very first post you'll see this: "The Client Setting for behavior on entering field is go to start of field. That should eliminate my problem, but it doesn't." And in message #16 I said "The Client settings are to...

Ain't THAT the truth !!! :mad::mad: You probably noticed that I have code in the Enter event, not only for this text box but for several others, which sets the selection start to 0 and length to 0. Access only started misbehaving for this one text box after I moved it from the main form to the...

In a way, I'm glad it doesn't work right for you, either. Reassures me that I'm not losing my mind. Thanks for the suggestion about another form. I'll have a look at that.

I see 4 people have looked at the mdb file. No comments or suggestions or solutions?

Here's an mdb file which has just the 3 needed tables and the data entry query. The main table is named HS. It has just 1 dummy record. The form Data Entry runs when you open the file. When I use the Tab key to move from the last control on the Medical Data page of the Tab Control to to the...

I'll give it a try. Thanks for the additional info. As you can probably tell, Access is not my thing -- something I dabble with for a 92 year-old friend, for this one research project.

It's great to learn there are still some old cronies around! :):):) So where are the MS forums these days? No longer newsgroups, I think. How do you get to them? Via the MS Office web site?

Thanks for that tip. Excel VBA has the same problem with corruption. In fact Rob Bovey, one of the other Excel MVPs. wrote a utility to write all modules to disk, delete the code, save the XL file, then reimport the code. I assumed Access had the same problem, but didn't know of the /decompile...

I'm not sure I want to take the time. It's medical information. I could, of course, update the names to something else (and the addresses, and the phone numbers, and the dates of birth, etc, etc). Unfortunately there are also names (of relatives) and comments about who the person's parents...

They are VBA code. Where I come from, Excel, the term for VBA procedures is still macros. I forget that Access has macros, which are different from VBA procedures. Sorry.

Yes, that was just something I tried in desperation. It didn't make any difference. Modifying the code to what follows (the LostFocus procedure just sets focus to the text box on the next page) still results in the entire text being selected, i.e. the instructions in the Notes_Enter procedure...

Several years ago I designed a form for entering data in an Access 2003 database. It has event code and many VBA macro functions which work fine. (I was an Excel MVP years ago, one of the top posters in the VBA programming section, so VBA is not a problem for me.) I am now updating this mdb...

I am quite proficient with Excel and VBA programming, less so with Access. I've posted another thread about a problem I'm having with selecting/not selecting text on entering a memo field.