V
Vylent Fyre
Hello, everyone! I want to thank you all for your continuing support and
sharing your knowledge with people like me.
I am trying to do something so simple but I am not able to achieve the goal
I’m looking for. I went through the message boards and, as usual, there’s
been more than one way to handle it given out but none of them worked. They
were all EXCELLENT! It worked great for everyone else so I’m sure it’s
something I’m doing, or rather, something I'm not doing. Please forgive me
if there are other older posts out there that does explain this; I tried
multiple different search queries and went through all the ones that was
found that seemed to fit my current dilemma to no avail.
First – What I am doing / trying to do – I have the main form,
frm_Divisional One Off JE’s that has a subform, sfrm_One Off JE’s.
(Explanation of the forms and tables)
When you first open the main form frm_Divisional One Off JE, it takes you to
the first field within the frm_Divisional One Off JE’s. You type in the
information for Division and Period. When you tab, it takes you to the
subform, where you enter in the hard core data, so to speak. After they’re
done entering in here in the subform, which could be ten lines, they are
ready to upload it into our system. They click on this button which is a
macro that will export this information into an excel file for them. This is
the hard core data. They can view it in the Excel file to ensure accuracy.
All they have to do from there is pull it from inside the system.
Once they’ve done that, the system provides them with JE # and Batch #.
They come back to the form, to the main form, frm_Divisional One Off JE’s,
and they enter in that information. There are two fields for them,
specifically called JE # and Batch #. Then, they’re ready to print out the
“pretty†JE (Journal Entry). They click on a button, and it previews for
them to view to ensure it’s accurate (this is their second check). They
print, close the preview.
Everything works great. Only problem I have is getting the JE # that’s
entered into the Main Form, frm_Divisional One Off JE’s (which is fed into
the table tbl_One Off JE’s Header) to also update the sfrm_One Off JE’s table
which is tbl, tbl_One Off JE’s.
I’ve tried linking them via child and master fields, and relationship links
but it isn’t working.
My ultimate goal is this – This form will have multiple users who may open
this form and enter in data. I want it to be able to only show them the
information they entered in to the form, not what someone else may be
entering as well on the upload and printed out report. I was thinking the
best way to handle it is to have the JE #, which is the unique identifier,
that the user enters into the Main Form to populate both tables, and have the
query that feeds the reports to link them. I am not sure if this is the best
way to handle this because the subform table, tbl_One Off JE’s, will have ten
lines versus the tbl_One Off Header, which will only have one line with the
JE # and Batch #.
I am almost 100% sure this is possible, but how to obtain this is my issue.
Any suggestion, as always, is greatly appreciated! =)
sharing your knowledge with people like me.
I am trying to do something so simple but I am not able to achieve the goal
I’m looking for. I went through the message boards and, as usual, there’s
been more than one way to handle it given out but none of them worked. They
were all EXCELLENT! It worked great for everyone else so I’m sure it’s
something I’m doing, or rather, something I'm not doing. Please forgive me
if there are other older posts out there that does explain this; I tried
multiple different search queries and went through all the ones that was
found that seemed to fit my current dilemma to no avail.
First – What I am doing / trying to do – I have the main form,
frm_Divisional One Off JE’s that has a subform, sfrm_One Off JE’s.
(Explanation of the forms and tables)
When you first open the main form frm_Divisional One Off JE, it takes you to
the first field within the frm_Divisional One Off JE’s. You type in the
information for Division and Period. When you tab, it takes you to the
subform, where you enter in the hard core data, so to speak. After they’re
done entering in here in the subform, which could be ten lines, they are
ready to upload it into our system. They click on this button which is a
macro that will export this information into an excel file for them. This is
the hard core data. They can view it in the Excel file to ensure accuracy.
All they have to do from there is pull it from inside the system.
Once they’ve done that, the system provides them with JE # and Batch #.
They come back to the form, to the main form, frm_Divisional One Off JE’s,
and they enter in that information. There are two fields for them,
specifically called JE # and Batch #. Then, they’re ready to print out the
“pretty†JE (Journal Entry). They click on a button, and it previews for
them to view to ensure it’s accurate (this is their second check). They
print, close the preview.
Everything works great. Only problem I have is getting the JE # that’s
entered into the Main Form, frm_Divisional One Off JE’s (which is fed into
the table tbl_One Off JE’s Header) to also update the sfrm_One Off JE’s table
which is tbl, tbl_One Off JE’s.
I’ve tried linking them via child and master fields, and relationship links
but it isn’t working.
My ultimate goal is this – This form will have multiple users who may open
this form and enter in data. I want it to be able to only show them the
information they entered in to the form, not what someone else may be
entering as well on the upload and printed out report. I was thinking the
best way to handle it is to have the JE #, which is the unique identifier,
that the user enters into the Main Form to populate both tables, and have the
query that feeds the reports to link them. I am not sure if this is the best
way to handle this because the subform table, tbl_One Off JE’s, will have ten
lines versus the tbl_One Off Header, which will only have one line with the
JE # and Batch #.
I am almost 100% sure this is possible, but how to obtain this is my issue.
Any suggestion, as always, is greatly appreciated! =)