Search results

Each team member work on their own copy of the FE and pushing out changes just like an IDE like .NET. Each export only exports the changed objects, not the entire FE. Commits are small and often. One problem with Access is it's tendency to update all named objects with the same name if you...

I not using Visual Studio for VBA. The programing is done in the ACCDB, the add-on is used to export changes and if I need to import from GET or roll back, builds that source into a new ACCDB which is then compiled like normal. The joyfullservice add-on is not source control, GET handles that...

Maybe were are talking past each other but once I started using joyfullservice for export and build and Git for source control, I started looking at the ACCDB FE more like a DLL. I can fork the source in GET to try a something new. If a change to the production FE is need before the fork is...

If you know your FE will be placed in a constant path such as C:\YourCompanyName, you can then add the same path to your computer, configure that path as safe location. Now open regedit, go to that location in your registry and export the key. Distribute that file with your FE, then on the...

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.