Recent content by andysgirl8800

I can try to post my dummy DB, which is a shopping list, of all things! It's where I do all my playing around with new things before I transition them over into my production DB, which is too confidential to post here. My dummy DB is really a mess though...

EUREKA!!!!!!!! THANK YOU wjburk2! That was exactly the tool I needed to finish this rotten project! Had to do some relationship building with my tables also, and build in some "not in list" events, but it's all working marvelously now! Thank you to everyone who provided their valuable...

I'm starting to think it is my AfterUpdate code that is failing. I have completely redone my form in its simplest format to focus exclusively on this silly cascading combo box. I have followed several different tutorials vebatim, and it STILL isn't working. After creating a few new bald...

GRR! Sorry guys. Think I may have to attempt to zip it on another PC. My work one is awfully stubborn about Zip files. I thought this was just an incoming bias, but apparently it's an outgoing one too. Thanks wjburke2, I will try your suggestion. I did follow the step-by-step instructions...

I've read the multitude of posts on cascading combo boxes and read the Microsoft tutorial http://www.fontstuff.com/access/acctut10.htm, but can't seem to make even a simple set up work. I've been working on it for the last week and have made absolutely no progress. I followed the tutorial...

Thanks for your response. I was unable to open the attachment you sent, so I guess you could say this is "deep end" work. :) My list boxes are set up with the following information: Data: control source......._________ row source type....table/query row source...........tblBaking bound...

Also, can I comprise a list of items in which each item in the list is linked to a seperate query, so that when it is selected, it will display a new list of values that can be selected? For example, a drop down combo box with grocery store categories, like canned goods, paper products...

Alright, I've been messing around with some code and have my 2 list boxes, "listboxA" and "listboxB". When I use the ADD button to move an item from "listboxA" to "listboxB", it will move over. But if I try to add a second item from the list, it replaces the first item I moved over. How can I...

If you could email a small sample, not in zipped format, I can view it, I think. I completely understand that "pictures are worth a thousand words" and descriptions can get complicated and confusing. The firewalls on my work computer and the administrative restrictions prohibit unzipping...

Ok, that was helpful. Thanks for the info. How do I do this? I think THIS may help me and may be able to accomplish what I need. Unfortunately, sample DBs don't help me a whole lot because I cannot unzip and view the files due to the complicated firewalls on my company's network.

*L* Closer....yes. Perhaps a different analogy would help. Again, I am importing my data from another source, after normalising and automating the import process of course. I think you are getting closer with the heirarchal assumption. My target field will already contain data. Lets say it...

Thanks wiklendt. My data is normalised. The problem I've encountered with combo boxes is that the data is not permanently moved to new field, but rather is "viewed" in that field and cannot be edited. I will need to be able to edit the data that the combo box populates in a way that is...

Thanks for your reply! I realize it may have been confusing. Perhaps if I explained a little better. I upload existing book orders from a spreadsheet from another department. This order already has the book type listed. So when I import it into my database, it's already in that field as...

First of all, thanks to everyone for participating in this site. It has been the most helpful by far that I've come across. That said, I am seeking assitance yet again. I am trying to do something of a lookup function and am not sure where to start. I have a field on my form called booktype...

That's exactly what I am trying to do, but would you please be able to provide more detail? How would this work? I've never used a temporary table before. Thanks for your help!