Have date automatically go into another form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hellllllllllllllllllllllllp!! Okay I literally know nothing about
programming or access - but I did manage to create tables and forms.
My question is this: I have two forms one form is an application for a
discount card that the company I work for sells - the second form is the
invoice receipt - so basically is has most of the same information as the
first form
Can I get the information such as name address etc to automatically show up
on the invoice receipt form from the application form??
I have created a little button in the application form that brings me to the
invoice receipt form - do I have to do something there??
Where?? As you all can see I dont even use the proper terminology - but I
think I have managed to state my problem as plainly as possible.

Any help or advice would be appreciated - and as plain English as possible!

Thanks
 
Hi Bianca

If as you say most of the information is on both forms and assuming that
there is a linking field you could simply have the invoice receipt form as a
subform of the application form using the linking field as child master.
This would mean that you would autofill the fields.

Or - assuming again there is a linking field the button you have created
could be used to minimize the application form (but it would still be open)
then use a setvalue OnOpen of the Invoice reciept to autofill the fields.
 
Thank you Wayne,

both your suggestions sound good .... I think I like your second suggestion
better - can you tell me though (as I said I am totally new to this) ....how
to do this? I know I am asking a lot but I would really appreciate the help

B
 
Behind your new button add this to the OnClick event

Private Sub ButtonNname_Click()
On Error GoTo Err_ ButtonNname _Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "InvoiceReciept"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_ ButtonNname _Click:
Exit Sub
Err_ ButtonNname _Click:
MsgBox Err.Description
Resume Exit_ ButtonNname _Click
End Sub

Save the form and close.

Next you need to set the either control source of the fields in the invoice
receipt form to the data entered in to the application form such as
=forms![ApplicationForm]![SomeField]

Or simply (much easier) why not create a query with both tables in and
ensure that all the fields are in the grid. Then you would be able to select
the content of the second form filtered by the content of the 1st. Hope that
makes sense.

If you were to use a joint query then your button action would look
something like this

Private Sub ButtonName_Click()
On Error GoTo Err_ ButtonName _Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "InvoiceReciept"
stLinkCriteria = "[ApplicationID]=" & Me![ApplicationID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_ ButtonName _Click:
Exit Sub
Err_ ButtonName _Click:
MsgBox Err.Description
Resume Exit_ ButtonName _Click
End Sub
 
Hi,

My question is pretty much same...but the diffrence is that its only been 2
days since i swtched from excel to access and i have zero knowledge of access.

i actually followed your advice and made two table...however what i really
wanna do is something like...

first table i have assigned each customer a number like 1 for jhon, 2 for
wendy 3 david.

and in the other table with advices / receipts the details are pretty much
same...its just that i would actually want to use the identifying number and
automatically pick all that data from first table and copy it directly to the
approprite feilds as mentioned in the 2nd form...

any help would be appreciated...i am using acccess 2003 and been browsing
wevsite after websites trying to get the answer.

rgds



Wayne-I-M said:
Behind your new button add this to the OnClick event

Private Sub ButtonNname_Click()
On Error GoTo Err_ ButtonNname _Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "InvoiceReciept"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_ ButtonNname _Click:
Exit Sub
Err_ ButtonNname _Click:
MsgBox Err.Description
Resume Exit_ ButtonNname _Click
End Sub

Save the form and close.

Next you need to set the either control source of the fields in the invoice
receipt form to the data entered in to the application form such as
=forms![ApplicationForm]![SomeField]

Or simply (much easier) why not create a query with both tables in and
ensure that all the fields are in the grid. Then you would be able to select
the content of the second form filtered by the content of the 1st. Hope that
makes sense.

If you were to use a joint query then your button action would look
something like this

Private Sub ButtonName_Click()
On Error GoTo Err_ ButtonName _Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "InvoiceReciept"
stLinkCriteria = "[ApplicationID]=" & Me![ApplicationID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_ ButtonName _Click:
Exit Sub
Err_ ButtonName _Click:
MsgBox Err.Description
Resume Exit_ ButtonName _Click
End Sub

--
Wayne
Manchester, England.
Enjoy whatever it is you do


Bianca said:
Thank you Wayne,

both your suggestions sound good .... I think I like your second suggestion
better - can you tell me though (as I said I am totally new to this) ....how
to do this? I know I am asking a lot but I would really appreciate the help

B
Click to expand...
Click to expand...
 
you've started a new thread, so for those of us who haven't read your
previous thread, this is kind of like turning on the TV in the middle of a
show - we don't know what the previous "advice" was, or any of the
information you posted before.

however...
its just that i would actually want to use the identifying number and
automatically pick all that data from first table and copy it directly to the
approprite feilds as mentioned in the 2nd form...
Click to expand...

you absolutely do NOT want to copy data from one table to another. use the
primary key (customer number) to *link* a specific customer to a record in
the other table - that's all you need, in order to make the customer data
for each record available in queries, forms, and reports. copying that data
into the second table is a violation of normalization rules.

Access and Excel are *very* different; they store and manipulate data very
differently; and your Excel skills mostly do NOT transfer to Access. you'll
have to learn to play a whole new ballgame. i strongly recommend that you
start by closing Access, and reading up on relational design principles; if
you don't do it now, you'll be doing it later - and kicking yourself because
you didn't do it now, and wasted a whole lot of time and effort doing things
wrong and trying to fix them. for more information, see
http://home.att.net/~california.db/tips.html.

hth


mika said:
Hi,

My question is pretty much same...but the diffrence is that its only been 2
days since i swtched from excel to access and i have zero knowledge of access.

i actually followed your advice and made two table...however what i really
wanna do is something like...

first table i have assigned each customer a number like 1 for jhon, 2 for
wendy 3 david.

and in the other table with advices / receipts the details are pretty much
same...its just that i would actually want to use the identifying number and
automatically pick all that data from first table and copy it directly to the
approprite feilds as mentioned in the 2nd form...

any help would be appreciated...i am using acccess 2003 and been browsing
wevsite after websites trying to get the answer.

rgds



Wayne-I-M said:
Behind your new button add this to the OnClick event

Private Sub ButtonNname_Click()
On Error GoTo Err_ ButtonNname _Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "InvoiceReciept"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_ ButtonNname _Click:
Exit Sub
Err_ ButtonNname _Click:
MsgBox Err.Description
Resume Exit_ ButtonNname _Click
End Sub

Save the form and close.

Next you need to set the either control source of the fields in the invoice
receipt form to the data entered in to the application form such as
=forms![ApplicationForm]![SomeField]

Or simply (much easier) why not create a query with both tables in and
ensure that all the fields are in the grid. Then you would be able to select
the content of the second form filtered by the content of the 1st. Hope that
makes sense.

If you were to use a joint query then your button action would look
something like this

Private Sub ButtonName_Click()
On Error GoTo Err_ ButtonName _Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "InvoiceReciept"
stLinkCriteria = "[ApplicationID]=" & Me![ApplicationID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_ ButtonName _Click:
Exit Sub
Err_ ButtonName _Click:
MsgBox Err.Description
Resume Exit_ ButtonName _Click
End Sub

--
Wayne
Manchester, England.
Enjoy whatever it is you do


Bianca said:
Thank you Wayne,

both your suggestions sound good .... I think I like your second suggestion
better - can you tell me though (as I said I am totally new to this) .....how
to do this? I know I am asking a lot but I would really appreciate the help

B

:

Hi Bianca

If as you say most of the information is on both forms and assuming that
there is a linking field you could simply have the invoice receipt form as a
subform of the application form using the linking field as child master.
This would mean that you would autofill the fields.

Or - assuming again there is a linking field the button you have created
could be used to minimize the application form (but it would still be open)
then use a setvalue OnOpen of the Invoice reciept to autofill the fields.


--
Wayne
Manchester, England.
Enjoy whatever it is you do


:

Hellllllllllllllllllllllllp!! Okay I literally know nothing about
programming or access - but I did manage to create tables and forms.
My question is this: I have two forms one form is an application for a
discount card that the company I work for sells - the second form is the
invoice receipt - so basically is has most of the same information as the
first form
Can I get the information such as name address etc to automatically show up
on the invoice receipt form from the application form??
I have created a little button in the application form that brings me to the
invoice receipt form - do I have to do something there??
Where?? As you all can see I dont even use the proper terminology - but I
think I have managed to state my problem as plainly as possible.

Any help or advice would be appreciated - and as plain English as possible!

Thanks
Click to expand...
Click to expand...
Click to expand...
 
thx tina

Can you also help me with one more thing

i have created a report from the table in which i have diffrent customers
and thier trasactions.

the report prints fine and everything is there i need need to get it
fitlered further.
i.e if for example i need to see the reports of the customer who have made a
purchase of $8,000.00 or above Only. can this report be shows from the same
the same table from which i am already making the first report?

please do reply.

rgds
Mika


tina said:
you've started a new thread, so for those of us who haven't read your
previous thread, this is kind of like turning on the TV in the middle of a
show - we don't know what the previous "advice" was, or any of the
information you posted before.

however...
its just that i would actually want to use the identifying number and
automatically pick all that data from first table and copy it directly to the
approprite feilds as mentioned in the 2nd form...
Click to expand...

you absolutely do NOT want to copy data from one table to another. use the
primary key (customer number) to *link* a specific customer to a record in
the other table - that's all you need, in order to make the customer data
for each record available in queries, forms, and reports. copying that data
into the second table is a violation of normalization rules.

Access and Excel are *very* different; they store and manipulate data very
differently; and your Excel skills mostly do NOT transfer to Access. you'll
have to learn to play a whole new ballgame. i strongly recommend that you
start by closing Access, and reading up on relational design principles; if
you don't do it now, you'll be doing it later - and kicking yourself because
you didn't do it now, and wasted a whole lot of time and effort doing things
wrong and trying to fix them. for more information, see
http://home.att.net/~california.db/tips.html.

hth


mika said:
Hi,

My question is pretty much same...but the diffrence is that its only been 2
days since i swtched from excel to access and i have zero knowledge of access.

i actually followed your advice and made two table...however what i really
wanna do is something like...

first table i have assigned each customer a number like 1 for jhon, 2 for
wendy 3 david.

and in the other table with advices / receipts the details are pretty much
same...its just that i would actually want to use the identifying number and
automatically pick all that data from first table and copy it directly to the
approprite feilds as mentioned in the 2nd form...

any help would be appreciated...i am using acccess 2003 and been browsing
wevsite after websites trying to get the answer.

rgds



Wayne-I-M said:
Behind your new button add this to the OnClick event

Private Sub ButtonNname_Click()
On Error GoTo Err_ ButtonNname _Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "InvoiceReciept"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_ ButtonNname _Click:
Exit Sub
Err_ ButtonNname _Click:
MsgBox Err.Description
Resume Exit_ ButtonNname _Click
End Sub

Save the form and close.

Next you need to set the either control source of the fields in the invoice
receipt form to the data entered in to the application form such as
=forms![ApplicationForm]![SomeField]

Or simply (much easier) why not create a query with both tables in and
ensure that all the fields are in the grid. Then you would be able to select
the content of the second form filtered by the content of the 1st. Hope that
makes sense.

If you were to use a joint query then your button action would look
something like this

Private Sub ButtonName_Click()
On Error GoTo Err_ ButtonName _Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "InvoiceReciept"
stLinkCriteria = "[ApplicationID]=" & Me![ApplicationID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_ ButtonName _Click:
Exit Sub
Err_ ButtonName _Click:
MsgBox Err.Description
Resume Exit_ ButtonName _Click
End Sub

--
Wayne
Manchester, England.
Enjoy whatever it is you do


:

Thank you Wayne,

both your suggestions sound good .... I think I like your second suggestion
better - can you tell me though (as I said I am totally new to this) .....how
to do this? I know I am asking a lot but I would really appreciate the help

B

:

Hi Bianca

If as you say most of the information is on both forms and assuming that
there is a linking field you could simply have the invoice receipt form as a
subform of the application form using the linking field as child master.
This would mean that you would autofill the fields.

Or - assuming again there is a linking field the button you have created
could be used to minimize the application form (but it would still be open)
then use a setvalue OnOpen of the Invoice reciept to autofill the fields.


--
Wayne
Manchester, England.
Enjoy whatever it is you do


:

Hellllllllllllllllllllllllp!! Okay I literally know nothing about
programming or access - but I did manage to create tables and forms.
My question is this: I have two forms one form is an application for a
discount card that the company I work for sells - the second form is the
invoice receipt - so basically is has most of the same information as the
first form
Can I get the information such as name address etc to automatically show up
on the invoice receipt form from the application form??
I have created a little button in the application form that brings me to the
invoice receipt form - do I have to do something there??
Where?? As you all can see I dont even use the proper terminology - but I
think I have managed to state my problem as plainly as possible.

Any help or advice would be appreciated - and as plain English as possible!

Thanks
Click to expand...
Click to expand...
Click to expand...
 
ohh and forgot one more thing can you please also explain how i can change
the format of short date from mm/dd/yyyy to dd/mm/yyyy

thx

tina said:
you've started a new thread, so for those of us who haven't read your
previous thread, this is kind of like turning on the TV in the middle of a
show - we don't know what the previous "advice" was, or any of the
information you posted before.

however...
its just that i would actually want to use the identifying number and
automatically pick all that data from first table and copy it directly to the
approprite feilds as mentioned in the 2nd form...
Click to expand...

you absolutely do NOT want to copy data from one table to another. use the
primary key (customer number) to *link* a specific customer to a record in
the other table - that's all you need, in order to make the customer data
for each record available in queries, forms, and reports. copying that data
into the second table is a violation of normalization rules.

Access and Excel are *very* different; they store and manipulate data very
differently; and your Excel skills mostly do NOT transfer to Access. you'll
have to learn to play a whole new ballgame. i strongly recommend that you
start by closing Access, and reading up on relational design principles; if
you don't do it now, you'll be doing it later - and kicking yourself because
you didn't do it now, and wasted a whole lot of time and effort doing things
wrong and trying to fix them. for more information, see
http://home.att.net/~california.db/tips.html.

hth


mika said:
Hi,

My question is pretty much same...but the diffrence is that its only been 2
days since i swtched from excel to access and i have zero knowledge of access.

i actually followed your advice and made two table...however what i really
wanna do is something like...

first table i have assigned each customer a number like 1 for jhon, 2 for
wendy 3 david.

and in the other table with advices / receipts the details are pretty much
same...its just that i would actually want to use the identifying number and
automatically pick all that data from first table and copy it directly to the
approprite feilds as mentioned in the 2nd form...

any help would be appreciated...i am using acccess 2003 and been browsing
wevsite after websites trying to get the answer.

rgds



Wayne-I-M said:
Behind your new button add this to the OnClick event

Private Sub ButtonNname_Click()
On Error GoTo Err_ ButtonNname _Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "InvoiceReciept"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_ ButtonNname _Click:
Exit Sub
Err_ ButtonNname _Click:
MsgBox Err.Description
Resume Exit_ ButtonNname _Click
End Sub

Save the form and close.

Next you need to set the either control source of the fields in the invoice
receipt form to the data entered in to the application form such as
=forms![ApplicationForm]![SomeField]

Or simply (much easier) why not create a query with both tables in and
ensure that all the fields are in the grid. Then you would be able to select
the content of the second form filtered by the content of the 1st. Hope that
makes sense.

If you were to use a joint query then your button action would look
something like this

Private Sub ButtonName_Click()
On Error GoTo Err_ ButtonName _Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "InvoiceReciept"
stLinkCriteria = "[ApplicationID]=" & Me![ApplicationID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_ ButtonName _Click:
Exit Sub
Err_ ButtonName _Click:
MsgBox Err.Description
Resume Exit_ ButtonName _Click
End Sub

--
Wayne
Manchester, England.
Enjoy whatever it is you do


:

Thank you Wayne,

both your suggestions sound good .... I think I like your second suggestion
better - can you tell me though (as I said I am totally new to this) .....how
to do this? I know I am asking a lot but I would really appreciate the help

B

:

Hi Bianca

If as you say most of the information is on both forms and assuming that
there is a linking field you could simply have the invoice receipt form as a
subform of the application form using the linking field as child master.
This would mean that you would autofill the fields.

Or - assuming again there is a linking field the button you have created
could be used to minimize the application form (but it would still be open)
then use a setvalue OnOpen of the Invoice reciept to autofill the fields.


--
Wayne
Manchester, England.
Enjoy whatever it is you do


:

Hellllllllllllllllllllllllp!! Okay I literally know nothing about
programming or access - but I did manage to create tables and forms.
My question is this: I have two forms one form is an application for a
discount card that the company I work for sells - the second form is the
invoice receipt - so basically is has most of the same information as the
first form
Can I get the information such as name address etc to automatically show up
on the invoice receipt form from the application form??
I have created a little button in the application form that brings me to the
invoice receipt form - do I have to do something there??
Where?? As you all can see I dont even use the proper terminology - but I
think I have managed to state my problem as plainly as possible.

Any help or advice would be appreciated - and as plain English as possible!

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top