Get all record source details for all forms in Access DB
I am in the process of splitting an Access database to move the data to a SQL Server. Application testing has found a form not loading due to the query syntax that supports the forms referencing Access tables not being compatible TSQL now the data is in the SQL database. I have resolved this one case but would like to iterate through all forms and where they have a query record source, review the query syntax for possible issues.
MS Access: Time calculation
Time Calculation result not displaying.
Insert Into table not inserting one column value
One time-based column value is not being inserted into the corresponding table column.
Is there an equivalent to the SUBSTRING function in MS Access SQL?
I want to do something like this within an MS Access query, but SUBSTRING is an undefined function.
MS-Access-VBA issue trying to use OR when checking a text control for a value. Many values can show but I am only looking for ABC OR DEF
In my DB I need to determine the value of a text box on a form. I am looking for specific results to continue with my code. Here is what I am using now: If Me.textcontrol.value = “ABC” OR “DEF” Then
Me.anothercontrol.Enabled = True
Else:Do something else
End IF
This is failing to run and highlighted. I tried to verify my OR statement had the correct syntax but could not find anything on the WEB. I probably was not asking my question correctly.
Cannot set/unset check box
My Form has an unbound Checkbox used for display.
Even though Me.Check2 = False seems the correct command
in Form Load it will not set or unset. Just displays a wee square shape. Null?
In MS Access I am using a TabControl. I would like the selected Tab of be green and the unselected Tabs to be gray. How can I do this?
How can I change tab colors.
The selected tab should be green.
The non selected tabs should be grey.
Creating a new section in MS access report
The report contains report header, page header, regionidentifier header; detail section; regionidentifier footer; page footer; report footer.
I want to count how many sessions a student “Attend✔️”
screenshot of MS Access file
I just want [CS] CS=Current session to count how many times a student “Attend✔️” …
Conditionally Export Access Table to Excel
Is it possible to automate the conditional export of an Access table to Excel if it meets specific criteria? I would like to export a final Access table to Excel only if the Updates field value is >10 after I run my macro. Otherwise, I do not want the table to be exported from Access to Excel.