Search results

Since you stated “ This gap gets taller or shorter as I change the height of the window“, it seems you are not using tabbed forms. As you change the height, which section do you think should change?

I was thinking it might since I am a member. That forum isn’t very active (like many others) but has some decent resources.

There was no mention of “face book”. The file I mentioned is stored in a form similar to this one.

Bill Mosca has a file hosted at https://groups.io/g/MSAccessProfessionals/filessearch?p=name%2C%2C%2C20%2C1%2C0%2C0&q=bypass. "Database Properties setter (open source version). Can be used to change properties of an MDB or MDE without opening the target database. Set such properties as...

I haven’t been a member here as long as most but the name has only quality feelings. Maybe a lesson to all that life is precious and often cut too short. I recall the 2011 memorial service for Excel MVP Nate Oliver (age 35) where his father recognized Nate’s many contributions to tech...

This is a simple demo of creating a calculated value in a subform recordsource that returns one of two values. In this case either 0 or 1. This value is used to identify which copy of the subform to display the record (either left or right). The Northwind Categories and Products table are used...

I have also used two copies of the same subform and added a calculated column in the subform’s recordsource that returns either a 1 or a 2. Then I add two text boxes on the main form with control sources of: =1 =2 I use these two text boxes as the Link Master from the main form and the...

Define “good”. Are there any features you are looking for or just a date picker?

The record source of the subform should be tblContact_Categories with a single combo box bound to the CategoryTypeID field which uses tblCategoryTypes as its Row Source. Set the link master and child fields to the ContactID and make sure the form allows additions and updates.

I don’t believe Access supports CROSS APPLY.

Yes, I meant "shouldn't be too difficult". I think the only pattern required is the grouping of three fields with the condition, causality, and relatedness. Possible code but it could be much more generic by using function arguments to pass number of repeating fields and field names. Public...

I agree with @June7 and would write code to create the union query in VBA. This should be too difficult based on the proscribed table structure with a limited number of repeating columns.

When I worked for a large company, users could make changes to HKCU (user) but not HKLM (local machine). This allowed me to create open app scripts that modified most everything we needed.

In three decades of using MS Access, I don’t recall ever using last. I always find the max of a date field value in a query to identify the most recent.

I would try running a script that sets folders as trusted prior to running the app.

I think he “gets it” but is at a level of OCD (Obsessively Controlled Developing) below the bar set by many here.

As this thread clearly exposes, seasoned developers find “… but in this case it will be ok” incomprehensible 😜

You will return all dates where Cleared is False. If that is not what you want, you may need to replace the Or with And.

I would use: Select * from SomeTable where ContactID = (Select Max(ContactID) From SomeTable)

Backed up. Now, if I can just remember the password in the event I seriously mess up my face.