Search results

  1. theDBguy

    Query to select records within a date range.

    Hi. Try using Date(), with parens, then.
  2. theDBguy

    Show dates on report filtered in query

    Hi Ron. You could try using the same parameters on your report, for example: =[StartDate] or, use a Form to ask for the dates.
  3. theDBguy

    Hello

    Hi. Welcome to AWF!
  4. theDBguy

    Hello

    Hi. Welcome to AWF!
  5. theDBguy

    Clone record to new entry with multiple selections allowed in combo box

    Hi. You're welcome. Glad we could all help. Good luck with your project.
  6. theDBguy

    Clone record to new entry with multiple selections allowed in combo box

    Nope, that should be it. Pitfalls are like you could potentially create multiple duplicate records.
  7. theDBguy

    Clone record to new entry with multiple selections allowed in combo box

    Okay, that tells me the RunCommand method should work, but you have to test it for us first.
  8. theDBguy

    How to update Query on sharepoint

    You're welcome. Let us know how it goes. Good luck!
  9. theDBguy

    Clone record to new entry with multiple selections allowed in combo box

    Hi. See the edit in my last post. If you can leave the combo and do a manual copy and paste, then you should be able to use the RunCommand method. Please give it a shot.
  10. theDBguy

    Clone record to new entry with multiple selections allowed in combo box

    Hi. Sorry if I wasn't clear in the first place. But after seeing @Cronk's post, I wonder if it will work still. Please give it a try and let us know if it does/doesn't. Thanks! Edit: On second thought, if you can "manually" copy and paste the record with the combobox, then it should work using...
  11. theDBguy

    Clone record to new entry with multiple selections allowed in combo box

    Okay, my bad. Yes, I was referring to using the RunCommand method. These are basically the code way of clicking the menu buttons on the Ribbon.
  12. theDBguy

    Getting IIf to return a null value if True

    Hi. Welcome to AWF! Try it this way: ...WHERE CaseType=1 AND ((CaseClosed Is Null AND Forms!FrmTherapyRef.OpenRefCheck=True) OR Forms!FrmTherapyRef.OpenRefCheck=False) Hope that helps...
  13. theDBguy

    Clone record to new entry with multiple selections allowed in combo box

    Hi. What's not robust about using built-in commands to do what you're trying to do with custom code?
  14. theDBguy

    How to update Query on sharepoint

    The specs I'm talking about is the number of records you have in the table. If it's less than 5000, I say go for it.
  15. theDBguy

    Clone record to new entry with multiple selections allowed in combo box

    Hi. Have you tried simply doing something like? SelectRecord CopyRecord PasteAppend
  16. theDBguy

    How to update Query on sharepoint

    Yes, if your specs fit within SharePoint's capabilities. Otherwise, no.
  17. theDBguy

    How to update Query on sharepoint

    Hi. Welcome to AWF! One way is to "keep" the data in SharePoint and simply use Access to add/edit them.
  18. theDBguy

    Hi All

    Hi Aziz. Welcome to AWF!
  19. theDBguy

    Hello - From the far South

    Hi Jason. Welcome to AWF!
  20. theDBguy

    MS Access UNION ALL conversion

    Hi. Looks like you can use INNER JOIN on CostCentre, no?
Top Bottom