Recent content by alikona

Thank you very much! I got it figured out with with your suggestion. For anyone else who might stumble on this, I came up with the following. It checks to see if the string in txtTagDesc is greater than 40 via IIF(Len()), if true it then uses the left/mid commands using InStrRev to find out...

Hi all, I have an access database that I use to speed up my data entry into another program (SAP). I use it to concatenate multiple fields into one. One of my issues is that the field in SAP has a character limit of 40 and any other data must then the added to a 'long' text box beneath it. I...

Thank you both for the detailed explanation, it is very helpful/appreciated. I tend to think in the logic of excel formulas as that is what I am more experienced in. Obviously it occasionally leads me into issues like this, hard habit to break.

That fixed it, ty. Confusing though, I thought the syntax for IIF was (Expression, TruePart, FalsePart), which I assumed would trigger this statement as false since 0 is not > than 0, resulting in the "" value.

Hi all, I have a database where the user selects a number of tests and then a report is generated with a combination of verbiage for whatever tests were selected. In a field on the report, a string is generated that lists the names of the tests included, with commas as well as a final "and"...

Tried a few more things and this seems to work. Dim RecordUpdateSQL As String RecordUpdateSQL = "UPDATE [tbl_SNModifiers]" & _ "SET LastCoreNumber= '" & Me.LastCoreLink & "'" & _ "WHERE [Assembly_Number]='" & Me.DeviceLink & "'" & _ "And [CoreReset] = False"...

I'm sorry what? Now I am even more confused lol

Hi all, I have this update query that I'm struggling with, I do not have the right syntax but I'm not sure which the YES/NO field should use. Dim RecordUpdateSQL As String RecordUpdateSQL = "UPDATE [tbl_SNModifiers]" & _ "SET LastCoreNumber= '" & Me.LastCoreLink & "'" & _...

No such luck with this. Thanks for the input all, I have some more reading to do!

Hi all, I have this really old database that was most likely created in Access '97. A colleague got it working when we upgraded to 2016 and part of that was manually installing Microsoft DAO 2.5/3.5 Compatability Library. The issue is, every time this database is opened, the reference seems to...

P/N# is just the label content, the actual field is named PartNumber. Same with the others that have spaces, the actual field name does not. (see screen) This field is set up as a combobox with a query that pulls info from tbl_PartNumber as the row source. The query references CustomerLink...

See attached images. On the first line item, the conditional formatting is correct. In image 2, the conditional formatting does not apply, even when the focus is on it. If I were to select the second record in Line Items, open the conditional formatting window and click apply, it would...

Perhaps I was not clear in my original post. They are not subdatasheets per-say. My form has several subforms that are displayed as datasheets. They do not contain subdatasheets. It appears you can use conditional formatting on subforms in datasheet view, as my expression partially works...

Hi all, I've been thinking about how to implement a database to assist some of my coworkers in running cycle counts. Currently, the inventory system we use does not perform this very well so we do it manually via excel sheets. This is incredibly time consuming/tedious. This database idea has...

Hi all, Some more questions on the project I'm working on. I have an Order Details form that contains two subdatasheets. One for Line Items and the other is for Shipments. Each order can have multiple line items, and each line item can have multiple shipments. How it is set up now, when you...