Search results

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...

This is a cleaned up version of a long thread with several sidebar conversations originally located at the link at the bottom of this thread. There is a lot of confusion about the use of Me. or Me! and Bang vs Dot in general. A lot of the discussion on the Internet is wrong or incomplete. The...

Do you use any third party Add-in or application for replacing/enhancing the SQL editor? This has been a long time complaint. Doing just a Web search I see there is quite a bit out there. Anyone have experience or recommendations? Anyone built one? Could be a good group project. Also a year...

This problem relates to this Thread https://www.access-programmers.co.uk/forums/threads/problem-in-designing-the-right-query-ies.324849/ I have come across something I have never seen, and do not understand. The OP has a table of soccer matches with Home Team ID, Away Team ID, Home Team Score...

A few questions have come up about Command Bars recently. https://www.access-programmers.co.uk/forums/threads/can-i-make-a-shortcut-menu-with-levels.321868/ https://www.access-programmers.co.uk/forums/threads/cascading-context-menu-in-form.322059/ I use this idea pretty frequently because I...

I have a large table and I read through the recordset. I am numbering groups of information based on the records in between the groups. I get a File Sharing Locks Exceeded. Can anyone explain this error and why? Private Sub UpdateKeyWords() Dim rs As DAO.Recordset Dim KeyWord Dim FoundWord...

As mentioned here https://www.access-programmers.co.uk/forums/threads/recommendation-for-calling-share-procedures-with-parameter.320830/ I am in the process of converting a complex Access database over to SQL Server in order to teach myself. As mentioned this is a self referencing hierarchical...

Has anyone work with this data type? Is there any tricks. I helped someone with a database that was originally just a standard date. When they converted the field to date time extended it broke a lot of things. Most date functions and formatting functions do not work with this. Things like...

This demo is in response to a recent thread on creating "custom controls" https://www.access-programmers.co.uk/forums/threads/is-it-possible-to-create-custom-controls.320996/ Unlike other development environments access does not have a way to make a user defined or custom control. However, but...

I am converting my first DB to SQL Server and teaching myself to use SQL as a backend. To teach myself as much SQL Server I am doing everything on the server side even though the database is relatively small. It is however pretty complex code since it is a self refencing hierarchical database...

Finally getting around to teaching myself SSMS. I had a query with the WHERE clause FamilyCategoryID_FK <> 18 In Access this would return all records including those that are NULL. In SS it did not include the NULL records. I am assuming that is just a difference. What is the normal why to...

I am trying to help someone create a manual CSV file. The file appears properly formatted, but it opens up as a single cell in Excel. What am I missing. See thread...