Search results

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

finally, managed to solve...the duplicates are due to the same query in the code builder and the report properties query. i have deleted the query in the report properties and use only the code builder to write the query.

ok, after deleteing things that are not required to be include in the file and after "Tools > Database Tools > Compact and Repair" from advise by boblarson. here is the file... (Mod1_qp.zip)

rather difficult to explain here...but i have zipped up my program (Mod_qp.zip) here so that it can be easier unserstood. basically upon user click print/ preview on the form "frmFltQpi", then report "FLT Report" will be open. upon report open, there is are 12 textboxes in the report using...

i am printing a report whose "details" section is written with code builder to search for data in a table.

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

i've created a "Function testing(ReportMth)" in the modules. then created 12 textboxes in the report and their control source set from " =testing(1)"...to " =testing(12)" respectively. after that, i created another 12 "unbound" textboxes to display the data. it works... see (report3.gif)

hi, refer to the attached (report1.jpg). how shall i design the report to print out months without data? refer to the attached (report1.jpg). how shall i design the report from the (bottom left) to make it become to the (bottom right)? thanks...

thank you. however, by changing HIDE DUPLICATES property from NO to YES only makes repeated data not to show. i want to have a group of 5 boxes for each month. if there are 12 months then there will be 5 * 12 = 60 textboxes. the report should looks something like this: Mth/Yr AE...

ok thanks, at the report textbox control source i set to "=MonthName([tblFltMonth])" , it works...

the month field of the table was initally in number format. if i change it to date/time format then the month number data will go haywire... wonder if there's anyway to convert the number to word in report design

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

thank you... however, my year is listed as number in the table how shall the syntax be for "number" instead of text?

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.

thanks alot...