Search results

  1. C

    mdw file

    I have been working on a database for quite some time but it had its own mdw file. I took a leave from work and upon my return, and opening of my file, I am getting the following: You do not have the necessary permissions to use the E:CFP_Projects/AccessDBA/kpi_reporting.mdb object. Have your...
  2. C

    Graphs as Reports

    Does anyone have a site dedicated to helping people create the charts in Access? I can do one - but it is harder than heck to format and I am wondering if there aren't some nice tips and tricks to make formatting easier..... Thanks...
  3. C

    Charts

    Is there any easy way of making the chart fit the page without having to stretch it? I do not want a pivot chart either - must reside in access to get on reporting screen. thanks in advance cfp
  4. C

    Creating Reporting Form

    alright - it is official call me stupid :-) I got it to work - my form was set to not allow edits LOL so of course it can't allow anyone to update a combo box - it's working great! Thank you all for your time, energy and patience and for not banning me for stupid question... cfp
  5. C

    Creating Reporting Form

    Update.... is it working yet - no BUT getting closer - my combo box will list all reports that are in the current project BUT it will not let me click and then put the text into the combo box - I get the list, but I cannot make it populate the actual combo box... any suggestions? cfp
  6. C

    Creating Reporting Form

    as an FYI this is a screen shot of what I"m getting.... when I click the drop down arror initially - I get the following error. Like it doesn't want my report name.... I know it's there, I can view the report. *sigh* This is just a word screenshot....
  7. C

    Creating Reporting Form

    well - I am still lacking - but thank you all for trying. I guess it's just not going to happen for me. thanks though - you all are very helpful
  8. C

    Creating Reporting Form

    Did I ever mention how wonderful you guys are hehehe Sheesh - gonna put it into affect now - so.... it would be helpful for me to name my report something less......... ugly? Boy - where would I be without you guys - oh.... report selection-less THANK YOU AGAIN! cfp
  9. C

    Creating Reporting Form

    so.... I would wipe out my form completely - and create this code instead?... I'm normally not this dense.. my apologies.
  10. C

    Creating Reporting Form

    For my combo box I have a table that feeds what drops down - the table includes the actual name of the report and then the description I want the user to see.... ack - I am a pest LOL I create the report then add it to the tblReports table so it will show in my dropdown - not a refresh issue...
  11. C

    Creating Reporting Form

    well..... now I'm becoming a pest.... I set up the print button and all seemed to work till I added a report. I added it to my table and it did show on my combo box list - selected it..... and when I hit print, I got the other report. any suggestions as to what I did wrong?
  12. C

    Creating Reporting Form

    This is great - thank you both very much Boy - it has been a long time since I sat through a VB class - long time ago in a galaxy very far away (and I don't think I was awake for half of it LOL) thanks again! crystal
  13. C

    Selecting for Combo Box

    thank you!
  14. C

    Creating Reporting Form

    Yes.. I know VB but I'm rusty.... I have my combo box but when I do my print button, I do not know the command on how to set the value of the report to print to that of what was selected in the combo box. If they choose report 4 from list, and I hit print - how do I make the print button...
  15. C

    Selecting for Combo Box

    I am needing to know the SELECT command that would return all reports listed in my database.... for a table, I want a drop down box that will allow me to select the reports that I have available. thanks cfp
  16. C

    Creating Reporting Form

    I have my database built - ready to begin the reports. What I want to do is have a report screen (will not be needing criteria) that has a drop down list box that will show all reports - from that list the person can pick a report and then either print or preview it. I also want an option that...
  17. C

    ODBC Question

    No error number is displayed and the table is not static. It is an ODBC database pulled at the end of every month showing all transactions within that month. no one goes into this and edits any records. Thanks for the help - I am having no luck with any contacts here or with *fiddling* with it.
  18. C

    ODBC Question

    I am trying to run a query from a linked ODBC table. It is a very large table (all transactions for a specified month). Importing the table is not an option because it is so large. I get the table linked and can view it fine as a table. When I go to create a query, I set it up and try to run it...
  19. C

    Record Count

    Maybe you could bypass with with an iif statement in the query then sum the record.. it would look something like this in the query: countfield: iif(idnum<>0,1,0) THEN in the report do a sum for countfield. just my way around.
  20. C

    Record Source

    Is there anyway to have a report have 2 record sources? I have a report that has 2 subreports within the detail and I am needing to add fields for totals in each subreport but because the main report can only have 1 record source, I get a request for a parameter. How can I do this without...
Back
Top Bottom