Recent content by KindleFire

I have a query which feeds a report and I need to modify it or create another which will show all items which have been closed out since the last time I ran the report, which is basically every ten days. So if I opened the report today the query should mathmatically go back ten days and show...

I know the code to feed multiple tables in my database, however is it possible to feed specific fields in other databases as well. Ex. Accounting can feed a specific field in another department, say Shipping Dept., where we just might need customer ID?

Yes, I switched a few things and I get 47 recors and now I get 47 report pages? Any Ideas? no ducplicates

I looked, force new page is None and the query does not produce duplicates. Information is similiar as I am comparing prices from 2001 and 2002. ANy help?

My report is based off 1 query, I have 1 page of information to be displayed, yet my report duplicates to 96 pages and all my bound fields have duplicates hide enabled. Any possible solutions?

I have a report that draws its infor from 1 query. I only have one page of information, however it says their is 99. My labels duplicate to other pages however my data and expressions do not. I am totally perplexed. I have copied my design and inserted it into a new report and it still does...

I would like to have a button when pressed would print multiple reports, is this possible? For instance my main report have many subreports, so if I try to put to many subs on a report I get a "too many databases open error" I am thinking I can go around this by programming a button to print...

I know Access can easily round decimals, however is there a code where Access can round whole numbers---Ex. 14,880 to 14,900? Any help ?

I did it a tad different I used the ElseIF in the code builder and it works great on the on click event. Thank you

I would like to take a text box, which is bound to a table, when the value is entered, it automatically prompts another textbox, based on the entered value to produce a specific value for it. Ex. I enter "Apples" in textbox 1 then based on Apples in textbox two it automatically makes "Red"...

Is it possible to limit certain users to only print one page of a multiple page report and if so how?

I did it way different using a =SetFilt() code through the modules mode and it worked of a form....Thanks though

I am new at this and have seen this done and would like to add this to my query or mayber I am wrong. I would like to apply a filter based on text typed in by user on a query I have already established. Say qryVeh1 i have a list of vehicles, however i want to filter all license plates that...

I checked that it is a valid field, any other suggestions

I have a few rpts that work fine, then on this one I keep getting #name? errors. I have 5 subrpts I am running out of options? Any help