Recent content by Demetious

Yeah, thats what I did. Thanks for the very fast response!

Nevermind, I figured out I have to change it to a combo box and then use the "inherit" property.

This is probably pretty simple but I can't get it. I have a text box on a form called tb_Item. I simply want to go to that textbox, start typing, and if the Item exists, it will autofill the text box. Any help would be great, thanks.

Mr. B, So tblInventory already has a relationship with my tblTransactions which allows me to add/delete inventory. I would then need to create an additional field in my tblInventory with an autonumber in it and link that directly to my tblProjects in a one (tblInventory) to many (tblProject)...

I have frmInventoryDetails to input inventory items that I need to link each item to a project. The problem is, each item is used in multiple projects. Right now I have a text box on the form and I have a caption that reads; "Project Name: Please seperate project name with a comma" this is...

I found a post that Bob posted back in 2001 that sums it up for me. Now to figure out how to do it using subforms. Thanks guys. http://www.mvps.org/access/lookupfields.htm

I know this has been discussed plenty of times here but I have searched for an answer as to why this is a bad idea with no luck. Microsoft actually has a tutorial on how, why, and when to use multiple values at table level. I simply want a combo box on my form that allows me to pick multiple...

Vba and Bob, You both have been most helpful. I wasn't getting any popups, as they were disabled, so I had no clue. This did the trick. Again, thank you both.

Wow, I was getting so flustered with this, I didn't even Zip it. Here you go.

This is the entire code in the Form event Load Private Sub Form_Load() DoCmd.RunCommand acCmdRecordsGoToNew End Sub I open the DB and the form opens to Record 1. /shrug I don't know VB code and I obviously suffer from a mild case of stupidity.

The form opens automatically when I open my DB. If need be, I can change that back to open through the navigation window. My goal is to have only two forms available to Shipping/Recieving when I split my DB. One for inventory detials and one to add/remove inventory.

My goal is to have the form, when opened, to open to a new record. Private Sub Form_Load() DoCmd.OpenForm "Inventory Details", , , , acFormAdd End Sub This is my code in the Form On Load event. I'm sure I am doing something stupid but I can't figure it out. Thanks again.

I had this happen to me with a different program and found out what the culprit was, there is a program on most computers that you can map keys for accessibility. I was accidentally hitting the combination of a letter and my mouse click while not in an active window or something to that effect...

Doh, It's too big. Here are a couple screenshots to include the code I have for the form. I have tried the code in the OnCurrent as well as the OnLoad. Let me know if you need anything else please. Thank you for all your help.

Many would argue that Clinton had nothing to do with tax policies "working", and that what we saw was due to Reagan. Much like the arguement that Clinton was responsible year later for deregulation of mortage companies Fannie and Freddie which started our journey here (today). This is an...