Search results

that's new to me! you can do that?

tried it and no luck. I put the formula under the O/P Recovered control source and then on the subform it's on clicked into form properties scrolled to On Current property and clicked ... and choose code the added the line Me.Refresh looks like this : Private Sub Form_Current() Me.Refresh End...

Honestly I'm just learning too. So if you find something else you would like to do with a subform post it and i'll see if I can help then; can't think of any stuff off the top of my head for now... Glad it worked:)

Yes you can I do it all the time! To hide the scroll bars you go into design view on the subform and get into the properties of the subform then set property naivgation buttons to No and record selectors to No. that should get rid of the croll bars and that bar with the arrow on it. Hope that helps

I'm working on a formula for a control source on a checkbox on a form. I have this formula =IIf([OPBalanceDue]="$0.00",[OP Recovered]=True,False) I'm trying to say if this OPBalanceDue field = $0.00 dollars then OP Recovered field/checkbox should check which would = True, and if not then...

umm? not the same; let me be more specific... The field was created in the one report as a calculated field in the report, it sums other calculated fields in the report that are counting yes answers of fields being pulled from a query with a parameter that when you run this report it wil ask...

Is it possible to pull a calculated field from one report into another report. I know you can set it to sum as =[Reports]![Levels of Access Rpt]![AccessRating] or something like that it should identify that field in that report but I get ERROR# or can you take a calculated field and get it into...

Hello, I would like to thank everyone who posted replies and suggestions with your help I got it to work and Yes; pdx_man, I was fooling with it yesterday and realized I just had to remove the filter in order to move between records...SO I guess I'm not that hopeless after all - but with all...

OKay whole new problem but related...:) It works ! I can go to record #34 and then click the button to go to the next form when I go to the next form and it is at #34 and then I go to the next form and it's on #34 working great. BUT.... say I decide I want to check #35 or I wanted to move...

Duh Me...I cleaned up the code now it seems to be working..I'll keep you posted when I set up my other buttons...I think I've almost got it! Again, THANKS for all you help so far !!! stDocName = "Accessibility Housing Unit- External Form" stLinkCriteria = "[ASRecord #] = " & Me.[ASRecord #]...

ASRecord # is an auto number/ numeric field Here's my code on the button to go to the External form: Private Sub Command63_Click() On Error GoTo Err_Command63_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Accessibility Housing Unit- External Form"...

okay so I've read the help and I've tried creating a macro with the open form function But it doesn't like the formula for the "where" statement I opened the " ... " button and put : DoCmd.OpenForm "Accessibility Housing Unit- External Form", , , "[ASRecord #] = " & Me.[ASRecord #] This...

Yes, when I move between forms I was having the last close. I had it setup on the button which you click to move between forms. ON Click: event procedure: Private Sub Command63_Click() On Error GoTo Err_Command63_Click Dim stDocName As String Dim stLinkCriteria As String...

OKay now I'm alittle confused I've got setup in the got focus for the 2nd form (External), so when I'm on record #23 on form 1 and click to go to form 2 it opens at record #23 code: on 2nd form got focus Private Sub Form_GotFocus() Me.RecordsetClone.FindFirst "[ASRecord #] =" &...

Run-Time Error '2450' Access Survey can't find the form 'Accessiblity Survey form' referred to the macro expression or Visual basic code I'm trying to go back from the 3rd form (Internal form) to the 2nd form (External form) and have the same record # I was on show upon opening the 3rd form...

Please elaboate... where is this function in the properties? I'm still learning...

I think I got it formula: =IIf([SumBathtub]<="2",0,3)+IIf([SumRollShower]<="2",0,3)+([WCAccess]) =6 WCAccess = 3 SumBathtub = 3 (true) SumRollShower = 1 (false) If one of those two is <3 I didn't want it to add the answer for that grouping. Thanks anywho

OKay new issue I went back and had a second look at you formula, I must have been on something or just tired. I corrected my entry and now it works (THANKS!). However, new problem works when going forward from one form to the next but if I want to go back to the last sheet I get a debug error...

I'm trying to combine three calculated fields into one field that will total all 3.The trick is only one of the two fields are to be included like an "or" statement What I'm trying to say is if all three calculated fields are true in one then it equals 3 and the other will equal 0 to be added...

OKay i went to the second form Accessibility Housing Unit- External Form and went into form properties and put the code under On got focus: set it as event procedure and filled out the code: Private Sub Form_GotFocus() Me.RecordsetClone.FindFirst "[Accessibility Housing Unit- External...