Search results

  1. P

    Formatting Excel Chart from Access VBA

    Hi all, I'm trying to format an Excel chart from an Access module. My goal is to have a temporary Excel workbook that appears to show data, and I don't want to have another Excel file as a template if at all possible. As of now I can successfully add all of the required data to the excel...
  2. P

    Creating report similar to a spreadsheet

    Hi all, I'm working on a project where I'm supposed to take an excel spreadsheet and replace it's function with Access. So far I have created the form, table, and query, now I just need the report which (according to my boss) needs to mimic the existing spreadsheet. I know this is probably...
  3. P

    Creating Access Tables From Excel Spreadsheet

    Hi all, I've been given a task to take an existing Excel spreadsheet and transfer it to Access. I'm a novice in Access, and I'm having trouble designing a way to lay out the data in tables that would make sense. I know there will be plenty of headaches down the road if I don't have a good...
  4. P

    Passing "Is Not Null" as a parameter in a query

    Hi all, Hopefully someone will be able to help me with this. I've been struggling with it for a bit. I have a form which users can toggle whether they want to only see entries that has data in a certain field. Previously I have set up a separate query with a hardcoded 'Is Not Null' in the...
Top Bottom