Search results

OK, I have a form, ISForms, that I'm really using as a switchboard. The form has to pieces of selectable criteria: BA & SRType. You select from combo boxes the criteria for each, then click the form you want and, based on your criteria, a specific form (SRType) that w/ the records of the...

Fixed! Sort of... basically, made the form be edit only (which is how it'll be used), so since its not looking to add any new forms, there is never the chance to generate the error.... Anyway... :)

1 problem with that. :( If there are no records for that subform, I get "run-time error 2015, you can't get to the specified record".... Do I need an "if" statement for those circumstances where this is no record?

Got it! I put the DoCmd as a sub of the event of entering the subform! YEAH! --- Private Sub ISIF_Comment_sub_Enter() DoCmd.GoToRecord , , acLast End Sub ---

That DoCmd worked great! Thanks. New problem. :) The form I want to start w/ #6, I use as a subform. So, when I'm in masterrecord 1, subrecord 6, then go to masterrecord 2, the subrecord(form) seems to ignore the DoCmd and the subrecord(form) for the next masterrecord starts w/ 1.... Does...

Oh, here's another one for you, David. The "Navigation Buttons", say my form returns 6 matches, so the NB numbers 1 thru 6, and starts with 1. Anyway to get it to start w/ 6 and go down to 1?

David, worked like a charm. :) You kick *ss my friend! Do you take names too? lol Anyway, I'd say "take you to a Royals game" but I know you'd see that as a punishment, rather than a reward. :)

I tried and didn't get very far.... Unfortunately, that stuff is hard reading for me, so maybe I did find the right instructions, but didn't get it... Anyway, here's the code I'm trying to change so that the called form opens in add mode: ----- Private Sub ISIFAdd_Click() On Error GoTo...

w00t!!! David you are so teh win! Sorry, if you don't play online games much that'll seem stupid, but its a compliment. :) Since, yet again, you have so ably helped me, be prepared to be further exploited! Ready? All that you said was helpful and your explanations even anticipated some...

This may help. Go into the combo box properties, then go to "format", the bottom property is "text align" and you should be able to set it there.

OK, instead of using a switchboard to for the user interface of my DB, I'd like to use a form w/ command buttons that then take the user to the areas they need to go to. I'm doing this because I don't like the default settings of the switchboard and find it difficult to make changes to it...

*bump* :) Can anyone else give me some advice here? Have I come upon an Access limitation?

SUCCESS SWEET SUCCESS!! :) OK, the BA thing was right as I did it and as you explained it. One thing I've learned (as this is my first db I'm doing from scratch) but can't fix now (as I'm too far in) is to NOT give things the same name. "BA" is the name of that field in the query, on the...

OK, I just tried it w/ [Employeename] and it gave me a prompt to put in an employee name. I then entered an employee name, the report did come up, but had an "error".... grrr.. ! Man, its like sooo close! I can taste it which is refreshing, but since its not working, all I taste is the sand...

Ah, ok, yes, you have the correct assumption for what BA is. :) And, just to clarify, the pop-up form, ISIF Report Criteria, calls the query, ISIFReport2, which creates the report, ISIF Report 2. I think the problem come down to this... What are you assuming [Employeename] is? I realize I...

1 steps forward 1 step back... OK, I made the changes you suggested, including deleting the line in my query. And, yeah, when I leave the employee blank it returns all of them. But now when I enter an employee name I get nothing. I think the problem lies w/ deleting that lne from my...

ok, the "if" error was due to some garbage in the properties of the form itself and is fixed. So, the query does run and doesn't bomb, but it doesn't return anything but a blank report. Now, if I close the report, and I see the form again, the "*" is populated in the employee field...

ok this is what I changed it to: ----------Private Sub RunReport_Click() On Error GoTo Err_RunReport_Click Dim stDocName As String stDocName = "ISIF Report 2a" If IsNull(Forms![ISIF Report Criteria].BA) Then Forms![ISIF Report Criteria].BA = "*" End If...

Yeah, the form that calls the query is actually called "ISIF Report Criteria", I called it "callreport1" here to give it a more generic/intuitive name for whoever was might be reading. :) And "ISIF Report 2a" is the query. I'll give it a shot after lunch.

The button has an "event procedure" (this is what you mean by VBA Code?). When clicked, yes, it runs the query that produces the report. Here's the code for it: _________________________ Private Sub RunReport_Click() On Error GoTo Err_RunReport_Click Dim stDocName As String...