Search results for query: *

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

That was it! The "Dealer" form wasn't open. Is there any way to do this without the other form being open? Possibly basing the code on the table the "Dealer" form is bound to? Seeing as though this is a data entry form, I really don't want to have other forms open. I...

Thank you very much for the assistance. Your patience and persistence is greatly appreciated. Michael

Hey, I appreciate all of the assistance. However, I still don't have a solution. After trying all of the methods described in the above posts, I still get the error. It is Run Time Error 2450 - Microsoft Access can't find the form 'Dealer' referred to in a macro expression or visual basic...

All the option groups were created with the assistance of the wizard. I have several option buttons that this will apply to as well. They, of course, will be yes/no,true/false answers. I have created a query and retrieved the numerical values that far. It was at that point that I got lost...

I don't know about a couple of breaks, but you can force a page break in any section by selecting the header (or footer) and looking up the Force Page Break Property. From here you can choose to force the page break before or after the section. Hope this helps, Mike