Recent content by Gretchen

Thank you for coming out of your reclusiveness monkey and giving me my answer! :)

I am trying to go to a selected record in the database and e mail it to someone else. How do I do this? Thanks...

Yes (I think) that's what I'm saying. If Sonya Robinson is Auto 8233 in the Master Dbase, when I pull her up in the linked Law Dbase, the AutoID does not show anything or some odd number like 7129. Previously the Auto 8233 would show as 8233 in the AutoID as well. All the other records are...

Argghh this is going from bad to worse :( Settings are: Allow Edits = Yes Allow Deletions = Yes Allow Additions = Yes Data Entry = No Recordset Type = Dynaset Record Locks = No Locks Still getting same message when try to enter subform data for new individual. Can make any changes desired...

! Oh no! :( None of the above ideas worked. I did them all, in the order given. Still get same message! Help!!! Need more ideas!!

Thanks! I'll try those and let you know how it goes! Appreciate you taking the time to help!

I have a database that has been in use for about a month. There is a subform attached to a form and all has gone fine until now. Now when try to enter information in the subform, get the following message that I cannot figure out what's wrong. You Can't Assign a Value to This Object *The...

Post the dbase? What do you mean? Put the entire thing on here? It's huge! I could email it to you perhaps if you want to see it. (Gosh I hope I don't sound as stupid as I feel) :rolleyes:

Chewy, I read up on Dim statements but it doesn't explain to me what you were indicating with Dim dbNm As Database... running the module gives me an error as not defined... ??? My datbase name is MasterTest but it doesn't like that. I don't know what I'm doing here! *sigh* I need another...

ok! I can copy and paste that into VB ... so how do I get to vb? and does it attach to the command button? (ok ok ... so I know practically nothing here ... go detailed man! detailed!) :p I do appreciate the help .. truly I do!

I want to add a command button that will let the users look for a record by FirstName + Last Name at the same time. The name field is separated not all together. Also I want to lookk up the name as anything close. i.e. Sue, Susan, Susie, etc. Say I want to find Sue Smith. I want the command...

Thank you!! Thank you Mile-O-Phile and Neileg!!! A big hug to you Neileg for the exact wording! *hugs* You have made my user's day!!! (as well as mine) Thanks again !!!

Thanks so much to you both! I'll try these and if I get too lost, I'll post again *grin* :)

Here's my problem: I have OrgName field in a form. The subform on this form has the actual CtrName field. The CtrName field is only filled in if it is different from the OrgName. When pulling the query for labels, I need the query to pull the correct name (address/city/state/zip will be same...

Charity, thank you for your response and zip file. But I definately need your help in implementing this. I don't have any idea what to do with it now that I have unzipped it! Also, sorry it took so long to get back here. I've been so overwhelmed at work I've barely had time to breathe!! :(