Recent content by saseymour

  1. S

    Query to summarize by work week

    Ok, here is my issue. I've got three fields - date_time, # of issues, issue reasons I want to summarize these by work week. So, WW....... # of issues ...............................issue reasons 1 ..........<sum of all issues for the week>..list of all reasons entered 2 ..........<sum...
  2. S

    Need report to open form then open query

    OK, I'm a dumb*ss. All of my queries are similar, and I was calling the wrong one in the report. Now works fine. :o
  3. S

    Need report to open form then open query

    Well, I kind of do that. I have a navigation form, which has several tabbed forms. On one form is a bunch of button controls. You hit the button, it launches the report, that is based on a form (combobox) that passes that criteria to the query. My problem is that I have the form that passes...
  4. S

    Need report to open form then open query

    OK, this is what I want to do: I have a table of data. One of the fields is a combobox that populates itself from another table. I want to be able to create a report that prompts the user to select the data from combobox list, then display the query results. I've read on the interwebs that in...
  5. S

    Question about Database Splitting of Access 2010

    Not sure if I should start a new post for this, but I am having a similar issue. I've split my database into a FE and BE. The BE is on a shared drive where I have given everyone RWUD privileges. I've sent copies of the FE database to people via email. Now, whenever ANYONE opens the FE...
  6. S

    Navigation form issues with buttons on subforms

    Never mind - I found a solution. I found out that the GoToRecord commands are the older / backward -compatibility function, and swapped it out for the RunMenuCommand in the form. Now the buttons work fine.
  7. S

    Navigation form issues with buttons on subforms

    BJB- Thanks for the response. I am, however, a newbie to programming in Access. If my navigation master form is called frmMaintenance and my form that I have accessible from the navigation form is called frmTurnover, is frmTurnover then the subform? Or is there another name that I have to...
  8. S

    Navigation form issues with buttons on subforms

    Hello, I am relatively new at Access 2010 use, and am building a navigation form that has a bunch of different tabs for people to use for data entry. I have a form that has buttons on the bottom of it - submit, last record, and clear. They were made on the form using the macro tools inside...
Back
Top Bottom