Recent content by ssh

  1. S

    custom formatting decimals

    I have field with decimals and it's showing correctly but I want to custom format the field, add some text. My report format is ="~" & [Decimal] but I'll got 10 or 3 instead of 1,0 or 0,3. In a table is the field showing correctly. Should be easy, I'm sorry. Thanks.
  2. S

    changing primary key

    Pat's information helped me, thanks!
  3. S

    changing primary key

    How to change primary key in main table and in subtable at once?
  4. S

    fonts and formatting

    Works somehow. But report shows only 2 first pages and then 'run-time error 2101: the setting you entered isn't valid for this property'. And fields are selectively shown in appropriate font, most fields are in default box font. Thinked it should have been easy but not.
  5. S

    fonts and formatting

    I'm managing a font database and want some kind of report. The question is how to format records with fonts found in database? All the fonts are installed to system. Thanks.
  6. S

    OutputTo encoding choices

    Access help doesn't contain any encoding values. I use OutputTo and want the file appear in Baltic. Thanks.
  7. S

    format data

    Format() in that row helped, thanks.
  8. S

    format data

    In a report there is a text box which has the following source: ="Title: " & [field1] & " sometext " & [field2] General question is how to format those fields? Thanks.
  9. S

    Generating filename using date

    Format(YourDate,"mm-dd-yy") worked. Love simple things!
  10. S

    Generating filename using date

    I'll give a try, and let you know.
  11. S

    Generating filename using date

    Towards the right way but I want 99 instead of 1999.
  12. S

    Generating filename using date

    How to generate a filename that uses date values? For example, date value is November 21, 1999 and filename should be 21-11-99. Problem was how to separate date parts. Thanks
  13. S

    minutes & seconds only

    Separate fields? Not the thing I intended. @ the present time I type 0:03:12 to get the final result as 3 mins and 12 secs. Can't omit zero (or whatever first numeric) cause the result will turn then to 3 hours and 12 mins.
  14. S

    minutes & seconds only

    How can I type minutes & seconds only into date/time field. Formatted as nn:ss and pattern as 0:00:00;*. AND here comes that annoying must-be-typed zero, I want to type mins and secs only. Thanks.
  15. S

    database gone!

    maybe u want to try the database... http://sven.future.ee/m.zip
Top Bottom