Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: OAKLEYS21
  • Content: Threads
  • Order by date
  1. OAKLEYS21

    Coping records?

    Hello, I have a table called transactions in my accounting d-base. There is column heading called date, description, account, amount, and control. I post tansactions in there feilds by filling the required feilds. Sometimes I have the same transactions every month (recurring) and was wandering...
  2. OAKLEYS21

    Access DBase to Frontpage

    Hello I hope that there is a simple solution to what I want my website to do. I want to have a form on my homepage that lets the visitor select different choices ie through drop downs, check boxes ect and display the results on a different page. can anyone help me? thanks!
  3. OAKLEYS21

    #error in form?

    Hello Why do I get a #error message in the text bax with the following formula in my form? formula =sum([AMOUNT]) where AMOUNT is the field in my table called transactions the field contains both negative and positive values. That exact formula works with my report. Why is it like that for my...
  4. OAKLEYS21

    Coping records

    Hello, Is it possible to copy certain records from one table to another? Thanks.
  5. OAKLEYS21

    adding totals in report

    Hello, I really having a problem, I want to create and accounting balance sheet using the report function in access. I have set up a list of accounts that have a bunch of transactions posted to them. What I want to do is total the transactions for each account and put them in a specific...
  6. OAKLEYS21

    sumif function..

    Can someone tell me why this formula doesn't work? =Sum(IIf([AccountName],"CURRENT PORTION - INV LEASES",[DepositAmount])) Thanks
  7. OAKLEYS21

    Adding 2 text boxes?

    Hello, I want to add to "general number" (in a box called total) text boxes together in a report.When I run the report the total box is off by one digit. eg 12+13=24 where it should be 25. Any suggestions?
  8. OAKLEYS21

    Protected information

    Hello, I was wandering if there is a way to protect information in a table. I have a customer form that holds all of the information on a particular customer is there a way to lock the information making someone unable to change the info until they click the edit button? Thanks!
  9. OAKLEYS21

    Multiple reports same query

    Hello, I have several reports with sub reports that all use the same query. I want to open them all at once with the same set of criteria. I created a macro to do it except when I run the macro I have to enter the same parameter value 6 times to open the different reports at the same time...
  10. OAKLEYS21

    Multiple report using same query

    Hello, I have several reports with sub reports that all use the same query. I want to open them all at once with the same set of criteria. I created a macro to do it except when I run the macro I have to enter the same parameter value 6 times to open the different reports at the same time...
  11. OAKLEYS21

    "If" functions in reports..

    I was wandering if the "If" function can be used in reports. I want to display some text if the value in one field in the report is true. Can anyone help me thanks. This site is awesome!!
  12. OAKLEYS21

    REPORT DETAIL

    HELLO, I WAS WANDERING IF SOMEONE CAN HELP WITH MY REPORT. I WANT TO MAKE A CUSTOM REPORT THAT ABOUT 8 PAGES LONG. THE PROBLEM I'M HAVING IS THAT IN THE DESIGN VIEW UNDER THE DETAIL BAND, I RAN OUT OF ROOM IT ONLY WENT TO 22". HOW DO I MAKE ANOTHER PAGE OR MAKE THE SPACE UNDER THE DETAIL BAND...

Part and Inventory Search

Back
Top