Search results

Thanks! I've gotten it to add the description to the table, and now am trying to get it to replace the (agency name). It will add the other items to the table, but when I select the 3rd item with agency name, I get "Invalid use of Null." Set db = CurrentDb() Set rs =...

The table is storing data and pulling the description via query. I'm fine with adding the description to the table and I added a field (DocNeededDesc), but having trouble getting it to add. The description is in the 3rd column of the listbox. The ID is the bound column. This is what I have at...

Thank you! Is it an issue that my table (tblLetters) is only saving the ID number of the item needed? The subreport query pulls the ID from tblLetters and the description from tblDropdowns. The description is where the (agency name) appears. Do I need to change tblLetters to hold the longer...

I got it from your website multi-select listbox example! Public Sub List() Dim strSQL As String Dim db As DAO.Database Dim rs As DAO.Recordset Dim ctl As Control Dim varItem As Variant On Error GoTo ErrorHandler If Me.Dirty Then...

Terrible title, I don't know how to describe it! I have a form that the user completes to create a report. This report is a letter that is sent to the customer asking them to provide a document. There is a multi select listbox with 10 options for the user to choose what they need. The ID of...

That is perfect! Thank you so much!!

Here you go. I took out a lot of info so it looks weird, but this should cover what I need. If the datasheet has any checks=true, then I need the notary letter. If none checked, then the other letter. Thanks for looking!

Also, I tried doing code that if the checkbox was checked for notary, to open the notary letter, but it didn't open accurately if there were some boxes checked and some not checked in the datasheet. If [Forms]![frmTobeProcessed]![frmDocSub].[Form]![chkNotary] = -1 Then DoCmd.OpenReport...

I have a main table (tblExceptions) that contains all of the other information that will appear on the reports, like customer name, address, etc, and then a related table (tblLetterJunction) just for documents needed that only contains: ID ExceptionID (from main table) Document Needed (#)...

I have a form with a datasheet subform, which contains a combobox of documents to select from. They can add as many documents as they want. 3 of those documents require a notary, 6 do not. If the user chooses a document that requires a notary, Notary Required is automatically checked on the...

No, this is more of a cleanup project and the only thing dependent on state is if they get a generic POA or a state specific one. If "Notary Required" is selected, I currently have code to open the generic POA if it's not one of the 6 state specific states. If it is, they have to go to a...

I agree. I'm working with people who aren't familiar with Access and keep changing requirements on me and give me a short timeline. The PM has her own deadlines for procedures, so she is doing it regardless of if I'm ready or not. You are close, it's actually related to auto loans, not...

Would the conditional fields on the parent form be unbound then, and pass the values to the subform's table? Or how does that work? When I started, I had another table: a table with the account info, a table for all of this info that will appear on the letters (customer name, address, and the...

Do you have a suggestion of a better way to do it?

Thank you, thank you! It works! I appreciate your help!

Ok MajP, I tried that and it appears that the fields aren't opening until I select another combo below it. For example: I select POA. Nothing happens. I pick another document in the 2nd combobox, and then the POA fields open. I make a selection in the 3rd combo, and the fields enable for the...

Hope this helps. I have the following: tblExceptions: main table with imported data from report that shows what each account is missing and additional info the user will add. tblDocNeeded: Is a list of all potential documents. Combobox rowsource is based on this. ID Document Instructions...

Sure, if a listbox would work better, that would be fine. I have seen some code to add the listbox selections to a table on the form's after insert event, but I didn't know if it would work for me here. In this form, they fill out all the fields and then there's a print preview and print...

I still end up with the same issue. Is what I want to do possible with a continuous form?

Thanks MajP, I just saw your response came when I was typing that. I will give that a shot!