Recent content by ariel81

Hi, I have developed a program using MS Access 2003. I would like to know is it possible to use the program in open office 2.0/2.4 enviroment? How do i convert the program to be able to use in Open office 2.0/2.4 if it is necessary? Regards, ariel81

namliam gave me the link is useful. here is another problem, how can i make it auto-run formA everytime instead of the usual "sercurity warning" pop-up click "ok" and then manual double-click on the formA in the objects in order to run it.

hi, i have tried convert .db file into .mde file. however, the .mde format still allows user to be in the ms access enviroment although prevent editing of the form and source code. how can i convert the .db file into a format whereby the ms access enviroment is not shown and also not...

it works... however if there are no records found...it gives a debug msg in the code builder window...how do i avoid tat debug msg? what is the reason to use rs.moveLast and rs.MoveFirst ? if i don't use them, will all of my records in the table column be scanned thru from the 1st record to...

thanks, here is another problem...lets say i have two records (dates) in the table that falls within the search 'start' and 'end' date. the rs.RecordCount should have the value 2 because it founds two records within the search range. however i tried to display the rs.RecordCount value in a...

Hi, i have a START date "DD/MM/YYYY" <-- with 3 combo boxes "cboStartDD", "cboStartMM", "cboStartYYYY". i have a END date "DD/MM/YYYY" <-- with 3 combo boxes "cboEndDD", "cboEndMM", "cboEndYYYY". i have a Search command buttom. upon a "search" button is click, how can i search the dates...

Hi, i have a START date "DD/MM/YYYY" <-- with 3 combo boxes "cboStartDD", "cboStartMM", "cboStartYYYY". i have a END date "DD/MM/YYYY" <-- with 3 combo boxes "cboEndDD", "cboEndMM", "cboEndYYYY". i have a Search command buttom. upon a "search" button is click, how can i search the dates...

my mistake, i created the textbox wrongly...i drew labels insteat of textboxes...thanks...

doesn't worked...

it doesn't worked... it displayed saturday,december 30,1899 12:00:00 AM the time doesn't run...

how to make use of the now() function for the time to work as a clock? e.g: instead of showing the time during form load...it works as a clock ( time is running).

is there any function in access whereby i can have real-time date and time displays on a form? any sample programs i can find? thank you.

i have a table with fields "[DATE OF BIRTH]", "age", "temp-age" i have a query that calculate the age: example; the query will get user to input the "temp-age" and upon "temp-age" is input and "ok" on the query, it will calculate a person's age and store the value inside table "age". however...

thanks......

hi, i have drawn a "line1" in a report "height" is 3.75". i use the code builder to change the height of line1 using the statement line1.height = 2 however instead of shortening line1 to 2", the line disappears during run-time. how to change the line1 height using code builder? thank you.