Search results

  1. K

    Query feeding report/date sensitive

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

    Feeding tables in other Databases

    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?
  3. K

    Multiple duplications

    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?
  4. K

    On going Pages

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

    Print Multiple Reports

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

    Rounding Whole numbers

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

    Update Question

    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"...
  8. K

    Print Limit

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

    Macros in query?

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

    #name?

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

    Form to Multiple tables

    I have a form in which I would like to update multiple tables by the response of one field. I would like to show that same field in the fields of multiple tables. No matter how crazy this may or may not sound IS it possible and if so...Please Help....
  12. K

    Getting a Report to show after a cetain date

    I already have a switchboard starting at start up but I would like a report to show after a certain day of the year has transpired, sorta a reminder to flash on the users scree...Can anyone help?
Top Bottom