As from the comments, this is what I’m thinking of when I read your description: Since the UpcomingGames will be entered first and exactly one GameResult can be entered per UpcomingGame, this will be a 1:1 relationship. As the name Upcoming says: The Upcoming data has to be entered before the Result can make sense. … Read more
The square brackets qualify the text within as a column name. They are required if someone, against recommendation, creates a column name the same as a reserved word. For example, if you have a column named Date, the following will error: SELECT t.Date FROM Table1 t In this case, you would need to qualify the … Read more
You don’t provide any sample data or expected results but – as the function can return one value only – you will most likely have to use the function in a subquery which you join to the main query on the field you group by in the main query. This way you will filter on … Read more
Attachments in MS Access are special data types that actually involve nested tables for metadata (filename and filedata) information. Hence, you cannot access this data with DML SQL statements alone via RODBC but can using a COM interface, specifically connecting to the DAO SaveToFile() method. Consider the following using the RDCOMClient package which allows interfacing … Read more
Here’s another alternative (old VB6/VBA – not VB.Net syntax). KEY SUGGESTION: the “_” characters are “continuation lines”. I honestly don’t think you want them in most of the places you’re using them. IMHO… Option Explicit Private Declare Function timeGetTime Lib “winmm.dll” () As Long Private startTime, endTime As Long Private Function elapsedTime(t1, t2 As Long) … Read more
Hide Controls in MS Access Based on Value Field solved Hide Controls in MS Access Based on Value Field