Search results

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...

Im not sure if I understand your question fully, but it seems that you are looking for the drop down to return to the default value again "All" after the user has made his/her choice? If that's not it, than sorry... But if it is then the solution is easy. Open up the properties menu for that...

wow...good idea Shadowman...

Following what wazz said (or further explaining it)...the ID is the important field, it is the relational aspect which links the table to other tables (at least if your db is built correctly). You sound a little new to this so... In the properties menu for that combobox: Your ROW SOURCE will...

Alright...maybe I misunderstood what your situation is. Do you have a subform embbedded in your main form, and you are trying to refresh the main form? That's where "Me.Parent.Refresh" would work, and what I thought you were trying to accomplish. Another option is to put a "refresh button" on...

Me.Parent.Refresh Place that on your last command button or something. Like if you have an enter button, or a save button. Put it in the code at the end (or rather before the end) ex: Private Sub Command32_Click() On Error GoTo Err_Command32_Click DoCmd.GoToRecord , , acNext...