Need Major Help

[Guest]

Hello,

I wanted to know if I can apply code that I wrote to a form to a query.
Basically the query has the same fields as the form.

And i wanted to know if I can automatically populate a column when the user
answers my question in a query.

Thanks.

 

[John Vinson]

Hello,

I wanted to know if I can apply code that I wrote to a form to a query.
Basically the query has the same fields as the form.

And i wanted to know if I can automatically populate a column when the user
answers my question in a query.

Thanks.

You'll have to give us a clearer explanation than that, I fear.

What's the code? Can you post it?

Forms don't HAVE fields, for one thing. Forms have Controls, which may
or may not be bound to fields. And I'm not clear what you mean by
"populate a column".

John W. Vinson[MVP]

 

[Guest]

For the first question. I am got stuck on trying to creat this form.
Becasue I have a main table callled Acct Rec Tracker which contains the
Account Numbers and the person who prepared the account. Then I created a
subdatasheet to display the months of the balance and unreconciled balances
called a Maintenance Table.

So I created a form that displayed the Account Numbers by the balances
monthly. Account Numbers as the form and monthly balances as the subform.

So the client wanted the opposite way. The Preparer to see by Months all
the account numbers he owns. So Months as the form and Account Numbers as
the subform. So when I did set it up, I linked the forms by preparer and
date, it give me what I wanted but, it repeats the same thing to the number
of accounts I have. So say if I see January and Lee and my account numbers,
the form will repeat the same information/records to the number of account
numbers I have.

Since my form doesnt work, I have written code in this form if the user
presses a button it will track, like an audit tracker but I can't use it
anymore if the form is not displayed correctly. That is why I wanted to know
if you can place the code in an query. Thanks.

 

[John Vinson]

For the first question. I am got stuck on trying to creat this form.
Becasue I have a main table callled Acct Rec Tracker which contains the
Account Numbers and the person who prepared the account. Then I created a
subdatasheet to display the months of the balance and unreconciled balances
called a Maintenance Table.

What are the primary Keys of each table? How are the two tables
related in the relationships window?

So I created a form that displayed the Account Numbers by the balances
monthly. Account Numbers as the form and monthly balances as the subform.

ok... is there a Table with one record for each month, or are these
monthly balances calculated?

So the client wanted the opposite way. The Preparer to see by Months all
the account numbers he owns. So Months as the form and Account Numbers as
the subform. So when I did set it up, I linked the forms by preparer and
date, it give me what I wanted but, it repeats the same thing to the number
of accounts I have. So say if I see January and Lee and my account numbers,
the form will repeat the same information/records to the number of account
numbers I have.

What are the Master and Child Link Fields of the Subform control, and
the Recordsources of the form and subform?

Since my form doesnt work, I have written code in this form if the user
presses a button it will track, like an audit tracker but I can't use it
anymore if the form is not displayed correctly. That is why I wanted to know
if you can place the code in an query. Thanks.

Sorry, but that still does NOT explain what you want the function to
DO in the Query. You can call a function in a vacant Field cell in a
Query to calculate a value for that field, but I don't think that's
what you mean.

John W. Vinson[MVP]

 

[MichiganMSAccessExperts]

You can contact Gene at www.customaccessllc.com for professional help.

 

[MichiganMSAccessExperts]

You can contact Gene at www.customaccessllc.com for professional help.

 

[Douglas J. Steele]

Please note that these newsgroups are intended for peer-to-peer help, not
for advertising.