Search results

I don't understand why you are treating errors in an Access module any different then any other environment. If I make a breaking change in a c# class, any other class importing and using the class will have a problem. The problem with Access and VBA is the limited IDE and the resulting...

I have a ACCDB FE using runtime on about 35 workstations with out problem. All function have error trapping an logging. If you install the FE on the same path on all computers, you can export the section of your registry with that safe path then merge on each workstation, (requires admin rights...

All development environments have the same problem if you release without proper testing. You can get daily example on the Daily WTF site. Moving to source control made it much easer to track changes and undo mistakes. I need to get much better at Git but the basic feature I use are very...

With an add-on like joyfullservice which exports each Access object to a text file, the single container is not an issue. A new ACCDB FE is generated with each build much like you would do with a .NET project. The process is develop in your copy of the FE, export the changes to your repository...

Eliminate the send keys by setting Response = acDataErrContinue, Undo the input, then move the focus to a different control. In this case I used one of the controls on my test form cbAdRemove, obviously you would use a different control. Private Sub sku_NotInList(NewData As String, Response As...

I would also add a Complaint table. The OP stated that the service request for 1 machine may come from multiple customers.

Using Git Hub, Bob is working on a fork as are you, there is no checkout. The changes are merged back into the main after testing and can always be rolled back. I am working with a large FE, the add-in exported the original in a matter of minutes, changes take seconds. After working with...

Going 3rd party with source control solves the multiple developers problem. I have been using joyfullservice (Access add-in) combined with Tortoise Git (Window Add-in) and Git Hub. I can export changes form the FE then commit to Git Hub. Changes can be merged in Git Hub and then downloaded and...

The day of your presentation I was trying to add a 2 command to my multiselect treeview form. First to show only those nodes with the check box checked, then back to show all nodes. Microsoft common controls treeview controls have a visible property that can be set true or false, making it look...

"But you can not hide the server name, and database in connection string. Can you?" You can't hide the server with or without Access. The server handles data security, not the FE. BTW, I know of at least 1 very large account / payroll / buisness system with a base option of a file based db...

Yes you can easly read the connection string, so don't store login information in your connection strings.

Any chance LDOW is something that is not a date when you execute the query. Being as LDOW is a date use # instead of quotes.Set rs = CurrentDb.OpenRecordset("SELECT TOP 1 LDOW FROM qryWeeklyForecast WHERE LDOW=#" & LDOW & "#;", dbOpenSnapshot)

After some trial and error and a little help from Copilot, I added the ability to show only selected options and then restore the tree to it's original state. Hiding involves saving of the tree to a collection, deleting the un-checked nodes then restoring it from that collection to show all. I...

Attached is a sample database that emulates MVF using MS common control Tree Control "MVF_Control_Tree". It works in both x32 and x64 bit Access. It has the added benefit of supporting multiple levels of grouping of the available selections. The sample "frmUsers" opens when you open the...

The 4 tables used for selections look like the following. The queries for the record sets passed to the tree are as follows ' Available Selections Recordset Set AvailSelections _ = CurrentDb.OpenRecordset( _ "SELECT...

Microsoft has released a x64 version of common controlls that also works in x32 without change. The only part of the tree saved to user selections are the leafs i.e. no child nodes "M1", the rest are for grouping.

Yes, I am using 64-bit Access it works in 32bit without change. The treeview control is filled the same as the original forms in-memory recordset. The data is written back to the user selections table when the ok button is clicked by going though the tree looking for newly checked and un-checked...

There is no reason to store the data as a delimited list. Store it normalized and display it as delimited text. I started with MajP's sample db and replace the list with a treeview control. The sample form has 2 "MVF", controls displaying the selections as a list and the other fill's the combo...

I was stepping though your code. In clsControlLayout you are setting PixelsNamPaneHeight in the section commented for getting the tab stripe height. The set it again with out referencing the 1st value in the section for navigation pane. Is this an error or am I missing something?

NauticalGent, the good news about turning 60 is that in only 2 years you can purchase a lifetime national park pass:unsure: