Recent content by archy321

  1. A

    Conditional formatting greater than 60 entries

    This works perfectly and I wont go over my hard limit! Thank you very much!
  2. A

    Conditional formatting greater than 60 entries

    Hello, I was entering all the requirements for my conditional formatting and found that I think that there can only be up to 50 values that can be entered into the pop up box on the report builder. Is there any way to get more values than 50, or to have the multiple factors in one line such as...
  3. A

    date()+1 not working with connected sharepoint calendar

    :banghead: why didn't i think of this! Its so simple! Would you believe i worked on researching this for two days? It worked! Thank you very very much! V/R Archy
  4. A

    date()+1 not working with connected sharepoint calendar

    Hello, I'm having a bit of a problem with what i would have thought would have been a simple query. I have connected a sharepoint calendar to access and only want to see the appointments for tomorrow. In the query criteria i put in Date()+1 but there are no results. I have tried some...
  5. A

    run time error 3061 too few parameters expected 2

    OMG that worked perfectly! Thank you so much! @theDBguy Your link doesnt work. I would really like to learn more though! V/R Archy
  6. A

    run time error 3061 too few parameters expected 2

    Would what I put in criteria look something like this? Between eval('Forms!Pagehome.Startdate') and eval('Forms!pagehome.Startdate') This would all go under the field I have for the date entry?
  7. A

    run time error 3061 too few parameters expected 2

    Would I put the eval function in the query criteria or directly into the code somewhere?
  8. A

    run time error 3061 too few parameters expected 2

    Hello, I am trying to run a query based on a start/end date on my form and have the results get pasted onto an excel template. I've done this before but without the start/end date on it, but rather a set "last month" or "current month" criteria. I THINK I have the Start/end date down as it...
  9. A

    Exporting from Access to a specific table and range in excel

    Hello, I am so sorry I did not reply sooner. I've enabled the references as instructed (Microsoft excel 16.0 object library) and used the code that you provided, but I am now getting an error. Compile error: Duplicate declaration in current scope. Private sub command25_Click() is...
  10. A

    Exporting from Access to a specific table and range in excel

    Thank you so much for answering! I'm now getting an error though: Compile error: user-defined type not defined. What did i do wrong? Private Sub command25_Click() 'Step 1: Declare your variables Dim MyDatabase As DAO.Database Dim MyQueryDef As DAO.QueryDef Dim MyRecordset As DAO.Recordset Dim...
  11. A

    Exporting from Access to a specific table and range in excel

    Hello, Im wanting to export two queries into into specific ranges into a template i've made in excel. So far i've been able to code a button on a form to take a specific query and export it into the correct field on a brand new excel sheet, but no more. I've been working on this over the past...
See more
Back
Top Bottom