Recent content by KingRudeDog

It's been a long while since the last time I have posted on here. Last time I was posting, I was a pee-on at a materials testing laboratory tasked with updating the labs testing process records from an excel spread sheet to an access database. This was quite the task, because I had no prior...

I know this may sound silly, after all I am more of a novice programmer than all of you. But...I picked up this much simpler code on this forum from a Windows OpenFile dialogue and pirated this portion of the code. Im not sure if it will work on the older databases or not. But it works on the...

I have attached a picture of what I am explaining below. I know I could rebuild the table structure to accomplish what I want, but that would be exhaustive considering the amount of work required (forms are already built, db working, just trying to dumb it down....tool used in previous db)...

I have a form...formatted as a datasheet...with a combobox (cboMaterials_fk)that allows the user to add more then one material per item (in other words the user can define that the item is made up of several materials, after each choice a new line item appears (*) so an additional material can...

Thanks...I just figured it out (thanks to your comment)...need to dirty the form first.... Sigh.

here is the simple db i just made:

All that is true. So here I've tested out a seperate test db to simplify things. 1 table, 1 field, 1 form. The table is tblBlah The field in the table is Blah1 the control on the form is also Blah1 So this should work: In the BeforeUpdate event for either the form or the control: If...

Yes. You can assume that.

Yes...that's what I meant. Thanks. And I have tried the ,after update. event as well. I'm totally stumped over this.

Okay...I know the basic syntax for Dmax (or at least I thought I did) but I cannot get this statement to do what I want! In the <before update> event I tyoed this: Dim RNum As Long Me.txtRNumber = DMax("[Request_Num]", "test_request") + 1 Me.txtRnumber = RNum txtRNumber is the field on the...

okay guys, this is more of a vba question. I have a textbox [txtRequestNumber] on a form which is anchored to a table from which it pulls the data. After the primary key, this is the main record tracer of my db. What is the sytax, so that when the form [frmMainForm] is opened to a new record...

Your A Fricken Genius!!!! I ca't beleive I didn't come up with the vba idea myself...I bow before your superiorness...

I have a main form [mainform] with several subforms on it, two of which are on a tab. On the second tab [page79] there is a subform [subformlist] which has like 25 checkboxes on it, any combonation of which can be picked by the user. I need there to be at least one pick required of this...

An If...Then or a Case Select...

Once again...thats if I understood your question correctly...