Search results

Previously had Access 2010, now on 2016. I have a database that has several fields that start with "5S3D....", not only in the tables but on 2 forms, several queries, and reports. All of sudden everything came to a screeching halt, all pointing towards these fields. Coding is used to unhide...

Thanks MarkK. I will give that a try. I like nice clean language so that if someone else needs to modify it, they can easily understand what is being done.

Exactly....I just didn't think it through logically. Thanks again!

Thank you ridders!! I used this and it works. I did not make the connection regarding the use of SUM. Very much appreciate your help!! Saf_Deviations_Total: IIf([Saf_Pledge] & "" = "NG", 1, 0)+IIf([Saf_Tracking_Align] & "" = "NG", 1, 0)+ IIf([Saf_Injury_Tracking] & "" = "NG", 1, 0) +...

arnelgp: getting the same error message, and when I put the expression in the query, it is putting brackets around each of the field names. I tried removing them but the query reinserts them. Saf_Deviations_Total: Sum(IIf([Saf_Pledge] & ""="NG",1,0)+IIf([Saf_Tracking_Align] &...

Ouch.....well, now I am getting an error message on the query expression. "Query does not include the specified expression 'ID' as part of the aggregate function". Here is my expression: Saf_Deviations_Total:Sum(IIF(Saf_Pledge="NG",1,0)+IIF(Saf_Tracking_Align="NG",1,0 )+...

Mark and arnelgp - thank you for your replies and guidance. My example showed just 6 of the fields, however, there are a total of 28 such fields divided into 4 groups so individual queries will not work. I tested your code Mark in a query and it works perfectly for what I need. Thanks again!

Have a table, with related query. All are combo boxes with set choices of G (Good) or NG (No Good), and then each subset it used to select a number of NG items. Field 1 - G Field 2 - NG Field 3 - NG Field 4 - G Field 5 - G Field 6 - G NG Score = 2 (manually selected from 1-6, for the total...

sneuberg, thank you so much. Let me play with that event and see if I can work something out. I have a couple other ideas too since I posted my original post.

Q-Is FIELD1 the field the combo is bound to or the row source? A-Yes, it is tied to a query ----- Q - I don't understand. Autofilled where? Autofilled how? A- There is a record# combo box on FORM B. When you select the record #, several of the other fields are auto-filled based on the...

In short, I am trying to do something I have never tried before, so I do not have any previous examples to use. I have two forms, FORM A & FORM B I have [FIELD1] that I select the value in FORM A. That same value is then 'auto-filled' on FORM B. Also on FORM B is [ComboBox1] that has between...

I solved the problem and want to post what the issue was. I was using the common terms of "Yes" in the code, when in actually Access interprets Yes as -1, and No as 0. I change "YES" to -1 and it works great!

I have frmIncident that has a 2-column combo box (cmbIncidentType). Column (0) is IncidentType, Column (1) is YES/NO. This combo box feeds from a Query and currently has about 15 "types" of which 4 have a "Yes" tied to them, then rest "No". There are situated on a TabControl (tabIncident)...

mrojas - thanks for the reply. Where I am struggling is the first part - how to tie the selected response to un-hiding the sheet tabs, or leaving them hidden.

I have tab control form with (5) tabs. For this discussion - Tabs 1 through 5. For a blank (new) form sheet tabs 4 & 5 need to be hidden. Based on what is selected via the drop down box (on tab 1) then tabs 4 & 5 may remain hidden or needed to be un-hidden. Example: [DropDown1] Selection...

Very good. I will give that a try.

The Access database is the back-end of a web page, so even though the user is adding their password into a form, its a web form. So I will need to do some research on setting the criteria in the web form itself.

I have a password field in a table, where I want to establish a validation rule for the minimum (6) and maximum (10) number of characters that it must be. Also, the field should be only alphanumeric. Is this possible?