Search results

Hello, I recently have gotten this error message that im out of memory when trying to send a report through Outlook. I have been using this program for a few years now and periodically have seen it and my work around was to save it to my desktop and send by attaching but that defeats the purpose...

@Pat Hartman I figured it out... I took the sum off from your formula and used =IIf([IncludeInAverageDelay]=True,[SumOfNetProd],0) and made that textbox a Running Sum/Over Group and it works great. Then in the footer of the group I just used =[name of that running sum textbox] and it gave the...

SumOfNetProduct is the name from the query field. I did fix the group issue by changing the properties to Running Sum/Over Group but still getting huge numbers. No I dont see them numbers on the report... The IncludeInAverageDelay is a Yes/No data type does that make a differnce?

@Pat Hartman, ok I tried the formula and its calculatiing I think all no mater if its true or false. I used: =Sum(IIf([IncludeInAverageDelay]=True,[SumOfNetProd],0)) Ok lets use the first group in the report, the first one (blue) txt1 is showing "False" so the blue textbox next to it should...

@Pat Hartman are you saying use the [field name] instead of the control name for txt1 and txt2.

If i had a hidden textbox named txtRunningSum and its source was =If([txt1] = True, "[txt2]", "0") Then wouldn't it show the value of txt2 in txtRunningSum if txt1 was true and if false then display a zero in txtRunningSum. Then in the footer of my group i can have a texbox with...

I have a report and in the detail i have a textbox (txt1) that has a true or false value. I also have a textbox (txt2) thats value is a number. I need to have a running sum textbox (txt3) that if the value of (txt1) is true then add the (txt2) number to my running sum textbox and if its false...

@Pat Hartman I usually make my own which is way simpler than using this. Thanks fellas for the advice and help but im not going to proceed with this anymore.

I did find an example (Forget where) of someone else asking a similar question and theirs works using a macro which I hate using them. I'm going to play around with what I found to see how this works...

This built in navigation system MS has is horrible.... It looks good but in order to move around and link/open other tabs is a bear and confusing! BUT I still wanta learn it.

An image I think would be confusing to look at and after you said that I messed up on the "Where" in my first explamation. I have a frm_Main with a NavigationSubform called (NavigationSubform). The button is located on a forms subform (sfrm_Switchboard)...

I have a frm_Main with a NavigationSubform called (NavigationSubform) and the particular tab I need to open is called (NavigationButton40) and the form thats on that tab is called (frm_ProductHoldData). I have a button on another tab that I want to press and have it open the...

They are linked by HoldID, didn't realize I did that previously, I didn't need the criteria because of that. Yes it worked...... Sorry fellas!

Attached is a cut down version of the DB so names etc isn't included. The quesry in question that uses a record source criterion is sfrm_ProductHoldData/Data/Record Source. It's the field HoldID Criteria [Forms]![frm_ProductHoldData]![txtHoldID]. If I open the frm_Main and select the tab...

Hello, I have a navigation form (first time trying this) that one of my tabs has a form with a subform. When I open the navigation form and select that tab with the form/subform I get a popup that is asking for a criterion that the subform uses and is linked to its form if that makes sense...

@MajP I'm getting variable not defined on the On load events "mdlNextControl" Private Sub Form_Load() Set AvailableTabs = mdlNextControl.GetSortedTabControls(Me)

Im trying to figure out how to move to next control after a selection from a popup. I cant use setfocus or go to control because the popup is used for a few different controls and i wouldn't know what controls next

Hello, I need to automatically move to the next control in my tab order on my form using VBA. What can I use to accomplish this? Note: This isn't moving between Tabs in a Tab Control this is just moving to the next control using VBA...

Just don't forget, in order for you to show the menu's if you want to work on the DB you have to open the DB while holding the shift button and it will open in design view.

Sure.... On your main form (The first form that is opened), just put the VBA below in its on open event. Private Sub Form_Open(Cancel As Integer) DoCmd.ShowToolbar "Ribbon", acToolbarNo ' Hide ribbon End Sub Now in the same form put the code below its on close event. Private Sub...