Search results

  1. F

    Creating Charts

    Is there a way to create charts in Access 2007 based on field values instead of table columns? There is so much going on with all the information surrounding the charts and im not sure what all of it means looking at the properties. To reup on this. I would like the graph to change based on...
  2. F

    Only half of if statement working

    What am I missing peeps. I can only get half of my "if" statement to work, and it's the "false" half..its as follows: =iif([Proceeds]>[Value],"acceptable offer","unacceptable offer)...Only the second half works...this is stated in the "control source" (properties) in an unbound box that is...
  3. F

    Why IIF statement doesn work?

    I have an Access form set up like a calculater that computes within itself and uses values from the data imported into a named table. Everything works. There are bound and unbound fields in the form that I have working together. However, I am trying to write an if statement and It is not...
  4. F

    Place Excel sheet to work as access form

    Hello all. Is this possible. I have created a "calculator" in an Excel spreadsheet with certain formulas, vba, and if statements. Is it possible to simply create a new database, implement my excel calculator into an access form and use it in there with the same values and formulas set?...I have...
  5. F

    Why wont my publish work?

    Hey folks, when I publish my form to sharepoint I get the header and footer to display, but the middle contents of the form wont show up. What am I missing? I am on a company network, it allows me to publish, I "enable the contents" and I still dont get any contents shown in the middle of the...
  6. F

    This has to be easy!

    Folks what am I missing. I have a form setup in Access (split form). When I import data into a table (which the form was made from) I would like it to populate the bottom section of my form. I would like to do this via button, so there has to be some action to call the information populated in...
  7. F

    Assign a button to duplicate records

    I would like to be able to click a button in Microsoft Access and have it find and give the option to delete records within a split form. Ex: I click the button, a prompt shows up with any duplicates found and further prompts me to delete, if no duplicates are found it a message box will...
  8. F

    Is it possible to export excel data to access when opening the file!?

    Is it possible to export data to an access database upon opening an excel file. (what I mean: Instead of getting into the file and going through the prompts to export it, can I write some code via vba to have it export to the same access database everytime once the file is clicked to open?) At...
  9. F

    Export Information to specific Cells in Excel by way of button

    Hello All. I have been rummaging through lines and lines of code and just when I think Ive got something, I hit another wall. Simply put, I need a code that allows the user to Click a button, information in a table exports to specific cells in an Excel spreadsheet, and that is it. There has to...
Back
Top Bottom