Search results for query: *

I would like to format some of the textboxes to show to decimals instead of report showing whole (fix) numbers. In report it shows 234 12,23 I want 234,00 12,23 Because I dont know where textboxes witch have to be formatted will be placed I can't use standard formatting in design view. In the...

Hi, I can't set this property in report design because fields can change depending of users choice (a listbox with field names from query). I tried google but couldn't find anything about this.

I know how to manually change alias but this has to be done via VBA. I forgot to mention that label caption text will be changing from month to month so I want column name in query to capture this label caption text.

Hi, Is there a way to change caption (or alias) property of a column in a query into f.ex. Me.Label1.caption?

You are right. It is badly imported, but you now, it is sometimes easier to find workaround then to grip the real problem. 00000043,580000 is in real 43,58 and 0.8962 is 0,8962 because i'm from Europe (comma as decimal). Fortunatly I've build this code to tacle the problem: 1 variant...

Ooops. Here is another unexpected problem. Again imported table (I can't do anything about it) with a column where numbers are like 00000043,580000 and 0.8962. Val function doesn't work on both numbers neither other formatting does. If it could help numbers are related to a column.Decimal...

Val works Thanks to both of you

Hi, I have a table(imported)with numbers like 28210.933 and .371. What I want is 28.210,933 and 0,371. I have tried xpr1: CDbl(CLng([aa]*100)/100) and it works fine with the first number but I get error on .0371. Thanks

I found the answer. Me!CostPrice = Me!cboProducts.Column(4) * 0.0000001 on form is the way to get the right number format and save it to the table.

Hi, I have a table with a field witch has text property. This is a lookup field witch contains article prices like 63.4173640 or .0565000. The format I want to use is either 63.417,640 or 63417,640. Thanks

No, they are not in the same record. This code stores every country selected end the rest but the problem is that it doesnt work when it comes to save one variant of two possible. It just save the variant of the last selected item. If you know how to do this I woul appriciate you help.

Hm I'm not sure if this code can help. I will try to explain a little bit more. As I said I have a combo with four columns. ID Product PriceA PriceB There is a multiselect listbox with countries. Some countries are in Price A category, the rest in Price B cat. These are defined by If...

I have a coboboxwith a list of products and a multiselect listbox "Countries". The price of the product varies (two variants) and depends of the country being chosen. This price has its own field on form. Then it is calculated in discount and newprice field textbox. And here is the...

I have a coboboxwith a list of products and a multiselect listbox "Countries". The price of the product varies (two variations) and depends of the country being chosen. This price and has its own field on form. Then it is calculated in discount and newprice field textbox. And here is...