Search results

Why not simply export the currency indicator and currency value as separate fields :confused:

No, you will need to change all references to that field name to reflect the changes you make.

It sounds as if you are using a continuous form, and have just inadvertently discovered on of their little quirks. That being that all derived fields will reflect the values held in record that currently holds focus. The attached sample demonstrates one method of getting around this, by...

The article here should have you on your way.

Have a look at the DoCmd.RunSQL method.

Both the PopUp and AutoCenter properties need to be set whilst the form is in design view. So unless you need to do this dynamically it probably easiest to set these properties whilst you are building the forms. However if you do need to do it dynamically the code using code along the lines of...

Is the login form still loaded when the Query is run? What is the criteria, you are using to pick up the User Name?

You might get some inspiration from one of the data models here. However you might find it far easier to purchase an off the shelf accounting system like QuickBooks for example.

Yes, you will just need to adapt how you use the information once it has been extracted from the list box.

Check this link for dealing with end of recordset.

Once again the confirmation number does not need to be stored. If you can construct it on the form you can construct it in a query or on a report as required, using exactly the same principal as shown by missinglinq.

If your command buttons are on the main form but refer to the sub form, be sure you are using the Correct Syntax for referring to the Sub form.

I think you need to post a copy of of your DB. Secondly this type of Constructed (calculated) result should, in most cases (including this one), should not be stored. They should simply be reconstituted at the time of display at either Form or Report level.

... and here is part of what Wiki has to say on the subject; My bolding Which is substantially different to what you are claiming. So if you believe that this is incorrect I suggest you should, create an account and correct this error. However be sure you provide plenty of citations for any...

You can't even remember what I said only a couple of posts ago; As opposed to what I actually said; So how can we be sure you remember correctly what your history books says :confused: unless you can name it and quote the passage that you are referring to.

Try; =Me.[confirmation number] = "1" & Me.[block] & Me.[building] & Me.[room]

You could use the following as the Control Source of your filed Confirmation Number; = Me.[Confirmation Number] = Me.Block & Me.Building & Me.Room

You need to fact check your sources a little more before you go posting them as truth. From here; Amongst many more.

Have fun then :D

It certainly is a curious reference :confused: I don't see the relevance of 1939 in Germany to the gun control debate.