Search results

Worked like a charm! Exactly what I needed it to do. Thanks brother!!

I am trying to get a total deducted field in my query. Here is my SQL statement that doesn't work... TotalDeducted: IIF([Requirement_Satisfied]=True, "0", IIF(([Requirement_Other_Than_Satisfied]=True),[Requirement_Score], ([Requirement_Special_Considerations_Satisfied=True]...

So, I decided to go with an incrementing text field to add to the assessor's name instead of the autonumber. And on the form, I tell it to ignore the unique number field if it is not null, which keeps the unique number unchanged while allowing additions the next day. It also allows the Lead to...

Yeah, their name is included in the spreadsheet. I'm trying to combine their name and a unique number to identify each request as unique, but be able to update it once it is completed, and add more document requests if the need arises.

OK, here's the ugly. We have teams of 4 assessors and 1 lead go to contractor sites with individual copies of my database. Each assessor has their own copy because we are not allowed to connect to the contractor's network, nor are we allowed to network ours together. We have phones that we...

I have a hopefully easy question... I have a single form tied to a table. I have a "User_Name" field and an autonumber field. I have a third field called "request_ID" that I would like to concatenate the "User_Name" field and an autonumber field but have that value stored in the table as a...

Well, I am inserting over 255 characters of dummy data in the first line of the spreadsheet when it is created by my export query so it thinks the field is a long text field when it imports into the master copy. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml...

So, it looks like Access looks at the first cell of data in that column below the column header, and if that value is longer than 255 characters, it imports that column as long text, but if the first cell is not, it treats that entire column as short text. That's stupid... I'm looking at how to...

So, the weird thing is that I allow a multi select, and I import them one at a time. Some data works and some doesn't. I checked the records, and one was truncated at 255 characters, and another had 435. Calgon...

I changed it to DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "Tbl_Objectives_Import", strSelectedItem, True and it behaves the same way.

Greetings, I have an Access 2016 database that I am importing data from a spreadsheet. Below is the command I am using to do so: DoCmd.TransferSpreadsheet acUpdate, acSpreadsheetTypeExcel12Xml, "Tbl_Objectives_Import", strSelectedItem, True Everything works as anticipated except my long text...

Ok. I got it figured out. There are 3 separate states for the Requirement Sat/Not Sat checkboxes . Here's the code I crafted, which is working as I need. I put it on the After Update on the Subform control: Set rs = Forms!frm_Families_and_Subfamilies!SubFrm_Requirements.Form.RecordsetClone...

So, I got it to where if I check the checkbox on the subform, it loops through the recordset. For testing purposed, I have it pop up a message box for the status of each checkbox in the record. It reads properly. What it doesn't do is execute the loop again unless I navigate to a different...

The checkbox in the subform. If all of the filtered records get that box manually checked, then the main form's checkbox will get checked. Yep. Manually setting it right now. It's a business requirement. The Lead doesn't want to see the subform checkboxes, but they are all required in order...

Evening!. I am working on my main form. I have a main form with a checkbox labeled "Sub_Family_Satisfied". The sub-form is a single Form with a checkbox on each record for "Requirement_Satisfied". I need the "Sub_Family_Satisfied" checkbox in the main form to check when all of the filtered...

Ha ha… very funny.

If only bills worked that way...

I appreciate your response. Ideally, you are correct. But this is just a small subset of the overall database, and I have coded and queried based off those checkbox values, so I am stuck with either a full redesign or getting this, what honestly should be simple, thing to work. I have logic on...

Good morning. I have a table that lists 30 bills that are paid monthly, and separate checkbox fields for husband and wife. As a bill gets paid, I check the box for who paid. I need a query that will produce a list of how many bills the husband paid, how many the wife paid, and how many are...

When I remove the LMT from the query and add the ProfID from the Professor's table, the query shows the extra (unassigned) professor named TBD with PCID 999999999. However, the new ProfID combobox on the form will not show the TBD in the dropdown unless I change the control source to...