Search results

In need of a 100 lb. MS Access brain…the problem I having is with the Hyperlink field I have in a form with Access 2010. Table Name = tblOrg Form Name = frmOrg Control Name = ctlOrgTabs Tab Name = CONTACT INFO: Hyperlink Field = OrgWebSite Is Hyperlink = Yes Display as hyperlink = If Hyperlink...

Greetings. I am trying to use a combo box on a form (frmItem from tblItem) to find records for viewing/editing. The information appears in the combo box and it finds the correct record, but the fields "ITYPEID" and the "MODELID" are displayed as numbers. The way I set it up the "Find...

Greetings; Please advise if I have posted this in the wrong forum, incorrectly or haven't given the right information...TYVM Using MS Access 2010 I am tracking inventory "Items" in a database and the "Events" associated with the Items as they occur. I want the "CurrentStatus" to set to the...

Filter Macro/option group Looking for assistance please. Using MS Access 2007 I'm trying to filter the [HWEvents] contained in a subform (subHWEvents) which is in a control (ctlHWEvents) on the main form (frmHW). The Record Source for the subform is a query (qryHWEvents). The Option Group...

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

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

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

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