Search results

Sorry if i'm being a bit thick here but this is where I was falling down yesterday... how do I place the IIF statement in my Query pls? Using SQL view? SELECT x,y,z, IIf(IsNull([Date_Payment_Received]), Null, [Invoice_Value]) AS Paid_Value FROM XXXXX WHERE blah blah surely will fail...

Hi Gents Thanks for the replies. I'm getting closer... I've added a textbox to the detail section with:- Name=Paid_Value ControlSource=IIf(Not IsNull([Date_Payment_Received]),[Invoice_Value],0) And this displays an appropriate value in each row. I then added a textbox to the report...

HI All Acc2003 I have a report populated by a query of an Invoices table. This query lists all invoices for a given customer. The customer's ID is passed to the query via a pop-up customer-selection form. The selection form calls the query and then the report when "OK" button is clicked...

Aha... found it... obvious really.... Label_Name.Parent.Name cheers

Hi To reference a label 'owned' by a control one uses the notation below:- Control_Name.Controls.Item(0).Caption (caption being an example of a useful reference) But, how is it done the other way? So, if the label is known how is the control it (potentially) belongs to discovered? Anyone...

Hi Bob Fed up with the d*mn thing :) ... so I think I've decided to use another approach... I'm just going to test isNumeric, IsDate etc when the user submits the value... Thanks for the assistance. Cheers

Sure.... it'll take a few mins to strip out ... I'll get back asap..... thanks

Hi I pass the parms from a "parent" form to the inputbox-form via form-open-arguments and so the code to set the inputbox format resides in its form-open event.

Hi I've edited the textbox label to show intended and actual format and decimals... please see attached. Although the latter 'format' looks dodgy, i assume that's just the way Access stores it. Incidentally, I set the format and decimals thus:- Dim Format_Value As String Dim...

Apologies... jpg now attached..

Hi All WinXpPro Sp2 Access 2007 I have a custom inputbox (unbound) which is intended for users to supply various data incl Text, Integers, Doubles and Dates. In order to police the input, I format the textbox on-the-fly in VB according to the required data. This does not seem entirely...

Hi Lagbolt Your time is much appreciated... and my immediate issue of adding a new record is resolved. Since I seem to have got Transactions in a bound form working to a degree, once they are bedded in properly, I'd be happy to re-visit this thread and jot the calls and sequence of those...

Hi Thanks for looking at this and apologies for delayed reply... It was getting late here and I crashed out. 1. You are absolutely right, it's an INT and should have read List_Order= -1 ... it now does...thanks for picking that up. 2. Here's how the resources are declared:-Public...

sorry to bump this but i am utterly baffled...

Did you get an error code and/or description? Failing that, put a debug into the vba code module so that you can step through each command to see which one it's failoing at. Do both TransActions and TransActions1 have an Autonum PK field? I know when I've done copying using your described...

Hey Dutch.. thanks! ... that cheered me up! I even forgive you for Chatham 1667!! :) Guess what... a compact and repair and the Access pixies are happy with blue again.... where is Sherlock Holmes when you need him... Cheers

Hi Bob I do that in most of my routines.. I've even built some management code to permit users to use the front-end sorts and filters which are then applied using that precise method. In this case though it's not so straightforward. The RS is part of an SQL Transaction. The Rs will get...

Hi All Access 2002/2007 WinXP Pro SP2 I have a strange issue with the sorting of an ADO recordset. Background ------------- I have a form with an unlinked subform. The subform is populated by the main form using an ADO recordset and within a begintrans/endtrans. The SQL statement used to...

Hi All This is of great comfort to me.... I thought it was just my lack of Access skills. Here's my experience for anyone looking to implement similar. Three of four years ago when I started all this, I was simply trying to implement a system that gave the user the opportunity to cancel...

Hi Banana Thanks for such a comprehensive answer... it's great that you experts give up so much of your time! Very much appreciated!