Search results

  1. J

    Passing parameter value to a Form created from a Query

    I'm trying to pass a parameter to a form that was created from a query and am having trouble. Below is what I'm attempting, but it still prompts me to enter a value when the form opens. DoCmd.OpenForm "frm_AllocationList", acNormal, , , , acWindowNormal...
  2. J

    Importing Excel File with VBA without headers and skipping first 3 rows

    I'm sure this is easy, but I can't seem to find a way to do this. I'm very new to Access, so appreciate any help. Basically I want to import an excel file that doesn't have any column headings and the data starts on row 4. I already have a table with all of the column headings set in Access...
  3. J

    Calculate Percentage on Grouped and Filtered data

    Hi everybody, I'm very new to Access and I'm attempting to write an expression in a query that will calculate the % of the count of "Exchange" field (Exchange is a text field and is grouped and the count based on each unique name) where the total count is based on the filter where "Group" =...
  4. J

    New Member from Boston, MA USA

    Hi everybody. My name is Jason and I'm new to this forum. Everything I've seen here so far has been great and I'm excited to continue my MS Access learning journey here. I'm new to MS Access, but I have done a lot of MS Excel development over the past 10 years. After seeing the expanded...
Back
Top Bottom