Search results

Getting error that says the ORs part is too long for the query builder. This is the only way I know how to do it. Can someone give me an idea? SELECT DISTINCT dbo_SJMPatientNames.PatLastName, dbo_SJMPatientNames.PatFirstName, Step4CombineBillingsAndPayments.Histno...

No, not trying to move calculated values, but I sort of painted myself into a corner and ended up with 2 subforms on my mainform against my better judgement. Now that I am at this point, I want to make it work and I plan on streamlining my process before rolling it out to the users. I am off...

Hi All, I have 2 subforms on my mainform. I need to get data from a control on subform 2 over to subform1. Can someone help me with the syntax? Mainform name: frm_restitiutionDataEntry Subform1 (where I want the data to appear): sfrm_restitutionDetails control name: decRestAmount...

rammudali, That was exactly what I needed! Thank you so much! Mark

Hi All, You have been a great help to this novice in the past, and I am again asking for some help. I have 2 tables, the first is CASEDATA and the second CODES contains a list of codes. The CodeNumber is the joined field between the tables. In my form, I have a Combo Box that lists the...

The exit IF in the loop was the answer! I added the invisible box on the form as you suggested and updated that variable as it went through. Thanks so much!

I tried your suggestion and when I did that I never reached a point where the max attempts message showed. The real problem that I have here is not the logic of attempts. It is more that I never have an opportunity to refocus on the password field to enter another password. The loop cycles...

Hi everyone, I am really stumped here and I am not sure how to make this work. If my password is correct, it works fine. If the password is incorrect, it shows the MsgBox and then cycles through the loop until the count is 4 and exits. I can not set it to allow me to re-enter another...

Thanks so much for the help! This is right on, and I do appreciate the tips about storing the case numbers in a separate table. Eventhough this database will not have a lot of users, it is better to be safe than sorry down the road. Thanks again, Mark

I have built a database to store case files. The case number is automatically assigned starting at number 1 on January 1. I use this code to get my next sequential case number when I click to save the record: Me!txtCASE_NUMBER = DMax("CASE_NUMBER", "tblCaseDetail") + 1 MsgBox "Your Case...

This is my first post to the forum. This group has been extremely helpful and I want to first thank you all for your good work! I have been using a sample of Allen Browne's Search Form to do a search form of my own. If anyone has time to look at the example at...