Recent content by msaccesspatc

Paul and JLC, I like going for the 'simple' . The ado method is greatly appreciated to peruse and use in another situation.(makes me look smarter!!). You two are incredible for taking the time to share your knowledge. "the world IS our classroom" thanks again

THis question is under 'general' since I don't know enough to put it under macros, or vba or modules ,etc. In my ms application, I have a form and subforms representing 3 of our server environments.. Test, Accept and PRod. I bring up a test record, make changes or do an insert. Works...

Paul, I am SO HAPPY I needed: Me!subENVTest.Form.AllowEdits = False instead of: Me.subENVTest.AllowEdits = False There are So many variations,, I can't thank you enough , not sure I'd ever figure this out without the link you sent.

Paul,,, This helps IMMENSELY for the future too... Let me try applying this to my code. thanks

pbaldy, I'm getting a 'compile error : method or data member not found' when using your code suggestion both on a _change() event . I also tried _afterupdate() event with same erro. Can you see what is wrong? cboMode is a combo box with choices of : Readonly, edit, insert. This code is not...

Thanks CJ_London for your help. The combo boxes were NOT necessary in readonly. I used the table column values to fill-in the text box by finding the record searched on.. Now, the need is to allow a new record to be entered. I am asked to display all the available values from the table...

CJ London helped and I have a direction. I have 3 subforms showing records from 3 related tables (readonly). Now I want to change mode: I have a label called MODE and combo Box with read,Edit , Insert. On an insert the user wants several drop downs with all the choices that exist from the...

Hi CJ_London, I appreciate your quick reply and like the simple steps to be used on any upcoming project. I did steps 1 and 2 as you describe above and 3.4 will take time of course. But wanted to respond as quickly as possible... THANKS, you're very kind msaccesspatc

Don't understand your reply Too cynical for me to reply intelligently, But thanks for your time.

HELP, I'm trying to create my first MS Access 2007 project that provides the user the ability to update Linked sql server tables. I've created forms, subforms, linked tables, queries, but have nothing to give my project leader which is embarrassing. I have a basic knowledge of access but need a...

It's likely most anyone can help with this. I know very little but need to debug form/module. I have a form written by another person that converts a pipe '|' file to tab delimited. When i execute there's an error of 'Compile error: user-defined type not defined. It highlights the 3rd line...

It's likely most anyone can help with this. I know very little and need to debug this. I have a form written by another person that converts a pipe '|' file to tab delimited. When i execute there's an error of 'Compile error: user-defined type not defined. It highlights the 3rd line below show...