Search results

I created the below linked thread for people to discuss how MVF fields work and if you plan to use them what you need to know. https://www.access-programmers.co.uk/forums/threads/mvf-technical-discussion-and-uses-if-you-plan-to-use-them.334422/ It was meant to be narrowly focused on that topic...

Since there is a lot of discussion now on MVF, I created this thread to provide discussion on understanding how they work, what you can do with them, and how to use them. There is plenty of discussion of the cons of MVF and what you cannot do with them, so no need to rehash that here. However...

In response to this https://www.access-programmers.co.uk/forums/threads/sorry-folks-access-world-will-not-accept-my-posts.334416/post-1970117 This thread is designed to allow people to showcase techniques they use. The example I am posting is the common checklist. This uses 4 modifications to...

This is in response to question posed by @Gasman here https://www.access-programmers.co.uk/forums/threads/the-message-class-raising-events.334082/post-1964153 @Gasman, Let me explain how I do it, you can take it or leave it but it works. Almost always when I build a custom collection that...

This demo was asked by @Mike Krailo if using an Acess Treeview could you do some of the functions of the Utility https://itemgenie.com/ He and I have been working together to make this a useable utility and demonstrate a lot of functionality using a Treeview. Some background here...

I have a query that has a subquery and works fine. It looks at a percentage in table one for a given ID and compares it to the percentages in table 2 for a given id and returns another value where the difference between the percentages is min. SELECT A.reg_number, A.epd_type...

I really liked the feature that allowed you to post a table. I would simply copy an Access table and paste. Was super helpful in describing problems/solutions and worked great. I can no longer get it to work. It looks good in edit mode but in the posted mode it looks like this with some of...

@murray83 started to demo a scrabble game here. https://www.access-programmers.co.uk/forums/threads/wordweave-scrabble-just-got-a-makeover.332897/ I had a class I have been using to demo moveable controls. I thought I could do something with that. I wanted to see if I could use some "drag and...

I have the following procedure to assign random order to records and it works. Public Sub ShuffleTileOrder() 'Update the table at beginning of game Dim i As Integer Dim rs As DAO.Recordset Dim strSql As String Randomize (CDbl(Now)) strSql = "Select rnd([Letterid]) as sort...

I kind of stop helping people on this site that post databases not developed in a Latin alphabet based database (examples Arabic, Cyrillic), because I run into too many problems that cannot be fixed without a rebuild from scratch. The problem I see often is this message when I try to modify...

In relation to this thread https://www.access-programmers.co.uk/forums/threads/boolean-values-in-table-controlled-by-list-box.331862/ I wanted to see if I could build a functional treeview using a listbox. Something that was reusable and provided real treeview capabilities 1. Multiple levels...

Recently I had to have a lot of visible fields on the form because each column was part of a detailed calculation. In order to validate the data I had to do a lot of comparison between different columns. So the datasheet needed to present a lot of columns, but that is difficult to process all...

In response to https://www.access-programmers.co.uk/forums/threads/attendance-by-days-name-of-week-and-correspond-date-month.330514/ Here is a properly designed attendance tracker with a few bells and whistles. It allows you to color code one or more attendance codes for a given dates. This...

I have an autonumber field called PersonID. In code I am trying to determine if a field is updateable. According to MS I run this test Public Sub Test() Dim Rs As DAO.Recordset Dim fld As DAO.Field Set Rs = CurrentDb.OpenRecordset("Select PersonID from tblDemoUnbound") Set fld =...

In relation to this thread https://www.access-programmers.co.uk/forums/threads/display-report-on-the-form.329947/post-1904969 I wanted to demo this. So I select a report and export to the current folder. That works fine. Then I want to display that in the web browser, and sometimes it works...

This is in relation to the demo I am doing using VBA extensibility. https://www.access-programmers.co.uk/forums/threads/how-to-find-unused-object-items.328215/post-1883495 Does anyone have code to find a whole word in text? Want to pass in a line of text and search text and return if matched...

I am running a loop in code that is generating values for inputs into a table. Based on the starting values, the code generates from 10s to maybe low thousands of records. I can either open a recordset and do individual add new calls or I can generate the sql string in vba and execute. I guess...

This is part two to this thread. https://www.access-programmers.co.uk/forums/threads/hierarchical-data-recursion-tree-views-and-a-custom-class-to-assist.309753/ However the original thread dealt more specifically with tree views. This does not. The above threads has many links to other treeview...

Here is an Find/Filter as You Type (FAYT) class. This allows you to find/filter lists of comboboxes, listboxes, and continuous forms. The class helps create the capability with a single line of code to instantiate the class. You need to import the class module. Then instantiate a FAYT...

I have a split db that has a pretty involved front end. I migrated it to Sharepoint and went fine. I had a few autonumber PKs and these got converted to Number. Because of that, I believe a lot of queries became read only. Or at least that is my first guess. How is this best handled? I plan...