Search results

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

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...

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...

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...

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.

Hi, refer to the (record.jpg) the whole record is identified as " rst.RecordCount " ( red color box). how to identify each individual rows ( blue color box)?

i have a statement like this: Dim TempDate As Date TempDate = ReportDay & "/" & h!txtMthNum & "/" & h!txtSqnReportYear during program run time there will be a run time error '13' (type mismatch). in debug mode, the values inside are: ReportDay = 30 (correct) h!txtMthNum = 2 (correct)...

i have a report "A" page width is 6.25". i have another report "B" page width is 6.625". i tried to make the report "A" page width to be the same as "B". however, there will a pop-up message " The section width is greater than the page width, and there are no items in the additional space, so...

i have this problem in my report. it print out 1 X 24 pages instead of one page. can't find out where is the problem. how to force it to print 1 page instead?

i have drawn 31 textboxes in report "detail" section. all the 31 textboxes were intitally set to invisible. how to make the textboxes visible upon the report is open with reference to the respective month of "a control in a form"? e.g: jan to allow 31 textboxes visible in report feb to allow...

hi, i have a textbox in a form. upon a command button click, how can i allow only numbers (from 0 to 999) to be input only? null is allowed but alphabets are not allowed. or alternatively (preferable): at the textbox field, (numbers, "delete", "backspace", null) can be input into the textbox...

refer to the attached .jpg file: the report in design view, under the "Detail" section there are 5 textboxes: 1st textbox for month 2nd textbox for year 3rd textbox for AE 4th textbox for EI 5th textbox for RC during report run time, the group of 5 textboxes will multiply itself to display...

i have a field inside a table. the data in the field is in number, how can i convert the number to word inside a report? e.g: 1 (data inside a table field) convert to "Jan" upon display in a (report textbox) : : ...

hi, i have a code: Dim stDocName As String Dim f As Form Set f = Forms!frmFltQpi stDocName = "FLT Report" DoCmd.OpenReport stDocName, acPreview, , f.cboFltQpiYear basically if the value in the f.cboFltQpiYear is 2006 it should print out the rows with "2006" in the...

i have this code: If IsNull(rs![tblFltTotalJobsAE] Or rs![tblFltTotalJobsEI] Or rs![tblFltTotalJobsRC]) = False Then a = a + rs![tblFltTotalJobsAE] b = b + rs![tblFltTotalJobsEI] c = b + rs![tblFltTotalJobsRC] d = a + b + c...

hi, would appreciate if there is any codes to only allow numbers to be entered into a textbox. "backspace, delete" are also allowed, except carriage return key and spacebar. thank you.

i use the format function to display month, here is the code below: Format(MthInput, "mmmm") however, whatever MthInput value is used say 1,2,3... the month display will always either be december or january why is this so? i want it to be 1 -> january 2 -> feburary...

is it possible to have two colors for a textbox? e.g: a textbox named textbox1 upon form load the textbox1 will be filled with two colors, green at the top half and red at the bottom half