Search results

It sounds like me you want to unlock some controls on the main form, but somehow they get locked after getting unlocked. Yes, you are correct. I will attach a screen shot. The comboboxes under Documents Needed (cboDocNeeded) is a continuous subform that saves to a Document Needed table...

Mark, thank you for sharing that. I have to admit, it's a little over my head though and I'm not sure where to start. Are you able to provide me a bit more direction?

When they select something in the combo in the subform, it adds another combo below it so they can select as many items as they want. I want them to be able to select for example, 3 items in a row, and then go over to the fields in the main form and have the necessary fields for all 3 items be...

This is what I currently have that only does one at a time: Private Sub Document_Needed_AfterUpdate() If Me.Document_Needed = 8 Then Me.Parent!AlternateName.Enabled = True Me.Parent!AlternateName2.Enabled = True Else: Me.Parent!AlternateName.Enabled = False Me.Parent!AlternateName2.Enabled =...

I have a form with a continuous subform that contains a combobox. I currently have code to enable some fields on the main form if a certain selection is made in the combobox. This is working, however, if a selection is made in a second combobox, it then closes the fields needed for the first...

Sorry, I've worked something out so I'll remove

I'm in a time crunch and am having trouble figuring out the best way to do this, so hoping for some input. Here's the scenario: The user goes into the form and needs to select from a list of documents. I originally had the "document needed" in a combobox in a continuous subform so they could...

Changing to name instead of type didn't work for me, but I'm not going to worry about it. I added to the message box and I am happy with how it came out. Thank you so much for taking the time to help with this, I really appreciate it!!

Thank you so much, it works!!! I'm so excited! My only question is, that message box that pops up when the form opens - I see that it opens up a blank message when nothing is selected. Is there a way to customize it at all? I would also rather have it say the exception name instead of the...

Ok, here is a demo. I deleted a lot of stuff, so hopefully this is enough info. frmMain has the 3 combos. The fields I want to filter by are all in the top grey box on frmTobeProcessed. cboException = Exception Type cboBalance = Principal Balance cboAged = Days Aged. Days aged is a calculated...

Where would I put this code? On the On load event of the form? And do my comboboxes need to be on the form header? They are currently on a main menu type form by the button that opens the form.

Thank you MajP, I will give that a try!

Thank you for your response. I put a PK on each range and bound the combo to the Pk. Then I'm a little lost. Do I make a text box for Aged Start and Aged End, and after update on the combo, have it fill the values in each textbox? Then in my query do "between AgedStart and AgedEnd"?

I have a 2 part question I am hoping to get some help with. I should also add that I'm not very well versed in queries and I mostly stick to select queries, so I may need specific direction if another type is needed. I am building a database that imports a report of accounts that are missing...

I was getting ready to post a copy and saw there was another reply. Oh my gosh pbaldy, you solved it! The provider address at the top of the letter was actually in a text box named CustomerAddress. I have several letters, so I'm sure I copied another letter to make this one and missed that...

I made a database for a team at work about a year ago, and it has been working fine as far as I know. Now there is a report that is pulling the wrong data. The report is set up as a customer letter, and most of the text is in a text box with an expression to pull in the address fields. It says...

I have attached a screenshot of the macro. I have the exact same thing for the other report and it is working well. This one is giving me the error and shutting down Access. Thank you!

I have a report for work that has 2 subreports. The report is a list of names, with the number of calls they took, the number of errors they had, and their error ratio for the week. I made a button with a macro to export the report to Excel so the numbers can be copied and pasted to other...

I moved the strRptFilter like you said and that did help the speed! The same reports were still opening for the same person multiple times, and I fixed it by making a query for my main report that only had the processor name, and grouped it so each name only showed up once. Then the actual...

Sorry, I'm kind of new to this. Is the openreport command the same thing as the report's On Open event? I have these in there based on the other thread: Private Sub Report_Close() strRptFilter = vbNullString End Sub Private Sub Report_Open(Cancel As Integer) If Len(strRptFilter) <> 0...