Recent content by lerwane

i've turned it off already, but there's still a problem. currently the width of the report that should be printed is 7". do i have to edit everything? meaning the margin, distances of each textbox, etc...? or is this another way to configure it in easieast way? plesase help thanks.

how will i turn-off the AutoName...?

hi everyone! can anybody help me? currently the database i am debugging has been set in long size paper in printing. now, i want to print it in an A4 size, but when i changed the setup in printing, or configuring the printing preferences it didn't work. what will i do? please help

hi everyone! can anybody help me? currently the database i am debugging has been set in long size paper in printing. now, i want to print it in an A4 size, but when i changed the setup in printing, or configuring the printing preferences it didn't work. what will i do? please help

Yes, I used the DateDiff function in getting the interval. I have several records for every user that's why I wanted to get the sum of all intervals. But now, its working. I used the functions that you gave. Thanks Mile :)

this is the scenario: in qryDate, it shows like this way: id name byear bmos 1 sara 2 10 1 sara 2 5 2 jay 1 3 .... then the next thing to do is I want to get the total years for every user. what i did is, in my report the field for...

I have a query which computes for date interval. Then in the report, I used the function SUM basing from the query to show the total_years and total_months. The problem now is in total_months, because if it exceeds or equal to 12, the total_years should increase by one (1) then the...

thanks wayne

yah i did that already. my question now is, what would be the code or script that i will put in opening the record? isn't it there's an "Event Procedure" to be put then there should be a code for opening the report? what would it be? please help!

is it possible to call the query option? meaning in printing the report, instead of using TABLE, im going to get the data from QUERY. what would be the sql statement then? please help! Thanks

:) i was able to fix it out, using function directly in the report. Thanks then. :)

i have a report RPTotal, then there are 2 fields to be printed out TYear and TMos. currently if user1 has 3 records, all of them are printed out, what i want is to show only one record because it's all the same. e.g if there's 3 records instead of printing out: TYear: 4 TMos...

i have a query w/ 2 fields(by_year, by_months), and i want to get the sum all entries in each field of every user. select query.by_year, query.by_mos where userID = .... is it possible to make it in a query design automatically? or should i make a function for it? please help. thanks

can anybody help me? i have an existing database then in the main report i deleted one subform then changed it with the new subform. But when i tried to generate the report (the printout), the margin now changed, but i didn't change anything with regards to format ... i just follow the width of...

thanks thanks Tay! It worked!!! :)