I won't have too many items in the list box, maybe 30 - 50 at the most, maybe not even that. But I might incorporate that attached query in the future, definitely if it gets too big or I see a long load time.
Sorry, but what is a Point Of Sale.
I haven't looked at VBA yet, but if you happen...
wdgriggs - If I'm not mistaking I have my item form set up the same way. The item information is the main form and the orders related to that item are the subform (serving as a history of the people that have placed orders for that item, along with the date and quantity - not really concerned...
I think I might have solved my lookup/quick list issue. And I am able to do it from one table. In the design view of my form, i inserted a List Box, but choose the option:
Find a record on my form based on the value I selected on my List Box.
It did exactly what I wanted it to do, its a list...
The sample Northwind that I have doesn't have a table tblswitchboarditems. What I found is it doesn't have a form for the switchboard...
I'm not sure if you referring to this, but a good example of what I want is in the products section of that database. There is a button for Preview Product...
We had some high-priority issues come up, so I am just picking up with the Access Inventory DB today.
I've been looking the stuff over all day, and I can't seem to get what I want (my menu of items). I've tried using Macros, Lookup Wizard and queries, but I can't get what I am looking for...
That's funny about the upside down mouse.
It would definitely be easier for me if the user could get used to the usual mouse configuration, its not like it hasn't been set up like this the entire time. But, that's why we're around (help desk tech, etc)!!!!
I'm definitely pushing for the...
Thanks for all of the advice, its good to know.
The wireless mouse sounds like a good idea for the client though. I think I might move with that idea.
But at least there is an alternative if that is not satisfactory.
Thanks again to all who responded.
Is it possible to have 2 mice on one Windows computer. Either Windows 2000 or XP. This is basically to have a left handed mouse and a right handed mouse for different users that are using the computer. These users are not going to be logging in with different profiles.
It seems like it might...
That's great. Once I work out what I want to do with the queries, I think that might be my next step.
I'm glad Access has the answers I need.
You guys have been great, thanks for your help.
Hey Randy, I found the controls for enabling and locking. I was looking in Design mode of the table, I just found the ones you were referring to in design view of the form.
Thanks.
Hey Randy700 - got a quick questions for you. In the Northwind db, if you go to Products and then select the Preview Product List button, it opens the list in what looks like a report.
What I would like is basically the same thing, but instead of displaying a report, it display a list of the...
Thanks for responding xaf294 -
For my inventory I have the item form as the main part of the form and the order form as a sub form.
In regards to what you do to find an item without using the arrows, are the subform and mainform the same table?
If so, how did you do that?
If not, what is...
Thanks - Randy:
I'll look into the queries and see if that solves my problem. I took a look at Northwind, and as far as I can tell, as far as I can tell, you have to click the arrow to go from one item to the next.
Also, where are these controls for graying out the fields? Are they in Design...
Hello all, I'm new to MS Access. I just finished a book on it, and I was hoping to find 2 things that maybe can't be done? My purpose is to use this software for inventory management.
First:
When you are in a form,the only way to go from one item in a form to another is by clicking the arrow...
Ever since we upgraded our Contivity Box from 4_05.040 to 04_06.222, we have been experiencing a lot of problems with branch office connections being dropped. I've done a little research and given the errors that we get in our log, invalid cookie, etc, I'm pretty sure this is the result of a...
We have a 1500 and the branch offices use 100S. I'm figuring you're referring to connection speed when you ask 128 or 56. We have DSL, Cable and Frame Relay being used to connect from the different branch offices. We upgraded from 4_05.040.
Thanks.
Entire message is Delete ISAKMP SA for branch office (not peer to peer).
Started happening after contivity box was upgraded to firmware 04_06.222. Clients can't get to our Contivity box.
This is a new job and just started getting involved with networking. If I left out any important info...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.