Recent content by CanuckBuck

  1. C

    Subforms on tab controls that are on tab controls

    Well, That wasn't too hard. I just converted all of the tables to local tables. Take a look at the form called NAS 02 Review Header (copy). You'll see that There's a "main" tab control that covers most of the detail section of the form. It has two tabs. On the first tab there are several tab...
  2. C

    Subforms on tab controls that are on tab controls

    Unfortunately my database is SQL Server so packaging up a copy of the Access DB will be problematic. I'll see if I can quickly whip up an MS Access based version to demonstrate it.
  3. C

    Subforms on tab controls that are on tab controls

    I just made an interesting discovery. When I place the subform directly on the Main tab it doesn't bleed through to the 2nd tab. However, when I put the subform on a tab control that's on the main tab then it does bleed through.
  4. C

    Subforms on tab controls that are on tab controls

    I checked that. I removed the tab control that contained the subform that was "bleeding through" to the 2nd tab of the main form. I put the tab control on the 1st tab of the main form again. It doesn't bleed through to the 2nd tab. I put a subform control on the newly placed "child" tab. It...
  5. C

    Subforms on tab controls that are on tab controls

    I have a scenario where I want to have a form that has a header with some information that is supplied from another form and then the details portion of the form having a tab control with two tabs. The first tab has a number of controls bound to the table that is the record source for the form...
  6. C

    Tab controls on a tab control?

    I think I know the answer to this question but I'm going to ask. Is it possible to put a tab control on a tab control? My Access file is attached. See the from called form1 I want to put tab controls called TabReviewers and TabAssessments on the tab control called TabMain. If it's not...
  7. C

    Solved Lookup lists on tables

    TheDBGuy; Thanks again for your attention on this. I think what I've discovered is that there is either no way, or no at the least, no way that I can find, to do what I want, for a couple of reasons. I can't find a way, on lookup tab of the table design form, to specify a rowsource that...
  8. C

    Solved Lookup lists on tables

    Haha! That's so funny. I was just reading this post where I think it was you who made this same reply about four years ago. I am referring to the Lookup tab in the table design view. I was hoping that by doing it there, any forms I create based on that table would have that lookup rather...
  9. C

    Solved Lookup lists on tables

    The lookup tables in my database have columns to define the effective and obsolete dates for the lookup values. If a row in the lookup table has an obsolete date it should not appear in the lookup list of tables that reference it UNLESS the referencing row is currently referring to the obsolete...
  10. C

    runtime error '-2147467259 (80004005)': ODBC-CALL failed.

    That's it! I swear I tried that but I must have had something wrong because I couldn't get it to work for me on my own. Thank you so much!
  11. C

    runtime error '-2147467259 (80004005)': ODBC-CALL failed.

    I'm in the process of converting a .adp file format database to a .accdb file format database. It's worked fine for years as a .adp but our organization is upgrading to Windows 10 and MS Access 2019 I have a bit of code which updates the caption of a tab when a user adds or deletes a record...
  12. C

    Parameter declaration order conundrum

    @The_Doc_Man; Thanks for taking the time to respond. While I've been working with Access/VBA for a while now (databases, particularly SQL Server is where I primarily work. VBA, not so much) I have to admit that I still feel like a bit of a newby and so it's entirely possible that I could be...
  13. C

    Parameter declaration order conundrum

    @MajP I don't understand it, but doing as you described appears to have resolved the problem. Thank you so much. If anyone can explain this I'd be very appreciative.
  14. C

    Parameter declaration order conundrum

    First; thank you for taking the time to read my post and respond. Site is a great resource! Here's the backstory. I'll try to keep it clear and concise. On the form (I've attached a screenshot) there is a pick-list (cboUser) of user names and a set of three radio-buttons (fraState) with the...
  15. C

    Parameter declaration order conundrum

    Hello; I've encountered a bit of a conundrum regarding the order of the declaration of parameters to a procedure. I've fixed what was broken but I want to know why it was a problem in the first place. This code works; SetRecordSource frm, frm.cboUser Sub SetRecordSource(frm As Form...
Top Bottom