Search results

OK I think I see were we are headed, the code now looks like this; But I'm getting an error message saying that "MSA can't find the field 'FRM_ItemPrice' reffered to in the expression" I've tried a couple of variations on the theme but can't work out how to let it know it's looking for a...

Thanks Rich Yes I had already realised that I need to put the argument acFormEdit in the expression (check my code), and that works fine on the main form, however it has no effect on the sub form. My question is how do I also apply that expression to the sub form within the main form? I'm sure...

Sorry on two counts :o Firstly whilst I can see what the piece of code proposed by Rich will do I'm not sure where it should go; and perhaps that has got to do with my not explaining my self properly. Or more likely my very sketchy understanding of VBA :( Secondly, I didn't mention in my...

I have a form/subform ([FRM_Item] and it's subform [FRM_ItemPrice]) set that are set as no addition no edits as the default view. what additions do I need to make to the following code to get the Subform [FRM_ItemPrice] to open in acFormEdit Mode

I don't know, it looks a bit like something out of the Jetsons :D Very spaceage in a kind of retro way :rolleyes:

I Don't understand why but the problem is with the default value. If the default value of 1 is left in [text8] then the query returns a small square :eek: rather than the value. However if the default value is change then the query works perfectly :confused: Solution remove the default value...

John can't help with your first problem; Sorry, but perhaps one of the folloiwn might help with the second question :D

Sorry should probably mention that [text8] is unbound and has a default value of 1.

I have a select querey which contains the expresion It should just pick up the value contained within [Text8] which is a number, and it was doing that earlier this evening. I've since changed something and instead of a number it is now showing a small square :confused: For the life of me I...

I always thought it was coffee and doughnuts :p

I believe that John is correct; Wikipedia amoungst other sources seem to back him at any rate!

Thanks Neil I can certainly do that (as the currency indicater is held as a number), but I was just wondering if there was a way of formating the field on the form depending on the currency the user is working in. I do have a bit of a kludge that does the trick but is not quite as eligant :o

As a continuation of this question is it possible to have the currency indictor change depending on the value of a separate field. For example if [Currency] = USD then the other field is formatted as USD #.##0,00;-USD #.##0,00 or if [Currency] = AUD then it is formatted as AUD #.##0,00;-AUD...

Thanks RV That wasn't quite the way I wanted it but It did point me in the right direction and I used ¥ #,###;-¥ #,### as there are no fractions of JPY

I'm currently setting up a data base in which I want to store price with a Japanese Yen Currency indicator. Is this possible? The Format allows for either Dollars or Euro. I like to use preferably ¥ or JPY as the currency indicator.

Thanks Pat that's done the trick. I honestly thought that I had tried that before I'd posted the question, but it must have been one of the combinations I didn't try :o

.....or is it because the form is based on a select query?

I have a continuous form, that displays in the body the results of a number of selections from a previous form. In the header I have a message that I want to either shown or hide depending on the result of the following code in the "On Current” event; The default form Label32 is for it to be...

What I needed to do was a requery the combo box from which Combo18 is cascading before requering Combo18, as the new data had obviously not yet been picked up. Problem solved :o

I have an "On Double Click" code in the second Combo box of a cascading combo box set. The code below works fine on a normal Combo Box, but for some reason the Requery statement doesn’t seem to have any effect in this instance. The data that has been entered into "FRM_DelPoint" does not appear...