Recent content by DaveMD

To illustrate the example based on the OP's original post, if the data from your query is this: EventID TotalSales SchoolID 154 $1000 1 134 $1200 2 155 $900 1 153 $300 1 The output from my example query in Post #10 above will be: SchoolID Last Event Sales 2nd to Last Event Sales...

This query should provide the output you are looking for. Take some time to look over it and ask any questions for further clarification. This can be readily modified if you did want to utilize an EventDate field instead of relying on the EventID to determine the two most recent events for...

Try changing objFile.Rename to: objFile.Name = wkRename2nd

As others have mentioned in this thread, you need to split the db and have each user be given their own copy of the front-end. Many of these types of errors (including DB in inconsistent state and VBA errors/VBA Project cannot be read, etc) will often go away or at least become much less...

From my experience, generative AI is a useful tool to assist with software development. If there is a well-defined contained feature or piece of functionality that you are working on developing, AI can be very useful. It can also help with brainstorming ideas. However, it does not replace the...

Thanks for the additional information. I understand you are in the early stages. As a few initial things for consideration as you move forward with this: Focus on Effectively Indexing the Table(s): SQL Server is very good with utilizing underlying table indexes when designed well with your...

Assuming you are calling @arnelgp 's helper function from the form itself: Set lst = VisibleList(Me.Form)

Just for future additional reference for the OP about how objects are handled in VBA: 1. Setting a variable of an object type (such as ListBox, Combobox, Textbox) requires the Set keyword to be used: Dim lst as ListBox Set lst = frm.lstTrans 2. Getting the selected value from the object for...

When query performance tuning, it is best to start simple to identify where the bottlenecks exist and then work your way from there. You note that you expect to have two layered views with the second view using the first view. Put that aside for now. First, focus on your first view and the...

I appreciate the work done by the presenter. This is much more than just giving the message box a more modern look. It adds useful features to the message box, such as being able to handle long messages (even will display a scrollbar and allow for sizing the message box to better fit text)...

I have the same thought as @GPGeorge and @Albert D. Kallal on this point. Too often a developer will come across some shorthand way to do things and ultimately it can cause more confusion than any benefit from the time saved from a couple less keystrokes. Some examples include leaving out the...

I agree with the others to move forward with starting with SQL Server from the start of development. You note that the project will ultimately have to migrate. I'm curious about the reasons or thought process behind that. For example, do you expect the database to grow in size significantly...

To the OP, the significant confusion appears to be because you are referring to things incorrectly. To help clarify: SSMS is not SQL Server. SSMS is one of several client tools that can be used to administer SQL Server (a relational database management system) and develop SQL Server...

Based on this thread, the OP seems to have two objectives: Help ensure customer has sufficient licenses to use the OP's application. Protect certain parts of the application logic considered to be Intellectual Property. There seems to be confusion in many areas in differentiating what might...

Great discussion in this thread and excellent illustration why you have to carefully evaluate the output of generative AI as it can come across as confident yet be very wrong. It is interesting how all three of the below critiques by Copilot demonstrate a lack of the AI understanding basic...