Search results

> for the user to search records We have to use precise language. This is not searching, but filtering. > if the user enters a date range where no records are found the form displays only the form header That is unusual. Is the form's AllowAdditions property set to False? Is DataEntry set to...

Yes. Look up "Conditional Formatting" in the help file.

Dim ctrl As Button Select Case ctrl Why does this not work? Because ctrl is not initialized. It is a variable, but it does not have a value. Set ctrl = Screen.ActiveControl Now the control has a value. Note the use of "Set" because this is an object, not a simple integer or string. Then it...

George, wasn't there a recent presentation in your users group about SSMA? The OP may want to watch the recording.

As an aside: vbscript is being deprecated.

The error message means that the table NPI* does not exist, and indeed we don't see it in the Navigation Pane.

Click on "View installed updates" from this screen. Anything happen yesterday? If so, can it be uninstalled?

Plausible, but did not work. Returning Null or "" or -1 from GetSelectedItemID callback gives the same error as when using GetSelectedItemIndex: The callback "..." returned a value that could not be converted to the expected type. or The callback "..." returned an invalid value. I'm thinking of...

The first one looks plausible. I will try that. Thanks!

Sorry Colin, the Ribbon is its own thing with its own object model. There is no BeforeUpdate event. Ribbons for Access 2007 / Access 2010 – DropDown (accessribbon.de)

NW2 Dev Edition has a ribbon with a dropdown showing MRU items. I'm re-using that concept in my own app. When you drop it down and select the same item as is already selected, the Change event does not happen; no event happens whatsoever. If it was a textbox, you could Invalidate the control and...

That hints at an incompatible compile state. The official way to correct that is the /decompile switch of msaccess.exe. It also hints at you being on a newer version of Access than some of your users. That is a big no-no. And, as has already been said: you should deploy ACCDE (created on the...

You may want to review these steps to split a database: https://support.microsoft.com/en-us/office/split-an-access-database-3015ad18-a3a1-4e9c-a7f3-51b1d73498cc

Design the form, select the Date field and use Conditional Formatting to set the color based on the Weekday(Date())

New topic, new thread, is that the rule?

I typically see that when Access is still open, perhaps a hidden instance. Use Task Manager, Details tab, to kill lingering instances of MsAccess.exe.

There is no shame in saying "This is not my area of expertise, but I called around and identified a company "Ils" :-) that can setup a simple network for us. Will cost about X".

You can change the picture by changing the Picture property of the button: Me.myButton.Picture = "otherPictureInImageGallery"

And while you answer TheDocMan's excellent questions, also please use precise language. "too much time" is not precise. How many seconds?

That is certainly true for an Access BE, but not for the OP's situation: "I have an MS Access frontend linked to Sql server backend." I don't want to imply with this response it's a good idea to rely on identity values to be sequential. It is not. In modern versions of SQL Server we have the...