Search results

Hi CJ many thanks (Once again) however, the form I want to open is opening, but the combobox I need populated remains blank... I've tried... DoCmd.OpenForm "frmMain", , , "[cboAccountSelect]= '" & Me.Account & "'" AND DoCmd.OpenForm "frmMain", , , "[cboAccountSelect]= '" & Me.Account.Value &...

ok, I know this has been covered before, but I'm not sure how to word it in the search forums... I have a main form. It's only contents is an unbound combobox, and it's used to filter down (via a query) the details in it's sub form (I'm using it to load different account information, rather...

Re: Combobox For "This Week" or "This Month" etc to populate 2 text boxes for filter ok, So here's what I've got.. and all works perfectly.. however, I'll play around with last quarter, 1st quarter later.. But.. I have far too many Ifs and elses and End ifs... It looks untidy Would "Case" be...

Combobox For "This Week" or "This Month" etc to populate 2 text boxes for filter OR. I'm asking for some -more- help with a problem I have and reach out to the guru's of this forum... As per the attached I have a very simple set up (so I thought) of a combo box and two text boxes. I'd like to...

Sorted. It was a case of reassigning the subforms recordsource at the end of the "OnClick" and the filter string has gone. Me.Subform.Form.RecordSource = "your Table or QueryHere" Me.Subform.Form.Requery

Awesome Thanks guys for your super fast response... CJ , you're going to have to start charging me a fee soon!!;) However, the filter is still there.. the oddest thing. I've even tried requiring the subform, refreshing it after the 'filter ="' and so on. I think I may have omitted that the...

I'm know I'm not going stupid here. I'm filtering a sub form in datasheet using an option group frame, and the on click does exactly what I want it to do. Everything works splendidly. However, Once I'm done filtering, I can either set the filter to all ... Case 1...

Worked like a treat! Never again will I use Calculated Fields in a table. Thanks for the advice! Much appreciated! Have a beer!

CJ! If I could buy you a beer. I would! You Sir (or Madame for that matter) are awesome. I thought I'd have to reference the [debit] and [credit] fields that are different parts of the query in relation to the tables they sit in! had no idea "[credit]-[debit]" from the same table was that...

CJ / the DOC Hi.

Ok, so I need to store a calculated field in a table in order to show a running sum in queries (the table is based on a [Credit]-[Debit] = [£###.##]'s scenario as I'm not sure how this will work in a running total query) both the Credit and Debit fields in the table are set to "Currency" with a...

Jason - that's not good. How are you turning it off..? via the controller or the actual console? Once a week, just turn it off holding the "X" on the console for ten seconds. This'll do a memory dump, and reboot it fresh. That should keep everything in tip top condition. I had a similar...

Hi guys.. I have a main form which does nothing except filter subforms through a cbo. On the main form are two subforms. One shows top line data, the other shows a breakdown of the top line data, and are linked by an unbound textbox (it's how it works, and does so perfectly) I'm running an...

Janr.. Thanks for that. I'd totally forgot to write the Dim. Fresh pair of eyes and all that.

Hi Guys.. I currently use this code to trigger a not in list event, ask the user if they want to add it to the respective table, and then add it. I'd like to be able to add the text in the combo box that triggers the event to show up in the msgbox. any ideas? highlighted in red is where I...

Hi spike & CJ. Super thanks for responding so quick! Both should always be equal. If not, then throw me an error message to let me know. They are both Currency type, and to be perfectly honest, I thought it would be a case of saying if A does not equal B then it will not continue until...

Quick one... I have two subforms. The first is a summary form and carries a "TotalCredit" field across to another subform in Datasheet mode where the total credit is being broken down to individual postings, giving me a breakdown of the "TotalCredit" on the first form. These totals should...

Slight quandary... I'm using a very simple unbound textbox on a very simple form, with the following Expression to find me data in a query and sum the last 30 days, based on a combo-box on my form... Only thing is, it's showing me only the data from the last 30 days...regardless of the value...

Firstly - Happy New Year to All! My form layout is; Main form, with sub-form datasheet based on a query (I can't have a split form as this does not work for me) I'm using the following code in the subforms Onclick event to display the corresponding sub-form record in the main-form... Private...

Sometimes, it's the simplest of things you're looking at, but never see! Thanks guys. Both do good!!