mdb/accdb to use with Access database engine
Hey I need to create an Access database in Office Access and make the tables and fields, then deliver the blank file with the vb.net app which will use Access database engine 2010 and OleDbRerader to work with the database. Just need to decide between…
Microsoft Teams chat
Hello, I have one question for you. I don't know that is work or not But i just want to know. Now we created the teams chat group and add the all office department members for IT Help Desk issues. At that time, one of member from marketing dept(eg:) send…
How do I change validation rules in Access when I can't find the original table?
Please excuse my ignorance...I have not had the need for Access for five years. I have a data input table that was designed to make it easy for data entry, with form view, design view, and datasheet view. When entered, the data can be seen in the Data…
how to format ms access dates with odbc data source
M365 Access App FE on PC win 11 - SQL Server Express back end on server. Can't format dates in form txt controls bound to appropriate date field from BE.
Why am I receiving this Error - Records in table <name> would have no record on the 'one' side.
All of a sudden my Access Query is giving me the error - Records in table <name> would have no record on the 'one' side. Works on my Laptop doesn't work on Clients Laptop!
How can we automate snipping tools through VBA?
Hi everyone! Im trying to automate the Sniping Tool Windows 11 and to use his OCR feature. Somebody knows how can I get it?
Outlook saveas did not save the embedded image added from vba or build manually
Hi folks, We run a vba code that create email using data from an Acess database. We add some picture using html format for the email and save it in Outlook format(msg) to read them later. When I display it, we see the image inside the email. After using…
summary report for blank values per field in access
We have a large table of data (several thousand records), and a significant amount of fields is recorded for each record. The design of the table means at present some fields are mandatory (required), and others are not required – which I think was…
IIF function and dates
Hello I was asked to make a change in the code I am currently calculating how much a student should pay The students have an arrival date, from here it automatically calculates for them the amount according to what was agreed monthly and the days of…
verify jwt (access_token) by python
hello, I have a front in angular and a backend in Django Python. I take my access_token from my front by: this.msalService.instance.acquireTokenSilent and send it to my backend api, i need to verify and validate this access_token before anything will…
How to execute pass-through query with long connect string in MS Access VBA
In MS Access VBA, when I create a temp querydef object with odbc driver to run the SQL by pass-through query, a warning occur "XXX is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too…
Access Europe: Better Access Charts – The Next Generation (Thomas Moeller) – Wed 6 Mar
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back (by popular demand) Thomas Moeller who will be discussing…
msaccess.exe (all versions) won't close properly when process EoAExperiences.exe is running
I have a msaccess-application (accdb) working as frontend-client to a sql-server database. The FE-database consists of forms, reports, modules, etc. On one client, when I open a form with controls others than label, it is not possible to close the…
Two finger scrolling not working in Access
Two-finger scrolling on a touchpad is not working on an Access form. It works OK in Excel, so it's not the computer or the mouse/touchpad drivers. It's also fine on the Navigation Pane in Access. If I open a table, it does scroll but is jerky and…
How do I compare two access database tables, both the table has same rows and columns ?
I have two access database tables. Table A Account #, Name, Addres, City, State, Balance, Purchase, Order, Year, TotalCost Table B. Account #, Name, Addres, City, State, Balance, Purchase, Order, Year, TotalCost My purpose is to compare Table A and…
RefreshLink has started failing with Error 3611 - Version 2312 (Build 17126.20014)
Having posted in the Community forum, it has been suggested that this is a better place to ask my question. I have a split Access database that has started raising Error 3611 (Cannot execute data definition statements on linked data sources) in the…
MS Access 2019 Crashes - Exception 0xc0000005
I am attempting to upgrade an existing MS Access 2010 application, but I get intermittent silent crashes, typically when opening or closing a screen form. The Application Event Viewer logs the following typical details: Faulting application name:…
I got an error when using MSSMAA and cannot migrate to SQL Server
When I start MSSMAA i got an error: Starting conversion... Analyzing metadata... Converting table Samod_Relèves.[AMaTable_Elec] ... Information: A2SS0005: The Zero-length-not-allowed flag on the column 'ResultID' was converted to a check…
How to enter contributions records for different years. E.g 2010 to present
I am creating an MS Access file for welfare contributions for my local church. I have created a table to record the details of the contributions which includes, payment date, contribution month, contribution year, etc. I entered data for 2017 for example…
How do I implement VB code for Data Adapter & Adapter.Fill() using C#?
Dim con As New OleDb.OleDbConnection Dim dA As OleDb.OleDbDataAdapter Dim dS As New DataSet Dim selectCommand As String Dim dT As New DataTable selectCommand = "SELECT * FROM tblA" dA = New OleDb.OleDbDataAdapter(selectCommand, con)…