Search results

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...

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.

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.

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...

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...

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...

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...

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...

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...

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!

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...

@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...

@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.

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...

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...

Here's the Form_Load routine. It calls the ViewFormLoadTasks subroutine, which is in a standalone module. Private Sub Form_Load() If gcfHandleErrors Then On Error GoTo Proc_ERR '//Set the inital state & Visual cues '//when the form is first opened ViewFormLoadTasks Me Proc_End...

missinglinq; Thanks for your response. Tracing the code using the dubugger I can see that the code defined in the various event handlers e.g. Form_Load runs when the form is opened from the Nav pane. The problem is that when the code gets to the point where the value of the Option_Group is...

Hello; I'm doing some testing in preparation for a transition to Windows 10 and MS Access 2019. I've run into an odd different behavior and wonder if someone knows anything about this. In my Access (.accdb) 2010 database, which is connected to a SQL Server 2016 datatabase using linked tables...

theDBGuy; Thanks for confirming for me that I was headed in the right direction and that there wasn't some other trick that I didn't know about. After I refactored my code a bit to get it into the reusable modules (I moved all of the code from the form modules to separate modules - one for the...

I need some direction regarding form interactions. I have a view/search form that users use to either find and edit an existing record by clicking an Edit This Record button OR add a new record by clicking an Add New record. When they click either button I open a form in either Edit or Add...