Recent content by pollardski

Hello. I'm making a database to store movie info for a DVD collection. I have a table with fields: title, year, runtime and such. I want an indefinite number of genre to be associated with a movie, so I created a "genre" table and a junction table between that and the "movie" table. Now, on form...

Well I don't have a problem targeting the right controls now. But it seems that a control that was Null and then had data entered doesn't register using "Value <> OldValue". And I'd rather not have a default value for every field. There's got to be a way of checking whether a control changed...

Okay, I got the code to work by making the first part of the control's tag "dirty" and whatever I want after that to make it more unique. And this code: Dim Ctl As Control Dim ctlTag As String For Each Ctl In Me.Controls ctlTag = Ctl.Tag If InStr(1, ctlTag...

It just hit me that it shouldn't be hard to do using the tags of the controls I want to test because there are only a couple different ones. So I tried this... Private Sub Test_Click() Dim ctl As Control For Each ctl In Me.Controls If (ctl.Tag = "editable") Or (ctl.Tag =...

Actually I am using the tag property for other controls already, so I tried tagging "the one" control with the tag "check" and excluding it which I can't get to work. Private Sub Test_Click() Dim ctl As Control For Each ctl In Me.Controls If (ctl.Tag <> "check") Then...

Hello all. I have a form with many text box controls and a couple combo box controls. I would like to test whether any of the controls are dirty--except for one, which I know is dirty. I have tried using the Tag property of the one control to exclude it in a For Each loop where I test if...

I have two tables: Items and Quotes. They are related through the field: Item_Number. I have the field Factory_Cost in the Items table which I want to add with the field Freight_Cost in the Quotes table. I want to display the Factory_Cost + Freight_Cost in the Quotes form. How do I do this? Thanks.

Hello all. I am a new member on this forum, working on my first Access project using Access XP and 2003. My problem: I have a form sourcing records from a table of "items." In that form you can search for items by item number in a combo box. And you can filter the list of item numbers by...