If I understand you properly, then this may help.
I use the combo box to store and draw additional data. For example, the row source (query) for the combo box might look like this:
SELECT data1, data2, data3 FROM table1
The properties of the combo would be...
ColumnCount = 3
ColumnWidths = 0";2";0"
BoundColumn = 1
Only data2 will appear in the combo box....
AdamOnAccess
Last Activity: Aug 23 '10, 09:01 PM
Joined: Aug 21 '08
Location:
-
How do you create a query to give you the count of 2 columns?
I'm having trouble getting the correct count from a total query. I have 2 tables in a 1-To-Many relationship and I want to count a column in the many table. This query works correctly:
...Code:SELECT tbmAdGroups.AdGroupID, tbmAdGroups.AdGroupName, Count(tbmKeyPhrases.KeyPhraseID) AS CountOfKeyPhraseID FROM tbmAdGroups LEFT JOIN tbmKeyPhrases ON tbmAdGroups.AdGroupID = tbmKeyPhrases.AdGroupID
-
That's Ok. I'll work on another area of the program until I here from you. Thanks,
AdamLeave a comment:
-
Hi Neopa,
I'm not sure how I gave you the impression that products and categories are associated with only one warehouse. I am trying to apply multiple product categories to multiple warehouses.
If you look at the relationship image in post #10, you can see that there is a table called "WarehouseMMCat egory". This is the table that creates the many-to-many relationship between many warehouses and many categories....Leave a comment:
-
Hi Neopa,
Thanks for the reply. I'm sorry you feel you haven't been much help. Just having a pro look over the idea and give some feedback is plenty of help.
Here's a typical situation:
The user will be told to assign a specific product category to a specific warehouse. Within a category, there can be a few hundred products, so it is much easier to assign a single product category to a warehouse instead...Leave a comment:
-
If anyone out there can offer some advice on this question, feel free to chime in.
Thanks,
AdamLeave a comment:
-
Hi Neopa,
Ok, I've uploaded an image of the relationship window so you can see what I'm unsure about. The relationship is unusual because when a warehouse stocks a product category, it typically takes on all products in the category. Only a handful of products in a category are exceptions and not stocked.
It seems to make the most sense to design the database for a many-to-many between wareshouses and product categories,...Leave a comment:
-
No apologies necessary. Your help is always appreciated.
I did look for the proper tags but didn't find them. I used QUOTE because I'm familiar with that one. If you leave me a link to the proper tags, I'll save it.
By the way, is there some easy way to post images in this forum? I was thinking that maybe I could copy the screen showing the Access relationship window and post it. I don't think it would be necessary on...Leave a comment:
-
Hi Neopa,
I've read over your post again - a few times just to be certain - but I think I haven't communicated this properly. You said...
"
If you look at the relationships in my second post, Choice 1, you'll see that I'm suggesting a MANY-TO-MANY relationship between warehouse and product category, not One-to-Many.
If a Many-To-Many relationship is set up between Warehouse and Product category, you...Last edited by NeoPa; Apr 20 '10, 10:44 AM. Reason: Added some tags and rearranged some text that seemed in wrong order.Leave a comment:
-
Hi NeoPa,
Thanks for the reply. Yes, I'm aware the Many-to-one in warehouse to product category will not make it alone. I'm trying to decide between these 2 alternatives:
1st Choice:
Warehouses > Many-to-many < Product Categories
And
Warehouses> Many-to-many < Product EXCEPTIONS
or 2nd Choice:
Warehouse > Many-to-many < Products
The first choice...Leave a comment:
-
A question about database design
I have an odd relationship and I would like to get some opinions on the best way to handle it.
3 tables:
1. WAREHOUSES.
2. PROD_CATEGORIES (One in One-to-many with PRODUCTS)
3. PRODUCTS (Many in One-to-many with PROD_CATEGORIES )
Usually, about 100 products are assigned to each category.
There are over 1000 warehouses. When allocating products to warehouses, typically you would assign... -
Saving the last value in a sub form
I'm in Access 2007. I built a feature that to saves the current list in a sub form to a separate table. It works like this: After entering a list of words in the subform, the user can choose to push a button, and a dialog box appears. The user enters a name into the dialog box to identify the list for later use, presses OK and the list is saved.
In the code, I'm using DoCmd.RunSql on the data in the table, so all the data in the sub... -
Stewart,
Yes, you see the problem. I tried the OnEnter and the GotFocus events, but I saw it didn't work if the user made additional selections. I knew it was going to have to involve AfterUpdate. Ultimately, using the 2 text boxes seems to be the only thing that works consistently. Odd that there is no way to access OldValue, but I have it working so onward and upward.
Thanks,
AdamLeave a comment:
-
ChipR,
Thanks for the reply. That's kind of the the approuch I took, but I because I couldn't find an event to capture the value at the moment of the click, I needed 2 text boxes. Here's my solution:
...Code:Private Sub lstbMyListBox_AfterUpdate() 'store the last value !txbLastID = !txbCurrentID !txbCurrentID = !lstbMyListBox End SubLeave a comment:
-
Store old value of an unbound list box?
Hi,
I need to store the last value of an unbound list box. For example, if the list box is currently set to X, when a user clicks Y, I need to save X in a variable.
I've tried to store the old value in a variable during the Before Update event, but that does work. I've also heard that the OldValue property doesn't work on unbound controls.
Anyone know how to do this?
Thanks,
Adam -
acCmdRecordGotoNew is not available at this time
Hi Again,
I created a few forms that contain sub forms. To speed up the process of order entry, I designed a few sub routines that go to a new record in a sub form, or attempt to save a record in a sub form just before the focus shifts to something else. The code work most of the time but occasionally I get this error:
acCmdRecordGoTo New is not available at this time
Can someone explain the conditions that cause... -
ADezii,
Chalk up another victory for you!
The virtual memory problem is gone. After some minor debugging, the program performs perfectly.
Just out of curiousity, how long does it take to become an Access phenom like you?
Thanks again,
-AdamLeave a comment:
-
Ok. I'll run a few tests and see how that goes.
Thanks,
-AdamLeave a comment:
-
OldBirdman,
I couldn't agree more: Continually switching slows data entry to a crawl and should be avoided. I'm going so far as to creating forms specifically designed around tasks that involve one-hand keyboard and mouse position, and forms that should be all keyboard. I find this really speeds up entry.
Thanks Again,
AdamLeave a comment:
-
NeoPa, OldBirdman,
Thank you both for the help.
OldBirdman, I used your approuch but not with all the bells and whistles. Turns out that if you don't have any click or afterupdate events, the list box handles the up and down arrow keys. It doesn't take Home and End keys. I simply trapped the space-bar keydown event for the list box and it works fine.
Thanks Again,
AdamLeave a comment:
No activity results to display
Leave a comment: