Recent content by dhop1990

Yea I left strFormName as strFormedName. :D At least I hope that's what you are referring to.:confused: If I move the Close to the end then it just closes the newly opened form when correct. I guess I should specify what form to close? Edit: Did it and fine now, thanks for the suggestion. I...

I have a module named modErrorHandler that has the below error handler. It save the error successfully to my table named tblLogErrors. But the the only problem is that on my On_click event to close the form still executes and then presents the error message. I had another database that I...

http://www.wolframalpha.com/input/?i=x%5E%281%2F4%29&lk=4 Everything you would ever want to know about the function. If you are going to user a Taylor, McLauren, or any other type of series you might as well go all the way and use an integral to sum the series over infinite approximations. The...

Yea I gave it a try, then removed the code completely, and it's still doing the same thing. Idk what it is but I'm going to comb over the set properties for the form and the control and try to systematically problem solve what it could be. Thanks a lot, you have been a life saver for me today...

Oh yes, sorry for the confusion. I was a little confused for some silly reason. I have the following form code on an open event Private Sub Form_Open(Cancel As Integer) DoCmd.GoToRecord , , acNewRec End Sub This is because for the form I want them to enter a new person almost all of...

I have it on an After Update event on the cboPatientSelection

Thanks RuralGuy. It's working, only breaks when I switch in to design view then back to form view without closing the form. I'll look into that more

So as of now this works before opening design view rs.FindFirst "[tblCharts].[ID] = " & Me.[cboPatientSelection] & "" when I change it to rs.FindFirst "[tblCharts].[ID] =" & Me.[cboPatientSelection] Could you perhaps hint me to the right form. I'm working on different combinations and...

So I have a form with subforms, where the main form's source is a table called tblCharts. Within this table there is a field called ID that is autonumbered. So I created a combo box that's row source is a query that selects the ID field from table charts and two other descriptive fields to...

Yea, what my program currently does is run an AutoExec module to boot a login system using frmLogin. After a successful login, it opens a SwitchBoard form (frmSwitchboard) based on which login was used. The switchboard then grants access to opening different forms, etc. I definitely should have...

Basically, I have a fully functioning frmLogin that appears when the database opens. After correctly logging in, it takes you to the appropriate switchboard. The problem is that I set autokeys to allow F1 to automatically open the switchboard, but I don't want users to hit this to bypass my...

Yea, I'll make sure to do that this time. Thanks again for all of your help. I think I just need to learn a lot more so I can be more thorough in the future. Jack Stack was amazing when I went out there last. I'm definitely gonna save the other names for future reference. I guess its like any...

Thanks a lot, it all makes sense now. I can't believe I looked over that. ha OT: K.C. bbq is great, I'm envious that you have access to that great bbq (assuming you like BBQ). Need to go back some day.

I removed all the records and put in a basic two basic dummy records, with about half of the fields filled in. Do you want me to remove unnecessary forms, as to get rid of any embedded VBA? Edit: I erased a lot of functionality to get it under 2MB, this one still has VBA in a few of its forms

Putting back in the ID's for each form/qry pops up a modal box asking me to "enter the value parameter". When I hit ok on blank the entire form loads, except for the subforms, since its not recognizing the ID value and linking it to the subforms ID value I guess. All the ID's have proper...