Recent content by mpmoore

Jgoodman, What do you mean by "the form current area" ? Dbaseguy, Thanks for the tip, but I am getting tired of trekking all of these formulas around. Mike

I have several calculations on my form. I am looking for a way to store the results of a calculation in the underlying table. If the calculation formula is in the Control Source property, where do I put the real control source. Or can I do this? Thanks for any input.

So, I have this security workgroup set up. Now I've decided my database has no need to be secure. How do I remove the security measures from my database altogether?

I am trying to sychronize with my replicas and I am getting the error, "Could not update, currently locked." I have closed all the databases, could there be a problem with security? Any ideas would be helpful.

That worked. Actually I created a new work group and joined it. Thanks for the help

Thanks for the help. Tried both of these to no avail. Any other suggestions?

Somehow, I have setup security features that I can't get around. My database doesn't recognize my password. Is there any way around these security measures?

DLookup is the way to go. Where would be your suggestion to put the DLookup function. This form is basically data entry, loading directly on a table with no query. Should I create a control that returns the value of this function? We are on the right track. Thanks for your help.

OK Bear with me here, this could get hairy. I have a form, TheBigForm. On TheBigForm I have a control box called DealerName. This control is tied to the table DealerList. In the table, DealerList, there is a field, DealerGroup. TheBigForm needs to know what the DealerGroup is for each...

It's me again. Today's dilema concerns looking up data in another table and then acting on it depending on what the information is. This will sound familiar to some as it is based on an earlier question. (thread702-81848) [DealerName] is a field in the Lease_Table. [Automotive] is a field in...

Joe, you have been so helpful. I hope to be able to return the favor to another user one day (after gaining much more knowledge) There are so many details to Access that books just can't cover. The willingness of professionals such as yourself is greatly appreciated. Thanks again, Michael Moore

Do I have to do a separate table for each option group? I have six option groups on the form and have set up a common table with the descriptions for all. Do I just join each field to the common table? I am really close and you have been most helpful. Mike

Okay, next problem, on the query. How do I bound the two tables? How do I set up the QBE? This is the first attempt at this type of query. Have done others whose relationships were easier to identify. Mike

Wanted to check back on this. Would it be possible to create a table that included all of the option groups and buttons and give them all unique numbers to return when selected into one table? Say a table called SourceCodes. Then I could base a query off that table and my LeaseTable (where...

Will try both ideas. Thanks for the tips. (-: