Search results

I am trying to Bold an entry in a report, generated from a query, for a concatenated text field that contains specific test. The field is called HARDWARE and the values I'm trying to bold contain the term Chassis as the first word. Conditional Formatting accepts both of these Expressions but...

EUREKA! I had to change it to the subHWEvents to ctlHWEvents, but it works just like downtown! You were correct on the Me.Requery docmd.setwarnings false docmd.runsql "UPDATE tblHW INNER JOIN tblEvents ON tblHW.HWID=tblEvents.HWID " & _ "SET tblEvents.CurrentStatus = No " & _...

The Form/sub-form is set up as: Hardware Form = frmHW Record Source = tblHW Caption = DSEI HARDWARE The Tab Control = tabHWInfo (with 5 tabs) Tab 0 Name = tabEvents Tab 1 Name = tabHWRemarks Tab 2 Name = tabHWPOC Tab 3 Name = tabHWPurchaseInfo Tab 4 Name = tabHWImage The...

Here's as far as I can take it... Private Sub Current_Status_AfterUpdate() Dim SQL As String SQL = "UPDATE tblHW " & _ "INNER JOIN tblEvents ON [tblHW].[HWID] = [tblEvents].[HWID] " & _ "SET tblEvents.CurrentStatus = No " & _ "WHERE ((([tblHW].[HWID]) = HWID()) AND (Not (tblEvents.EVENTID) =...

I used the OBE grid to create the SQL and then entered it into the After Update for the Current_Status. The SQL was OK with the QBE but not the Private Sub Private Sub Current_Status_AfterUpdate() UPDATE tblHWID INNER JOIN tblEvents ON [tblHW].[HWID] = [tblEvents].[HWID] SET...

vba/Inet; Is this what you meant? UPDATE tblHW INNER JOIN tblEvents ON tblHW.HWID=tblEvents.HWID SET tblEvents.CurrentStatus = No WHERE ((([tblHW].[HWID])=HWID()) AND (Not (tblEvents.EventID)=EventID())); Run via Macro? I was successful in changing the current status to no for all the...

That makes it perfectly clear...I'll try what I think you said 8>) Thanks!

I looked on the forum and other sites, but was unable to find anything that relates to what I'm trying to do...one problem may be that I'm not sure exactly what I'm looking for in Access/VBA "terminology". I find stuff related to combo boxes & text fields, alerts etc. and changing values but...

I have a form ("frmHW" record source = tblHW) which contains a sub-form ("subHWEvents" record source = qryHWEvents from tblEvents) in a tab control (tabHWInfo). The "HWID" Primary Key from the tblHW links the subHWEvents HWID Foreign Key. In the "subHWEvents" sub-form there is a Yes/No Control...

Thanks SOS...I used a slight variation on that On Current for the form. I put my If statement in there as well as the After Update event on the In_Chassis control...works like a champ. Next time you're quaffing a cool one pretend I bought it for you! Thanks again!

Thanks...but I tried that. When I open the form the HW_Chassis control is not visible even on the records that have the In_Chassis control selected (True). It's like the If condition of In_Chassis does not get evaluated. When I toggle the In_Chassis control then it displays the HW_Chassis...

I have a form that contains a combobox (HW_Chassis) which I would like to remain invisible unless the Yes/No control (In_Chassis) is selected. The If statement I used: If Me.In_Chassis = True Then Me.HW_Chassis.Visible = True Else Me.HW_Chassis.Visible = False End If It works...but the...

vbaInet; Thanks for the help. Was able to get it woking.

The name of the field that is suppose to link the two subforms is EVENTID The only fields on the subHWEventRmks is EVENTID & EventRemarks. In the tblEvents EVENTID is a Number, but I've concatenated it with some other fields from the tblEvents.

vbaInet; Thank you for the welcome & the help. No the record source for the subHWEvent is tblEvents. I'm getting that "dummy" feeling... Lou

I have a subForm (subHWEvent) in a tabControl (tabHWInfo) (tabEvents) that I am trying to link to another subform (subHWEventRmks). What happens is...I can create a new "Event" record in the 1st subform (subHWEvent), but when I open the 2nd subform (subHWEventRmks) using a buttonControl to enter...