Search results

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!! :(

We've simply been using the Access Find Form. But since this is becoming a hassle, would like to do a custom one it seems. However, have no clue how to do that! Can you explain please?

I have 3 fields, FirstName, MI, LastName. Is it possible to do a find for i.e. Rose Smith and not just Rose or Smith - and then than to scroll through 35 Rose's or 60 Smith's to find Rose Smith specifically? Thanks so very much for your help !!

I have a columnar report that is based on a simple query for name, address, title, etc. Right now, the report is sorting by last name ( I didn't ask it to, it just happened). The powers that be have decided that it's important to have the list sorted by title with each title having a weight...

arggghhhhhhhh! All went well until I went to the main form and there was no 'On Current' event! Switching to email Houston!! (or Raleigh in this case)

ok, got that to work! now the two forms (main and sub) appear; but the data in the subform still doesn't come up with the corresponding main form name. What am I doing wrong?? (grrr smetimes hate being self taught .. am sure I missed something important along the way here)