Search results

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

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

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

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

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

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

I have a generic date order validation function in a code module that I'm using on a number of forms. Not all of the forms have all of the dates. Is there a way to test for the existence of a control before executing a particular line (in this case a CASE statement)? Here's my function; If...

I'm converting a solution from an Access data project (.adp file extension) to an Access database (.accdb file extension). In my .adp file I have a bit of like so; Dim con As ADODB.Connection <Some code> Set con = New Connection <Some code> In my .adb file this code works fine (has done so...

Is it possible to use Me.ControlName.Value (or Me.Name) as input to a query that supplies values for a combo box? I need to populate a combo box's list of values with values which are appropriate to the form, based on the form's name. I need to create a number (eleven) of these forms (They're...

Hello; My "Name" is CanuckBuck (here at least :-)) I've been tinkering with MS Access for a while now but I confess, I'm not very good at it. I am learning though! Always willing to learn and grow. Most of my experience is in SQL Server. I feel very comfortable there. About five years ago...