A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Need Form and TextBox Help



 
 
Thread Tools Display Modes
  #11  
Old September 7th, 2006, 12:24 PM posted to microsoft.public.access.forms
[email protected]
external usenet poster
 
Posts: 35
Default Need Form and TextBox Help

Klatuu,

I am in need of advice on this one...In the ResumeDates table I was
thinking of laying it out this way; having the PK be an auto-number,
StoreNumber, Date, ResumeCount as my columns
Each time a new resume is sent out the storenumber gets repeated with a
new date and new resumecount number. If I do it this way, I would be
adding in new records.
HR wants to be able to see how many resumes were sent out and when per
store. Is there another/better way to do this and be able to update? I
cannot think of a way without making everything more cumbersome...
Then I have to think about the query I would run for the reporting
side....


H
wrote:
Klatuu,

I will work on tonight...BTY where are you at/live?
Hans

Klatuu wrote:
Actually, if you are going to do this from the form, it would be easier and
faster to use an action query. I can show you some sample code, but I need to
know if you will be adding records to ResumeDates or updating existing
records. It is late, so I can't get to it until tomorrow.

" wrote:

Ok...maybe I can be on the same page with you...bear with me.
I may have mislead you earlier...The date and resume data would reside
in a different table(ResumesDates) and not with all the other
data(ISSOpenPosition). If I understand normalizations etc...this is why
I did it this way. So, the ISSOpenPosition would be done via recordset
processing, but not the ResumesDates, which is where I have my
problem...
Does this help??

Thanks,

H

Klatuu wrote:
No. Recordset processing is like the old traditional way to deal with data.
You open a recordset based on a table or query, then move throught it either
using or updating the data in the record or adding or deleting records
programmatically.

I May not be understanding you, but what I thought you originally said was
that you are updating a table that is not the table your form is based on.
If this is correct, how are you doing it?

" wrote:

Now I am going to REALLY show my ignorance of Access...What is
recordset processing?
I set up the Form thru the form wizard and selected the table that I
wanted, i.e. ISSOpenPosition...Is this recordset processing??


Klatuu wrote:
Good info, but what I was really after, is the method you are using to update
the other table, recordset processing? an action query?, or, perhaps based on
your most recent post, passing the info to another form.

What I am thinking is that you can include the value of the combo in
whatever you are using to pass the data.

" wrote:

Hey Klatuu...
The form HR-ISS Open Position is based on the TBLISSOpenPositionTable
All of the "other information" is set to that table by the control
source...is this what you are asking? Still real new here...

Take a step back and fill in some missing details....
The main table ISSOpenPosition controls the following combo & text
boxes on form HR-ISS Open Position either directly or the underlying
query and records the data in the ISSOpenPosition Table
StoreVacancies (CBO) (FK in table) - recorded in ISS table
Tracking Number (TXT) (PK in table) - recorded in ISS table
DMName (DLookup)
RMName (DLookup)
RSQ Hours (DLookup)
RecruitStart (TXT) ------- recorded in ISS table
RecruitEnd (TXT) ---------recorded in ISS table
BackgroundStart (TXT) -recorded in ISS table
BackgroundEnd (TXT) --recorded in ISS table
StartDate(TXT) - recorded in ISS table
(When I get ready to run the report later I can query all of these to
produce my report...)

What I cannot figure out what/how to do is this:
HR needs to know on any given store how many times they sent a resume
out and on what date...
So, I came up with another table TBLResumesSent with the following
columns
PK (auto), StoreNumber, Date, ResumesSent

I need the StoreVacancies(CBO) data to be "passed" over to the
ResumesSent table along with date and resumes sent.. "passed" over
meaning the user does not have to re-type or lookup the store number on
the same form. If I can get this accomplished then when I run my report
query I would include the TBLResumesSent to get all of my results.

Does any of this make sense to you? And is this the way I should do it?
My reason on an additional table is that the store number could be
duplicated SEVERAL times! I have one instance that has one over 25
times...and I could not put this in an existing table or can I???

Once again I thank you!

Hans








Klatuu wrote:
How are you updating the other table with the date and resume info?

" wrote:

I am new to the Access game and run across issues that I just do not
have a clue how to do...

On my form I have a Combo Box where the user selects a store number and

all the pertinent information in the textboxes fill in...this is for
viewing purposes only. I have 4 text boxes where the user will input
information for new data storage. This is running very smoothly. My
problem is this; I need to input into another table the store number
from the combo box along with the date selected and # of resumes sent
out. The date and resumes I can do, I just DO NOT know how to pass the
store number from one table thru the combo box into another table on
the fly...


Help is needed on this one!


Hans









  #12  
Old September 7th, 2006, 01:53 PM posted to microsoft.public.access.forms
Klatuu
external usenet poster
 
Posts: 7,074
Default Need Form and TextBox Help

I am in Fort Worth, Texas. Where are you?

I think what you are suggesting for laying out the ResumeDates table is a
pretty good idea. One question, however. If you send out multiple resumes
in one day, will the count field show the number sent for the day or will
there be one record for each resume sent? Also, I don't see any indication
you are keeping track of which resumes were sent on a particular day.

" wrote:

Klatuu,

I am in need of advice on this one...In the ResumeDates table I was
thinking of laying it out this way; having the PK be an auto-number,
StoreNumber, Date, ResumeCount as my columns
Each time a new resume is sent out the storenumber gets repeated with a
new date and new resumecount number. If I do it this way, I would be
adding in new records.
HR wants to be able to see how many resumes were sent out and when per
store. Is there another/better way to do this and be able to update? I
cannot think of a way without making everything more cumbersome...
Then I have to think about the query I would run for the reporting
side....


H
wrote:
Klatuu,

I will work on tonight...BTY where are you at/live?
Hans

Klatuu wrote:
Actually, if you are going to do this from the form, it would be easier and
faster to use an action query. I can show you some sample code, but I need to
know if you will be adding records to ResumeDates or updating existing
records. It is late, so I can't get to it until tomorrow.

" wrote:

Ok...maybe I can be on the same page with you...bear with me.
I may have mislead you earlier...The date and resume data would reside
in a different table(ResumesDates) and not with all the other
data(ISSOpenPosition). If I understand normalizations etc...this is why
I did it this way. So, the ISSOpenPosition would be done via recordset
processing, but not the ResumesDates, which is where I have my
problem...
Does this help??

Thanks,

H

Klatuu wrote:
No. Recordset processing is like the old traditional way to deal with data.
You open a recordset based on a table or query, then move throught it either
using or updating the data in the record or adding or deleting records
programmatically.

I May not be understanding you, but what I thought you originally said was
that you are updating a table that is not the table your form is based on.
If this is correct, how are you doing it?

" wrote:

Now I am going to REALLY show my ignorance of Access...What is
recordset processing?
I set up the Form thru the form wizard and selected the table that I
wanted, i.e. ISSOpenPosition...Is this recordset processing??


Klatuu wrote:
Good info, but what I was really after, is the method you are using to update
the other table, recordset processing? an action query?, or, perhaps based on
your most recent post, passing the info to another form.

What I am thinking is that you can include the value of the combo in
whatever you are using to pass the data.

" wrote:

Hey Klatuu...
The form HR-ISS Open Position is based on the TBLISSOpenPositionTable
All of the "other information" is set to that table by the control
source...is this what you are asking? Still real new here...

Take a step back and fill in some missing details....
The main table ISSOpenPosition controls the following combo & text
boxes on form HR-ISS Open Position either directly or the underlying
query and records the data in the ISSOpenPosition Table
StoreVacancies (CBO) (FK in table) - recorded in ISS table
Tracking Number (TXT) (PK in table) - recorded in ISS table
DMName (DLookup)
RMName (DLookup)
RSQ Hours (DLookup)
RecruitStart (TXT) ------- recorded in ISS table
RecruitEnd (TXT) ---------recorded in ISS table
BackgroundStart (TXT) -recorded in ISS table
BackgroundEnd (TXT) --recorded in ISS table
StartDate(TXT) - recorded in ISS table
(When I get ready to run the report later I can query all of these to
produce my report...)

What I cannot figure out what/how to do is this:
HR needs to know on any given store how many times they sent a resume
out and on what date...
So, I came up with another table TBLResumesSent with the following
columns
PK (auto), StoreNumber, Date, ResumesSent

I need the StoreVacancies(CBO) data to be "passed" over to the
ResumesSent table along with date and resumes sent.. "passed" over
meaning the user does not have to re-type or lookup the store number on
the same form. If I can get this accomplished then when I run my report
query I would include the TBLResumesSent to get all of my results.

Does any of this make sense to you? And is this the way I should do it?
My reason on an additional table is that the store number could be
duplicated SEVERAL times! I have one instance that has one over 25
times...and I could not put this in an existing table or can I???

Once again I thank you!

Hans








Klatuu wrote:
How are you updating the other table with the date and resume info?

" wrote:

I am new to the Access game and run across issues that I just do not
have a clue how to do...

On my form I have a Combo Box where the user selects a store number and

all the pertinent information in the textboxes fill in...this is for
viewing purposes only. I have 4 text boxes where the user will input
information for new data storage. This is running very smoothly. My
problem is this; I need to input into another table the store number
from the combo box along with the date selected and # of resumes sent
out. The date and resumes I can do, I just DO NOT know how to pass the
store number from one table thru the combo box into another table on
the fly...


Help is needed on this one!


Hans










  #13  
Old September 7th, 2006, 04:58 PM posted to microsoft.public.access.forms
[email protected]
external usenet poster
 
Posts: 35
Default Need Form and TextBox Help

I am in Atlanta...
Good point...I asked the person who actually will be doing the work and
she said that she sends out at one time, so when the store is entered
in she would select the date and qty sent. If she send out more
tomorrow, she would enter that date and qty...
For your second question, (if I understand your question correctly,
remember newbie here) the "keeping track" would come from the report
query. Where it would list all the dates & qty's that resumes were sent
for that store, DM etc....


Hans

Klatuu wrote:
I am in Fort Worth, Texas. Where are you?

I think what you are suggesting for laying out the ResumeDates table is a
pretty good idea. One question, however. If you send out multiple resumes
in one day, will the count field show the number sent for the day or will
there be one record for each resume sent? Also, I don't see any indication
you are keeping track of which resumes were sent on a particular day.

" wrote:

Klatuu,

I am in need of advice on this one...In the ResumeDates table I was
thinking of laying it out this way; having the PK be an auto-number,
StoreNumber, Date, ResumeCount as my columns
Each time a new resume is sent out the storenumber gets repeated with a
new date and new resumecount number. If I do it this way, I would be
adding in new records.
HR wants to be able to see how many resumes were sent out and when per
store. Is there another/better way to do this and be able to update? I
cannot think of a way without making everything more cumbersome...
Then I have to think about the query I would run for the reporting
side....


H
wrote:
Klatuu,

I will work on tonight...BTY where are you at/live?
Hans

Klatuu wrote:
Actually, if you are going to do this from the form, it would be easier and
faster to use an action query. I can show you some sample code, but I need to
know if you will be adding records to ResumeDates or updating existing
records. It is late, so I can't get to it until tomorrow.

" wrote:

Ok...maybe I can be on the same page with you...bear with me.
I may have mislead you earlier...The date and resume data would reside
in a different table(ResumesDates) and not with all the other
data(ISSOpenPosition). If I understand normalizations etc...this is why
I did it this way. So, the ISSOpenPosition would be done via recordset
processing, but not the ResumesDates, which is where I have my
problem...
Does this help??

Thanks,

H

Klatuu wrote:
No. Recordset processing is like the old traditional way to deal with data.
You open a recordset based on a table or query, then move throught it either
using or updating the data in the record or adding or deleting records
programmatically.

I May not be understanding you, but what I thought you originally said was
that you are updating a table that is not the table your form is based on.
If this is correct, how are you doing it?

" wrote:

Now I am going to REALLY show my ignorance of Access...What is
recordset processing?
I set up the Form thru the form wizard and selected the table that I
wanted, i.e. ISSOpenPosition...Is this recordset processing??


Klatuu wrote:
Good info, but what I was really after, is the method you are using to update
the other table, recordset processing? an action query?, or, perhaps based on
your most recent post, passing the info to another form.

What I am thinking is that you can include the value of the combo in
whatever you are using to pass the data.

" wrote:

Hey Klatuu...
The form HR-ISS Open Position is based on the TBLISSOpenPositionTable
All of the "other information" is set to that table by the control
source...is this what you are asking? Still real new here...

Take a step back and fill in some missing details....
The main table ISSOpenPosition controls the following combo & text
boxes on form HR-ISS Open Position either directly or the underlying
query and records the data in the ISSOpenPosition Table
StoreVacancies (CBO) (FK in table) - recorded in ISS table
Tracking Number (TXT) (PK in table) - recorded in ISS table
DMName (DLookup)
RMName (DLookup)
RSQ Hours (DLookup)
RecruitStart (TXT) ------- recorded in ISS table
RecruitEnd (TXT) ---------recorded in ISS table
BackgroundStart (TXT) -recorded in ISS table
BackgroundEnd (TXT) --recorded in ISS table
StartDate(TXT) - recorded in ISS table
(When I get ready to run the report later I can query all of these to
produce my report...)

What I cannot figure out what/how to do is this:
HR needs to know on any given store how many times they sent a resume
out and on what date...
So, I came up with another table TBLResumesSent with the following
columns
PK (auto), StoreNumber, Date, ResumesSent

I need the StoreVacancies(CBO) data to be "passed" over to the
ResumesSent table along with date and resumes sent.. "passed" over
meaning the user does not have to re-type or lookup the store number on
the same form. If I can get this accomplished then when I run my report
query I would include the TBLResumesSent to get all of my results.

Does any of this make sense to you? And is this the way I should do it?
My reason on an additional table is that the store number could be
duplicated SEVERAL times! I have one instance that has one over 25
times...and I could not put this in an existing table or can I???

Once again I thank you!

Hans








Klatuu wrote:
How are you updating the other table with the date and resume info?

" wrote:

I am new to the Access game and run across issues that I just do not
have a clue how to do...

On my form I have a Combo Box where the user selects a store number and

all the pertinent information in the textboxes fill in...this is for
viewing purposes only. I have 4 text boxes where the user will input
information for new data storage. This is running very smoothly. My
problem is this; I need to input into another table the store number
from the combo box along with the date selected and # of resumes sent
out. The date and resumes I can do, I just DO NOT know how to pass the
store number from one table thru the combo box into another table on
the fly...


Help is needed on this one!


Hans











  #14  
Old September 7th, 2006, 05:10 PM posted to microsoft.public.access.forms
Klatuu
external usenet poster
 
Posts: 7,074
Default Need Form and TextBox Help

Okay, so if I understand correctly, if 3 resumes were sent out today the
ResumeCount field in record for today's date would have a value of 3. Let me
know if that is correct and I can send some example code that will help you
get what you want.

" wrote:

I am in Atlanta...
Good point...I asked the person who actually will be doing the work and
she said that she sends out at one time, so when the store is entered
in she would select the date and qty sent. If she send out more
tomorrow, she would enter that date and qty...
For your second question, (if I understand your question correctly,
remember newbie here) the "keeping track" would come from the report
query. Where it would list all the dates & qty's that resumes were sent
for that store, DM etc....


Hans

Klatuu wrote:
I am in Fort Worth, Texas. Where are you?

I think what you are suggesting for laying out the ResumeDates table is a
pretty good idea. One question, however. If you send out multiple resumes
in one day, will the count field show the number sent for the day or will
there be one record for each resume sent? Also, I don't see any indication
you are keeping track of which resumes were sent on a particular day.

" wrote:

Klatuu,

I am in need of advice on this one...In the ResumeDates table I was
thinking of laying it out this way; having the PK be an auto-number,
StoreNumber, Date, ResumeCount as my columns
Each time a new resume is sent out the storenumber gets repeated with a
new date and new resumecount number. If I do it this way, I would be
adding in new records.
HR wants to be able to see how many resumes were sent out and when per
store. Is there another/better way to do this and be able to update? I
cannot think of a way without making everything more cumbersome...
Then I have to think about the query I would run for the reporting
side....


H
wrote:
Klatuu,

I will work on tonight...BTY where are you at/live?
Hans

Klatuu wrote:
Actually, if you are going to do this from the form, it would be easier and
faster to use an action query. I can show you some sample code, but I need to
know if you will be adding records to ResumeDates or updating existing
records. It is late, so I can't get to it until tomorrow.

" wrote:

Ok...maybe I can be on the same page with you...bear with me.
I may have mislead you earlier...The date and resume data would reside
in a different table(ResumesDates) and not with all the other
data(ISSOpenPosition). If I understand normalizations etc...this is why
I did it this way. So, the ISSOpenPosition would be done via recordset
processing, but not the ResumesDates, which is where I have my
problem...
Does this help??

Thanks,

H

Klatuu wrote:
No. Recordset processing is like the old traditional way to deal with data.
You open a recordset based on a table or query, then move throught it either
using or updating the data in the record or adding or deleting records
programmatically.

I May not be understanding you, but what I thought you originally said was
that you are updating a table that is not the table your form is based on.
If this is correct, how are you doing it?

" wrote:

Now I am going to REALLY show my ignorance of Access...What is
recordset processing?
I set up the Form thru the form wizard and selected the table that I
wanted, i.e. ISSOpenPosition...Is this recordset processing??


Klatuu wrote:
Good info, but what I was really after, is the method you are using to update
the other table, recordset processing? an action query?, or, perhaps based on
your most recent post, passing the info to another form.

What I am thinking is that you can include the value of the combo in
whatever you are using to pass the data.

" wrote:

Hey Klatuu...
The form HR-ISS Open Position is based on the TBLISSOpenPositionTable
All of the "other information" is set to that table by the control
source...is this what you are asking? Still real new here...

Take a step back and fill in some missing details....
The main table ISSOpenPosition controls the following combo & text
boxes on form HR-ISS Open Position either directly or the underlying
query and records the data in the ISSOpenPosition Table
StoreVacancies (CBO) (FK in table) - recorded in ISS table
Tracking Number (TXT) (PK in table) - recorded in ISS table
DMName (DLookup)
RMName (DLookup)
RSQ Hours (DLookup)
RecruitStart (TXT) ------- recorded in ISS table
RecruitEnd (TXT) ---------recorded in ISS table
BackgroundStart (TXT) -recorded in ISS table
BackgroundEnd (TXT) --recorded in ISS table
StartDate(TXT) - recorded in ISS table
(When I get ready to run the report later I can query all of these to
produce my report...)

What I cannot figure out what/how to do is this:
HR needs to know on any given store how many times they sent a resume
out and on what date...
So, I came up with another table TBLResumesSent with the following
columns
PK (auto), StoreNumber, Date, ResumesSent

I need the StoreVacancies(CBO) data to be "passed" over to the
ResumesSent table along with date and resumes sent.. "passed" over
meaning the user does not have to re-type or lookup the store number on
the same form. If I can get this accomplished then when I run my report
query I would include the TBLResumesSent to get all of my results.

Does any of this make sense to you? And is this the way I should do it?
My reason on an additional table is that the store number could be
duplicated SEVERAL times! I have one instance that has one over 25
times...and I could not put this in an existing table or can I???

Once again I thank you!

Hans








Klatuu wrote:
How are you updating the other table with the date and resume info?

" wrote:

I am new to the Access game and run across issues that I just do not
have a clue how to do...

On my form I have a Combo Box where the user selects a store number and

all the pertinent information in the textboxes fill in...this is for
viewing purposes only. I have 4 text boxes where the user will input
information for new data storage. This is running very smoothly. My
problem is this; I need to input into another table the store number
from the combo box along with the date selected and # of resumes sent
out. The date and resumes I can do, I just DO NOT know how to pass the
store number from one table thru the combo box into another table on
the fly...


Help is needed on this one!


Hans












  #15  
Old September 7th, 2006, 05:32 PM posted to microsoft.public.access.forms
[email protected]
external usenet poster
 
Posts: 35
Default Need Form and TextBox Help

Klatuu,

That is correct and thanks

H

Klatuu wrote:
Okay, so if I understand correctly, if 3 resumes were sent out today the
ResumeCount field in record for today's date would have a value of 3. Let me
know if that is correct and I can send some example code that will help you
get what you want.

" wrote:

I am in Atlanta...
Good point...I asked the person who actually will be doing the work and
she said that she sends out at one time, so when the store is entered
in she would select the date and qty sent. If she send out more
tomorrow, she would enter that date and qty...
For your second question, (if I understand your question correctly,
remember newbie here) the "keeping track" would come from the report
query. Where it would list all the dates & qty's that resumes were sent
for that store, DM etc....


Hans

Klatuu wrote:
I am in Fort Worth, Texas. Where are you?

I think what you are suggesting for laying out the ResumeDates table is a
pretty good idea. One question, however. If you send out multiple resumes
in one day, will the count field show the number sent for the day or will
there be one record for each resume sent? Also, I don't see any indication
you are keeping track of which resumes were sent on a particular day.

" wrote:

Klatuu,

I am in need of advice on this one...In the ResumeDates table I was
thinking of laying it out this way; having the PK be an auto-number,
StoreNumber, Date, ResumeCount as my columns
Each time a new resume is sent out the storenumber gets repeated with a
new date and new resumecount number. If I do it this way, I would be
adding in new records.
HR wants to be able to see how many resumes were sent out and when per
store. Is there another/better way to do this and be able to update? I
cannot think of a way without making everything more cumbersome...
Then I have to think about the query I would run for the reporting
side....


H
wrote:
Klatuu,

I will work on tonight...BTY where are you at/live?
Hans

Klatuu wrote:
Actually, if you are going to do this from the form, it would be easier and
faster to use an action query. I can show you some sample code, but I need to
know if you will be adding records to ResumeDates or updating existing
records. It is late, so I can't get to it until tomorrow.

" wrote:

Ok...maybe I can be on the same page with you...bear with me.
I may have mislead you earlier...The date and resume data would reside
in a different table(ResumesDates) and not with all the other
data(ISSOpenPosition). If I understand normalizations etc...this is why
I did it this way. So, the ISSOpenPosition would be done via recordset
processing, but not the ResumesDates, which is where I have my
problem...
Does this help??

Thanks,

H

Klatuu wrote:
No. Recordset processing is like the old traditional way to deal with data.
You open a recordset based on a table or query, then move throught it either
using or updating the data in the record or adding or deleting records
programmatically.

I May not be understanding you, but what I thought you originally said was
that you are updating a table that is not the table your form is based on.
If this is correct, how are you doing it?

" wrote:

Now I am going to REALLY show my ignorance of Access...What is
recordset processing?
I set up the Form thru the form wizard and selected the table that I
wanted, i.e. ISSOpenPosition...Is this recordset processing??


Klatuu wrote:
Good info, but what I was really after, is the method you are using to update
the other table, recordset processing? an action query?, or, perhaps based on
your most recent post, passing the info to another form.

What I am thinking is that you can include the value of the combo in
whatever you are using to pass the data.

" wrote:

Hey Klatuu...
The form HR-ISS Open Position is based on the TBLISSOpenPositionTable
All of the "other information" is set to that table by the control
source...is this what you are asking? Still real new here...

Take a step back and fill in some missing details....
The main table ISSOpenPosition controls the following combo & text
boxes on form HR-ISS Open Position either directly or the underlying
query and records the data in the ISSOpenPosition Table
StoreVacancies (CBO) (FK in table) - recorded in ISS table
Tracking Number (TXT) (PK in table) - recorded in ISS table
DMName (DLookup)
RMName (DLookup)
RSQ Hours (DLookup)
RecruitStart (TXT) ------- recorded in ISS table
RecruitEnd (TXT) ---------recorded in ISS table
BackgroundStart (TXT) -recorded in ISS table
BackgroundEnd (TXT) --recorded in ISS table
StartDate(TXT) - recorded in ISS table
(When I get ready to run the report later I can query all of these to
produce my report...)

What I cannot figure out what/how to do is this:
HR needs to know on any given store how many times they sent a resume
out and on what date...
So, I came up with another table TBLResumesSent with the following
columns
PK (auto), StoreNumber, Date, ResumesSent

I need the StoreVacancies(CBO) data to be "passed" over to the
ResumesSent table along with date and resumes sent.. "passed" over
meaning the user does not have to re-type or lookup the store number on
the same form. If I can get this accomplished then when I run my report
query I would include the TBLResumesSent to get all of my results.

Does any of this make sense to you? And is this the way I should do it?
My reason on an additional table is that the store number could be
duplicated SEVERAL times! I have one instance that has one over 25
times...and I could not put this in an existing table or can I???

Once again I thank you!

Hans








Klatuu wrote:
How are you updating the other table with the date and resume info?

" wrote:

I am new to the Access game and run across issues that I just do not
have a clue how to do...

On my form I have a Combo Box where the user selects a store number and

all the pertinent information in the textboxes fill in...this is for
viewing purposes only. I have 4 text boxes where the user will input
information for new data storage. This is running very smoothly. My
problem is this; I need to input into another table the store number
from the combo box along with the date selected and # of resumes sent
out. The date and resumes I can do, I just DO NOT know how to pass the
store number from one table thru the combo box into another table on
the fly...


Help is needed on this one!


Hans













  #16  
Old September 8th, 2006, 06:58 PM posted to microsoft.public.access.forms
[email protected]
external usenet poster
 
Posts: 35
Default Need Form and TextBox Help

Klatuu,
Been under the weather last few days...finally tried based on your
point an action query and actually used an append query. But it did not
work the way I needed to...When I placed a text box for the resumes
sent and date to on the form and tried to link them back to
resumesdates table I get a #name error. Also, I noticed that I have to
run the append query update before I get any data and other host of
problems

On another note based on some of what you have told me earlier (Points
you made and gave me the idea) I have been able to get my report to run
correctly, pulling data from multiple sources and the forms etc...But
this last thing here has be befuddled.

Hans

wrote:
Klatuu,

That is correct and thanks

H

Klatuu wrote:
Okay, so if I understand correctly, if 3 resumes were sent out today the
ResumeCount field in record for today's date would have a value of 3. Let me
know if that is correct and I can send some example code that will help you
get what you want.

" wrote:

I am in Atlanta...
Good point...I asked the person who actually will be doing the work and
she said that she sends out at one time, so when the store is entered
in she would select the date and qty sent. If she send out more
tomorrow, she would enter that date and qty...
For your second question, (if I understand your question correctly,
remember newbie here) the "keeping track" would come from the report
query. Where it would list all the dates & qty's that resumes were sent
for that store, DM etc....


Hans

Klatuu wrote:
I am in Fort Worth, Texas. Where are you?

I think what you are suggesting for laying out the ResumeDates table is a
pretty good idea. One question, however. If you send out multiple resumes
in one day, will the count field show the number sent for the day or will
there be one record for each resume sent? Also, I don't see any indication
you are keeping track of which resumes were sent on a particular day.

" wrote:

Klatuu,

I am in need of advice on this one...In the ResumeDates table I was
thinking of laying it out this way; having the PK be an auto-number,
StoreNumber, Date, ResumeCount as my columns
Each time a new resume is sent out the storenumber gets repeated with a
new date and new resumecount number. If I do it this way, I would be
adding in new records.
HR wants to be able to see how many resumes were sent out and when per
store. Is there another/better way to do this and be able to update? I
cannot think of a way without making everything more cumbersome...
Then I have to think about the query I would run for the reporting
side....


H
wrote:
Klatuu,

I will work on tonight...BTY where are you at/live?
Hans

Klatuu wrote:
Actually, if you are going to do this from the form, it would be easier and
faster to use an action query. I can show you some sample code, but I need to
know if you will be adding records to ResumeDates or updating existing
records. It is late, so I can't get to it until tomorrow.

" wrote:

Ok...maybe I can be on the same page with you...bear with me.
I may have mislead you earlier...The date and resume data would reside
in a different table(ResumesDates) and not with all the other
data(ISSOpenPosition). If I understand normalizations etc...this is why
I did it this way. So, the ISSOpenPosition would be done via recordset
processing, but not the ResumesDates, which is where I have my
problem...
Does this help??

Thanks,

H

Klatuu wrote:
No. Recordset processing is like the old traditional way to deal with data.
You open a recordset based on a table or query, then move throught it either
using or updating the data in the record or adding or deleting records
programmatically.

I May not be understanding you, but what I thought you originally said was
that you are updating a table that is not the table your form is based on.
If this is correct, how are you doing it?

" wrote:

Now I am going to REALLY show my ignorance of Access...What is
recordset processing?
I set up the Form thru the form wizard and selected the table that I
wanted, i.e. ISSOpenPosition...Is this recordset processing??


Klatuu wrote:
Good info, but what I was really after, is the method you are using to update
the other table, recordset processing? an action query?, or, perhaps based on
your most recent post, passing the info to another form.

What I am thinking is that you can include the value of the combo in
whatever you are using to pass the data.

" wrote:

Hey Klatuu...
The form HR-ISS Open Position is based on the TBLISSOpenPositionTable
All of the "other information" is set to that table by the control
source...is this what you are asking? Still real new here...

Take a step back and fill in some missing details....
The main table ISSOpenPosition controls the following combo & text
boxes on form HR-ISS Open Position either directly or the underlying
query and records the data in the ISSOpenPosition Table
StoreVacancies (CBO) (FK in table) - recorded in ISS table
Tracking Number (TXT) (PK in table) - recorded in ISS table
DMName (DLookup)
RMName (DLookup)
RSQ Hours (DLookup)
RecruitStart (TXT) ------- recorded in ISS table
RecruitEnd (TXT) ---------recorded in ISS table
BackgroundStart (TXT) -recorded in ISS table
BackgroundEnd (TXT) --recorded in ISS table
StartDate(TXT) - recorded in ISS table
(When I get ready to run the report later I can query all of these to
produce my report...)

What I cannot figure out what/how to do is this:
HR needs to know on any given store how many times they sent a resume
out and on what date...
So, I came up with another table TBLResumesSent with the following
columns
PK (auto), StoreNumber, Date, ResumesSent

I need the StoreVacancies(CBO) data to be "passed" over to the
ResumesSent table along with date and resumes sent.. "passed" over
meaning the user does not have to re-type or lookup the store number on
the same form. If I can get this accomplished then when I run my report
query I would include the TBLResumesSent to get all of my results.

Does any of this make sense to you? And is this the way I should do it?
My reason on an additional table is that the store number could be
duplicated SEVERAL times! I have one instance that has one over 25
times...and I could not put this in an existing table or can I???

Once again I thank you!

Hans








Klatuu wrote:
How are you updating the other table with the date and resume info?

" wrote:

I am new to the Access game and run across issues that I just do not
have a clue how to do...

On my form I have a Combo Box where the user selects a store number and

all the pertinent information in the textboxes fill in...this is for
viewing purposes only. I have 4 text boxes where the user will input
information for new data storage. This is running very smoothly. My
problem is this; I need to input into another table the store number
from the combo box along with the date selected and # of resumes sent
out. The date and resumes I can do, I just DO NOT know how to pass the
store number from one table thru the combo box into another table on
the fly...


Help is needed on this one!


Hans













 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:50 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.