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  

Text Box populate



 
 
Thread Tools Display Modes
  #1  
Old November 10th, 2009, 04:54 PM posted to microsoft.public.access.forms
Helpdesk
external usenet poster
 
Posts: 2
Default Text Box populate

I would like to know how to get a text box to populate the field from the
previous text box. Example: I have a text box call Store ID so the first
record I put in a Store ID number and I would like the next record to
automatically populate with the information that is in the first Store ID
box.


  #2  
Old November 10th, 2009, 05:44 PM posted to microsoft.public.access.forms
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Text Box populate

If your field is named "StoreID", the implication is that this is a unique
(store) identifier.

We're not familiar enough with your situation (until you tell us more) to
know why you'd want to have more than one record with the same StoreID in
it. A bit of context can help us offer more relevant suggestions.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Helpdesk" wrote in message
...
I would like to know how to get a text box to populate the field from the
previous text box. Example: I have a text box call Store ID so the first
record I put in a Store ID number and I would like the next record to
automatically populate with the information that is in the first Store ID
box.



  #3  
Old November 10th, 2009, 05:54 PM posted to microsoft.public.access.forms
Helpdesk
external usenet poster
 
Posts: 2
Default Text Box populate

Here is the situation: This access program will be used to do inventory at a
store. I have 4 fields:
1. Store ID
2. Location ID
3. UPC Code
4. Quantity

so when a person starts the inventory they need to enter in a Store ID and a
Location ID (the store is broken down into locations). Then they scan the
item and type in the quantity. Instead of them having to constantly type in
the Store ID and Location ID, these fields should automatically populate but
have the ability to change the Location ID. Hopefully this helps in
explaining the situation better.



"Jeff Boyce" wrote in message
...
If your field is named "StoreID", the implication is that this is a unique
(store) identifier.

We're not familiar enough with your situation (until you tell us more) to
know why you'd want to have more than one record with the same StoreID in
it. A bit of context can help us offer more relevant suggestions.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Helpdesk" wrote in message
...
I would like to know how to get a text box to populate the field from the
previous text box. Example: I have a text box call Store ID so the first
record I put in a Store ID number and I would like the next record to
automatically populate with the information that is in the first Store ID
box.





  #4  
Old November 10th, 2009, 06:51 PM posted to microsoft.public.access.forms
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Text Box populate

I suspect your data structure would benefit from further normalization.
Based on how I understand your description, one store can have many
locations, and one location can have many UPC Codes (items). In a
well-normalized relational database, this would require three tables, not
one.

The first table would hold StoreID and any other fields related ONLY to the
store (e.g., address, etc.).

The second table would hold LocationID, and any other fields related ONLY to
the location (e.g., Location Short Name, Description, ...)

The third table would hold UPC Codes, and any other ...

But this is just a start! Your inventory record would consist of the fields
you described, plus probably an InventoryID field, and a date/time field to
record WHEN that store in that location had that many of that item.

And we're still not done. Rather than repeatedly storing the same StoreID
(by default or by data entry), you would benefit from using a
mainform/subform construction. The main form would have Store and Location
fields, while the subform would be based on that junction table. By setting
the subform to use the mainform's (i.e, the 'parent's) StoreID and
LocationID, you NEVER have to re-enter the StoreID or the LocationID for
multiple items (UPC Code) from the same Store/Location.

Each time you move to a new location (and/or store), enter those once in the
main form and let Access handle entering them into the appropriate subform
controls.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


"Helpdesk" wrote in message
...
Here is the situation: This access program will be used to do inventory at
a store. I have 4 fields:
1. Store ID
2. Location ID
3. UPC Code
4. Quantity

so when a person starts the inventory they need to enter in a Store ID and
a Location ID (the store is broken down into locations). Then they scan
the item and type in the quantity. Instead of them having to constantly
type in the Store ID and Location ID, these fields should automatically
populate but have the ability to change the Location ID. Hopefully this
helps in explaining the situation better.



"Jeff Boyce" wrote in message
...
If your field is named "StoreID", the implication is that this is a
unique (store) identifier.

We're not familiar enough with your situation (until you tell us more) to
know why you'd want to have more than one record with the same StoreID in
it. A bit of context can help us offer more relevant suggestions.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Helpdesk" wrote in message
...
I would like to know how to get a text box to populate the field from the
previous text box. Example: I have a text box call Store ID so the first
record I put in a Store ID number and I would like the next record to
automatically populate with the information that is in the first Store ID
box.







 




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 09:48 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.