Search results

  1. M

    OpenForm requesting Parameter Value

    I have a form "2017 Individual Taxes" that lists records based on a client registration form "IndivClients". The "IndivClients" form is linked to a SharePoint list so that I can synchronize it with OWA 365 and Outlook 2016. I have a command button on the "2017 Individual taxes" that is...
  2. M

    Question Linked Outlook Folder

    Hello anyone; I have used the External Data > Import & Link > More > Outlook Folder - process to link my Outlook 2013 contacts folder to an Access 2013 table. The problem is all of the e-mail fields are missing. What can I do to get those extremely important fields to link and synchronize...
  3. M

    ComboBox selection controlling checkbox availability

    It works! Hooray for CJ_London. Wow, that was a long way to go to get the answer that worked. I hope it won't take that many posts next time.
  4. M

    ComboBox selection controlling checkbox availability

    Okay; call me stupid. I'm getting an "Invalid Syntax" error message with the following expression: [SalesTaxReportingPeriod]<>"Monthly" Me.[01-JanST] = not Me.[01-JanST] Could you please just give me the entire expression as is should be written for both Rule 1 and Rule 2? Thank you.
  5. M

    ComboBox selection controlling checkbox availability

    Thanks. What's the rest of the expression? {salestaxcombobox]<>"Monthly", enabled =false (?)
  6. M

    ComboBox selection controlling checkbox availability

    Also, the code: Private Sub 01-JanST_Click() 01-JanST=not 01-JanST End Sub brings up the debugger when I click on the text box.
  7. M

    ComboBox selection controlling checkbox availability

    Sounds good to me... but then, what do I know?
  8. M

    ComboBox selection controlling checkbox availability

    The expression: if salestaxcombobox<>"monthly" then enabled =false, is not allowed in the Conditional Formatting. The closest thing I could come up with was: Iif([salestaxcombobox]<>"monthly", "enabled"=False) but that doesn't work. I can't figure out how to write the expression for changing...
  9. M

    ComboBox selection controlling checkbox availability

    1. Continuous 2. No. I use the client combobox mearly to select the name. The Sales Tax combobox separately selects "Monthly", "Quarterly" or "Annually". That selection stays in Client Bookkeeping Checklist table and nowhere else. 3. The checkboxes are labeled - "01-JanST", "02-FebST", etc...
  10. M

    ComboBox selection controlling checkbox availability

    I have a project database where I keep track of the work in progress on monthly bookkeeping for our clients. I have a form where I use a ComboBox to select the client and another ComboBox to select whether a sales tax report must be filed Monthly, Quarterly or Annually. I have 17 CheckBoxes...
  11. M

    Kevin Minkoff

    Hi all. I'm a CPA in Portland, Oregon and a novice at MS Access, although I've built a few different database applications over the last several years. I understand a lot of code, but can't write it from scratch. I normally Google how to do something, find the code, cut and paste. It works...
Top Bottom