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

Spike; You're correct. I removed the lookups and did the query with joins. for just the ItemType and it works... Thank you and Brian too for the help. Sorry I made it confusing, at my Access knowledge level I don't use the right terms or chasing the wrong problem. Thanks again!

Spike; You're correct. I removed the lookups and did the query with joins. for just the ItemType and it works... Thank you and Brian too for the help. Sorry I made it confusing, at my Access knowledge level I don't use the right terms or chasing the wrong problem. Thanks again!

SELECT [tblItem].[ITEMID], [tblItem].[ITYPEID] &" / "& [tblItem].[IMODELID], [tblItem].[ItemSerialNum] FROM tblItem; Why does it work exactly as I wanted it to in the "Query Design" not when the exact same query is run from the Combo Box?

This is where it gets confusing, at least for me... The values are in the two foreign key fields in the table "tblItem" - "ITYPEID" & "IMODELID" which are being pulled from their respective tables with the "ItemType" and "ItemModel" fields. tblItem.ITYPEID = SELECT DISTINCTROW...

My apologies if I haven't made it clear. The combo box I have works. The problem I am having is with the query I guess...except when I create the query from the tblItem in the "Query Design": tblItem.ITEMID tblItem.ITYPEID tblItem.IMODELID tblItem.SerialNum SELECT [tblItem].[ItemID]...

Correct. In my case I need to see the "ItemType" the "ItemModel" and the "ItemSerialNum" to be able to select the right record. The question is how do I get the combination of information "displayed correctly" so the desired record can be selected from the combo box and then opened in the...

Sorry if I made it confusing! No...what I want is the actual "ItemType" and "Model" (text) to be displayed, or both if I have to. You can't tell which Item Record you're selecting from the number alone. Each value is pulled from their respective tables for each "Item" record. tblItemType...

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

Re: Update Set Value based on Max(Date)...New Code Help...I've redone the code... __________________________ Private Sub LOCATION_AfterUpdate() DoCmd.SetWarnings False DoCmd.RunSQL "UPDATE tblItem INNER JOIN tblItemEvents ON tblItem.ITEMID=tblItemEvents.ITEMID " & _ "SET...

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 was able to get it with the conditional formatting though... InStr(1,[HARDWARE],"Chassis") Thank You both!!

I've tried both methods to bold that text in the report, and no joy! I'm sure I've defined it correctly, I've even changed the underlying alias in the query to: HARDWARE: [HWType] &" - "& [HWModel] &" "& [HWDescription] &" S/N: "& [HWSerialNum] It still doesn't see or recognize the...

Thanks...I'm on travel right now & I'll try it as soon as I get back. Wouldn't HARDWARE be considered an alias in that case? In the underlying query for the report I have... HARDWARE: [HWID], [HWType] &" - "& [HWModel] &" "& [HWDescription] &" S/N: "& [HWSerialNum] Also, to get Brian's If...

When I select the field the Name = HARDWARE & Control Source = HARDWARE in Edit View. Yes I'm search within the concatenated string. I'm not sure what you mean by alias. Please excuse my lack of understanding on the terminology...I've got a pile of books & I'm learning though.

That didn't work either, and I probably should have supplied this info up front.:mad: This is the Concatenated Field (Combobox) The Record Source for the form is a query where this string is expressed as "HARDWARE:" SELECT DISTINCTROW [tblHW].[HWID], [HWType] & " - " & [HWModel] &" "&...

BTW...neither did the If, Then, Else Statement.

Sorry...vbaInet, I was answering JamesMcS' question...I did use the Expression Is, no joy. Initially I looked under the Field Value Is when I started to see if there was something like "Begins With" etc., but that would have been too easy ;>) I've tried calling InStr, Left, Left & InStr with...

I'm using Access 2007 & there isn't any selection in conditional formatting for "begins with"...all selections look like they are meant for numerical or date values...Between, No Between, Greater Than etc. I tied the If Statement in the Detail section On_Format Event with the same results "no...