Recent content by Cantthinkofone

  1. C

    Passing subform value to new form

    editing whoop whoop it works it works!!! It was a pesky . not ! Thanks for your help
  2. C

    Using Microsoft Access with Sharepoint lists

    HI there - well atleast its an expected failure. I thought I broke it lol! Yes, when I hove over the tables, the string does appear, some open fine when clicked, others say table not found, even though I see the table on the sp site. Hmm, Ok, I'll look at this some more and reach out to our...
  3. C

    Using Microsoft Access with Sharepoint lists

    here is one of the error messages I receive when using the db with the tables on sp 'The Record source name... specified on this form or report does not exist. It may have been deleted or renamed or exists in a different database. ' even though I linked it and kept the name the same, the...
  4. C

    Passing subform value to new form

    hmm, I"ll have to research subform containers, that's a new term for me. I have the parent {frm Work Queue}, with a subfrm sbfrmRequest, which contains a control OrderNumber. so based on your example, I should reference the Where = [OrderNumber]=Forms![frm Work...
  5. C

    Using Microsoft Access with Sharepoint lists

    I've linked the tables to sp, but a few hiccups with the db locating the tables. I'll keep working at it. Thanks for your help.
  6. C

    Passing subform value to new form

    I have a 2016 access db with a form which contains a subform. The parent form has a combobox to select which staff person I want to query/filter the data and show in the subform. This works great. In the subform, I have an 'on dbl click' event on the order number to open an 'Order Details'...
  7. C

    Using Microsoft Access with Sharepoint lists

    I would love to move to SQL server, business is in process now of migration. SQL is on tight tight tight lockdown by BI dept. I have to prove my mettle with sp first before this db can be considered for SQL.
  8. C

    Using Microsoft Access with Sharepoint lists

    Ok, I'll give that a try and report back. Give me a few minutes.... Thanks. I have another db question about passing value from subform to another form, should I start a new thread?
  9. C

    Using Microsoft Access with Sharepoint lists

    Hello- Thank you for responding. From earlier threads I see you are in Napoli, I am in Maryland so I don't believe our timezones are compatible, I apologize in advance if I am interrupting your night. I have an Access 2016 db that when I converted the tables to link to a sharepoint site, it...
  10. C

    Using Microsoft Access with Sharepoint lists

    Bumping this to the top. I too am working a similar Access/SharePoint db set-up and would like follow-up with anyone who is using this sort of arrangement thank you
  11. C

    How I Use Access User-Level Security by Jack MacDonald

    I second the previous poster's comment..... the link above no longer active. Any chance this information is posted elsewhere? Thanks
  12. C

    Cascading listbox error

    Thanks to everyone on the thread. Recap: I'm trying to get a cascading listbox Region value to save to the underlying table when the cboLocation is chosen. I tried the recommended set value on AfterUpdate. I've pulled up this tutorial from pbaldy (see below) however, I still can't get the...
  13. C

    Cascading listbox error

    Hi there. Yes, these fields would be static.
  14. C

    Cascading listbox error

    "They may not have worked as textboxes before but they aren't fully working for you now either. " Lol!, ok you got me there. Very true. I will try your suggestion to code After update. Thanks
  15. C

    Cascading listbox error

    Re: listboxes that look like textboxes. You are correct, the majority data entry are txtboxes. I cascaded the Region and Division fields as listbox to only show one value, as 1:1 relation to the cboOrderBranch. I couldn't get the function I wanted with a textbox the Region Listbox Row...
Top Bottom