Search results

Shoot actually I just remembered that the logic was needing to be slightly altered than what I originally said. Sorry, the individual asking for this changed it up just minutes ago. I would like my combo box (though i could change this to text) to look up the value inputted by user in a table...

Hi Majp! Thank you for the code! I tried initially to use dlookup, but couldn't get it to work so that's why i settled on a combo box. I tried out your code, and it almost works - but instead of returning the 2nd value if found in the table, it goes straight to showing "N.O.L". Would you know...

Okay I worked out a bit more of the logic. I want it to go: If user input into ComboValue is found in Table1, then TextValue = ComboValue(column1) Else TextValue2 = "N.O.L"

Oh, and I have the control source for the second textbox (that spits out the associated value) set to "=[cboStockSku].[Column](1)"

Thanks Plog, I have attempted many variances of if/then type of statements to no avail. I neglected to realize and indicate that besides the code listed above, I also have an After Update Macro associated with the first inputted value, which uses the SearchForRecord macro, where the Where...

Hi all, Brand new to VBA here, so I'm in need of some assistance! I have a database where you input one number, it looks up the number from a table, then spits out another number associated in the record (like vlookup). For the first value, I used an unbound combo box that has an invisible...

Hello! ValidateCDrive() is only called the one time on the one form. That form is actually not the first form that would open, so that's why I'm confused as to why it would work. As for the TimerInterval - do you know why you would want to use this?

Hi all, I inherited quite a few databases at my new job, and my predecessor had set up some VBA on a couple of databases so that if the user tries to open the Access file from the shared server, it will force quit on them. However, he didn't leave any descriptive notes in his code so I'm not...

Thank you all for the additional information. So I just discussed this with the coworker, and he will be showing me if his observation occurs again (finding Access in the background process despite being closed). I told him that I believe him, as I've seen it happen, but I don't believe it's...

Micron, haha don't worry, I am a very diplomatic person and my statement was much more blunt then I'd actually go about. I don't intend on just calling him out, I just may discuss it with him. Yes, thank you for bringing the force close potentially corrupting data to my attention. I will make...

Wow thank you all, what a cool forum! I'm feeling much more confident in saying that he's wrong. We actually have code set up in a couple of our main Access databases to check whether they are opening from their own drive, so I will make it my priority to incorporate this into all of the other...

Thank you for the fast response! It looks like you're correct. I don't understand why this coworker is thinking such a thing, but I wanted to be absolutely sure before informing my other colleagues that he is incorrect (especially because I just started this job). He believes the database will...

Hi all, I have a coworker that went around informing everybody yesterday that using the top right red x to close Access does not actually fully close it. They said you have to go through File -> close for it to be properly closed. Now, I've never heard of such a thing, and this coworker...

Hi all, My name is Nicole and I'm new here. I am currently a database administrator for a large organization that uses Access in their distribution center. Thank you in advance for all of your help with my questions! Nicole