Search results

As noted above, I said I'd report back on whether my solution worked or not. For posterity's sake this might not be as satisfying as "...it worked perfectly and here's how I did it..." I took an alternate, and simpler path. I put the "missing" controls on the form and simply set their...

Gasman; I thought of that afterward... Here it is stackoverflow.com/questions/44257145/check-if-textbox-exists-vba-using-name

I found this bit of code; Public Function ControlExists(ByVal Name As String) As Boolean 'Since not all forms have all controls there are cases 'where, before we can do a thing with a control we need 'to determine if it exists. On Error Resume Next ControlExists = Not...

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

Ah! So simple when you know how :-) Thanks so much.

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

isladogs; ...why not just use one form... Thanks for the suggestion. I'd thought about that but I felt that the logistics of moving controls about on the form so they're in the right place and visible seemed more complicated than it was worth. What I've wound up doing is building a single...

theDBguy; Thanks so much for the link to information about TempVar. It is the perfect solution for my use case. Micron; Thanks for the link to the list of reserved words. I confess it makes me feel like I should just use a random character generator for column and variable names since that...

After posting I've kept hammering away at this and the approach I'm scraping at now is to set the RowSource in the form_Load event handler. I think this will work. I'm not familiar with the TempVar technique mentioned by theDBguy. Can someone point me in the right direction?

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