Recent content by Sanoman

I just was playing around a bit, and I think to make a button, image, whatever, ... that hyperlinks to the Excel / PdF / whatever / ... is the only way to do what you want. It's some kind of avoiding the Problem rather then solving it (if there IS an solution), but that shouldn't make a...

@dcx693: Yeah, thats what went wrong, but it wasnt set to scientific. It displayed some values correct like 966, 962 ... but 14777 he wrote as 1E+4 ... well I dont know how to do this with the format settings, but they were obviously wrong. Thanks for the fast reply!

Wow cool 8) Is solved the problem myself ... writing this thread helped me already. If anyone gets the same Problem, here's my solution. Maybe its yours too: Solution: I changed the format of Field1, so that it can display numbers of order > 3. The problem must have arrised from the fact that...

I have got an Form, lets call it Form1. It gets that Data from Query1|Dynaset(inconsistent)| and the Form looks as follows: 1st Dataset: Calculated Data | Data to type in 2nd Dataset: Calculated Data | Data to type in 3rd ... and so on. In the calculated Data part of each Dataset...

Hi! I want to sort my form with a Combo Box in another form. The form frm_1, gets its data from a query qry_1 and the combo is forms![frm_2]![combo1] - it contains all field names from qry_1 I just cant figure out how to make the qry_1 take the field name by which it should be sorted from the...

Well, I never tried to sent E-Mail to multiple users via access ... but when I look at the code it seems that strRecTo(0, 0) = "foo@foo.invalid" simply enters "foo@foo.invalid" into the "to" field. My idea would be to enter "foo@foo.invalid;foo2@...;foo3;". If this doesnt work, you could try...

it works, thanks!

I have a table with a field for yearly costs. Its type "number" - "Integer". When I type for example 185,90 access automatically rounds the value and displays 186,00. How do I prevent this?

Well, I have a table with the following fields: B# | L# | cost Where B# is a big unit, L# is a subunit and "cost" is its cost :) What I need is a big overview with ALL B#'s listed on the very left side. And above should be listed all L#'s and the cross of both gives the costs. Like this...