Search results

I hosted the picture on a file hosting site (FileDen.com, ftw!) and just put the link directly to the picture in the body.

*chuckle* Sure. Here:

Hah, how odd! I've been meaning to change it, anyway. I really like the picture, but I've cut my hair since then. =P It's not often I have people telling me I look like anybody! ^_^

Alright, will do. Thank you very much!! ^_____^

Pbaldy, Thanks for your response. I'm not having a problem with the actual combo boxes or anything. (If I need a combo box to be limited, I know how to do that within its properties.) The reason for the buttons for new parts/trucks/order numbers is so that the user can enter all the...

I have a database I'm setting up with two main functions--Entering new receipts, and entering new shipments. For the new receipts, I need a way to be able to enter new parts. For both new receipts and new shipments, I need a way to be able to enter a new order number and a new truck number...

Irish, I was taking a look at your code, but where exactly do I put it? Do I store it as a module? If so, what should I save it as? And also, I have a split database. Is that going to make a difference? Thanks! Rachel

Awesome, thank you HiTech. I'll check these out and see what I can do with them!!

I'm aware that there is already a looooooong thread about creating an audit trail. Here's why I'm posting this new thread. First of all, the audit trail I have set up (yes, from the thread mentioned above) is only saving the first couple of lines of data--244 characters worth, I think, in the...

The Dmax() in conjunction with a little bit of coding worked like a charm! I had to use IfNumeric() to avoid getting a lack of data error, but it works perfectly! Thanks for the idea! ^__^

I hadn't thought about that. I shall have to test it. ^__^

I'm not even sure this is possible. I have a query that, assuming the needed data is there, finds the highest number from a list. Easy. Here's the hard part. I can't figure out how to set an automatic first number, just in case there isn't one already there. I THINK I need to use an IIF()...

Yes, I do know how to use queries--I just didn't recognize the way you coded yours. It was a little different than what I'm used to seeing. I think I got it all figured out now though!

Hey, thanks for your response. I'm having a little bit of trouble using your code, though. I don't have anything called TheType in my tables... Is this a column I need to create or something? What is this supposed to be referencing? And also, is this code something I need to paste into a...

I have a table with the following information on it: ID Number; Part Department; Truck Number Each ID has one of 3 Part Departments, E, P, or H. There are several ID numbers associated with each Truck number. Here's a sample of my data: The pink and purple shaded areas are both from...

Actually I came up with yet another solution. =P The forms that I originally had opening, I now have as hidden subforms on the main form. Then I can just refer to those. =) I'll take a look at your database though. Thanks!

Okay, so here's a monument to my naivety with SQL. What I'm trying to do is a little complicated, but I'll try my best to explain. Upon filling in an ID number in a form, I want two pieces of data to automatically update: The Part Name associated with given ID, and the quantity remaining for...

Yay! Victory! Just fyi! I figured out how to make it work. ^_^ Due to the code I have on the OnCurrent event, anything I put on an event that fired before that would be done before the update on the OnCurrent. IE, when I tried to get the Trucks form to be selected, it WAS--and then a field...

Update: I've got a setvalue command in the OnCurrent event. I know that affects the timing of what I can use, when.

Marley, 1. I thought that would be the case, but it's entirely possible that some other action in my form brings the Receipt box into focus after the Trucks box is brought into focus. I'm trying to track that down... My forms are pretty loaded with code. 2. Yeah, I wondered about that...