Juice13610
Thread Starter
- Joined
- Oct 26, 2004
- Messages
- 69
I have a few problems with an Access DB I created. I am pretty much a newbie at it, and an intern actually showed me how easy it is to use. I just have a couple of seemingly simple things that would be nice if they worked.
1. When typing in the "PO" field (it's the number assigned to the purchase requisition), I would like to be able to use it as a search field...so if I type "199039" in to the field and press enter, the contents of that record would show up. Instead here's what it does; Let's say I'm filling out the contents for PO #199000. I fill out all of the comment boxes and everything for 199000. Now, I go up to the PO field, type in 199039. Rather than opening that record, now it saves all of this information in po 199039. So anything previously entered for this record is now gone! I have a search button which has been working fine, but typing in a number in the PO field would be beautiful!
2. It is very simple to the point of being dumb....I'm not going to win any awards for this database, it's pretty crumby (wow, now I'm beating myself up
)...If we order a laptop, memory, and a laptop bag, you check the appropriate checkboxes; the one next to "Laptop?" the one next to "Memory?" and the one next to "Laptop bag?" The problem is, I couldn't figure out a QTY scroll-box (where you can click UP to increase the QTY, down to decrease) so it is just a text box. Is there some way to make the QTY box automatically change to "1" when the box is checked?
1. When typing in the "PO" field (it's the number assigned to the purchase requisition), I would like to be able to use it as a search field...so if I type "199039" in to the field and press enter, the contents of that record would show up. Instead here's what it does; Let's say I'm filling out the contents for PO #199000. I fill out all of the comment boxes and everything for 199000. Now, I go up to the PO field, type in 199039. Rather than opening that record, now it saves all of this information in po 199039. So anything previously entered for this record is now gone! I have a search button which has been working fine, but typing in a number in the PO field would be beautiful!
2. It is very simple to the point of being dumb....I'm not going to win any awards for this database, it's pretty crumby (wow, now I'm beating myself up