Search results

Thanks for the quick reply, The tables are linked that way in the relationship Tab, but when I try to drop the tblOrganization table in I get what you see in the attachment and the results of the query is no data. I tried dropping tow additional tblOganization tables with no change. John

Hi All, I may/may not have an issue, let me explain. I have two a table’s tblCMAS and tblOrganization. The tblOrganization table has a list of organizations and is the one side of the relationship. The tblCMAS table has three fields that are linked by the relationship and pull data (OrgID as FK)...

My name is John, I am a self taught MS Access (2007)/data base enthusiast. Like many novice I have come to this position out of necessity. In am a computer network engineer by trade however in my current position as a Facility Security Officer (and for the record, I am not a security guard), I...

Sorry, this is sameless reply to get my post count to 10. This will allow me to add my email address.

It would seem I have solved my own problem and it was quite simple. I don’t know why some of the other code I found did not work but the following did: Created an unbound Combo Box, set the Row Control Source to a query on the MControlNum field. Using the AfterUpdate event, Private Sub...

Hello All, I am having an issue trying to create a Combo Box to use as a search device, selecting a “Control Number” from the Combo Box pull down and having that record displayed. I am using a Form setup as a “Review Form” I.E. all of the fields in the Detail section are locked to prevent...

The code above did not work, however after removing the (1) it did... If Me.Status = "3" Or Me.Status = "2" Then Me.Container = "1" so the fact that they were based on select queries made a differance.... I.E. using the ID numbers corresponding to the desired text Destroyed, Sent...

Ok how about this: If Me.Status(1) = "3" Or Me.Status(1) = "2" Then Me.Container(1) = "1" The numbers "X" are the corresponding ID number in the respective tables and represent Desrtoyed Sent and N/A..

Let me clarify something, it may make a difference. As I stated earlier, both the Status and Container and combo boxes that pull from Select Queries in their respective tables, in the Format tab the Column Widths is set to 0”;1”. Having said that, should the “Destroyed” be set to the...

I did, and nothing happens, no errors and nothing changes.. Here is what i am running Private Sub Status_Change() If Me.Status = "Destroyed" Or Me.Status = "Sent" Then Me.Container = "N/A" End If End Sub

So will the following work: If Me.Status = "Destroyed" Or Me.ComboName = "Sent" then Me.Container = "N/A" End If The Me.Container being the name of the Container combo box... John

Oh poo if it is that simple I will shoot myself in the foot… May I assume the Me.ComboNome will be the name of the combo box I.E. Me.Combo56. Also the field I want to update/change is the Container field, it is not a text box. Is it treated as a text box for the purpose of the data entry? I.E...

Hello all, first off I am a self taught Access 2007 enthusiast. Which basically means, I can get myself into trouble and maybe get myself out. Here is my issue; I have a table “tbl_CMS-Master”. This table has several fields the issue surrounds the “Status” and “Container” fields. Both of these...