Access
A family of Microsoft relational database management systems designed for ease of use.
336 questions
0 answers
Using a calculated field in a table to combine other fields for names
I've got a table with three fields [First] [Last] and [Nickname]. I've created a third field to calculate them together as [First]+" "+"[Nickname]"+" "[Last] The problem is, if [Nickname] isn't filled in, it returns zero…
asked 2023-10-11T14:18:16.53+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 83%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECV%3C/text%3E%3C/svg%3E)
Chris Vaughan
0
Reputation points
asked 2023-10-11T14:18:16.53+00:00
Chris Vaughan
0
Reputation points
2 answers
Access Europe meeting on Wed 4 Oct - The future of Access
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST Please note that the UK…
asked 2023-09-26T13:03:20.97+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 62%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Colin Riddington
85
Reputation points
answered 2023-10-10T20:22:03.4433333+00:00
Colin Riddington
85
Reputation points
1 answer
One of the answers was accepted by the question author.
I have a table in excel with image in the last cell of every row, how can I export it to Access database?
Hello everybody, I have a table in excel with image in the last cell of every row, how can I export it to Access database? the cells contain the image itself not a link to its location.
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,447 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,061 questions
asked 2023-09-10T07:55:12.74+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 67%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Abdulrahman Althunayan
40
Reputation points
commented 2023-10-08T04:58:42.7633333+00:00
Abdulrahman Althunayan
40
Reputation points
2 answers
OleDbConnection.close() takes long time, when using Microsoft access database engine 2016 in c#, whereas there is no such issue with microsoft access database engine 2010.
When using microsoft access database engine 2016, OleDbConnection.close() is taking long time and the program got struck at this line (conn.Close()) which is resulting in few issues with my application. There is no such issue, when I use microsoft…
asked 2023-10-04T06:45:37.5733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 62%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKG%3C/text%3E%3C/svg%3E)
Kousiga Govindarajan
0
Reputation points
answered 2023-10-04T08:20:43.5933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 11%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHL%3C/text%3E%3C/svg%3E)
Hui Liu-MSFT
47,256
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
How to control the attachment mini toolbar in access
Hello, I just started to work with the attachment field in access, and noticed that the attachment mini toolbar is in auto hide mode, can I switch that to be allways visible, and reposition its place and control its size? Regards,
asked 2023-09-26T06:29:59.4966667+00:00
Abdulrahman Althunayan
40
Reputation points
accepted 2023-10-04T04:59:18.59+00:00
Abdulrahman Althunayan
40
Reputation points
1 answer
One of the answers was accepted by the question author.
Query on License
Hi All I am using Microsoft 365 E5 license, Is Microsoft Access part of this license. when i search in Volume licensing portal with the word access i dont find any product with this name. please guide me
asked 2023-10-03T13:45:04.6833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 72%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERF%3C/text%3E%3C/svg%3E)
Rising Flight
4,196
Reputation points
accepted 2023-10-03T17:25:54.7433333+00:00
Rising Flight
4,196
Reputation points
0 answers
Access Package expiry emails coming through constantly
Good morning, We have a user who's access package has expired. He has then constantly been getting emails through telling him this has expired. They only stopped after he requested the access again. Can someone confirm if there is something we can do…
asked 2023-10-02T09:19:51.4566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 56.00000000000001%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESF%3C/text%3E%3C/svg%3E)
Sean Foster
0
Reputation points
edited the question 2023-10-02T09:25:35.5066667+00:00
Sean Foster
0
Reputation points
4 answers
Failed to add 64-bit system DSN in ODBC Data Source Administrator tool
I'm trying to add a 64-bit system DSN (Microsoft Access Driver) in ODBC Data Source (64-bit). Steps as follows. After these steps, the system DSN list is still empty. However, I successfully added a 32-bit system DSN in ODBC Data Source (32-bit). Is…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 61%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 67%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
0 answers
You are not eligible for a free Azure account
I followed each step of the link: https://learn.microsoft.com/en-us/azure/cost-management-billing/manage/troubleshoot-azure-sign-up but I still encounter the same problem knowing that I I'm a new user and I've never created an account or subscribed to…
asked 2023-09-25T12:08:06.99+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 24%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Jessy MIHINDOU
0
Reputation points
edited the question 2023-09-25T12:10:22.3666667+00:00
Jessy MIHINDOU
0
Reputation points
0 answers
Access 2016 Risorse di sistema insufficienti dati esterni DBF
e' una tabella particolarmente grande altre tabelle vengono collegate normalmente
asked 2023-09-22T15:44:37.2733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 96%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
RAFFAELE PEZONE
0
Reputation points
asked 2023-09-22T15:44:37.2733333+00:00
RAFFAELE PEZONE
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Access a Sharepoint site without credentials based on IP address
Hello, I am wanting to find an easy way to access a list of files and scripts for deploying new PCs. I would liek these files, scripts and applications to be located on a sharepoint site, and i would like to be able to access this site…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 57.99999999999999%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENH%3C/text%3E%3C/svg%3E)
0 answers
Why cant I seem to write on this table when the database allows me to?
I have this Access file which has linked tables from SQL Server. There are a few tables that I cannot seem to write into or edit the existing data. How can I write in these tables when the database is not in read only status?
asked 2023-09-21T16:06:29.4866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 15%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELA%3C/text%3E%3C/svg%3E)
Lopez, Ahiezer
236
Reputation points
asked 2023-09-21T16:06:29.4866667+00:00
Lopez, Ahiezer
236
Reputation points
0 answers
Cannot make an Azure account in any way
I want to make an Azure account for a project me and my friend are working on and, yes, i have a Microsoft account, but when trying to use the services, i need to then make an Azure account. Ok, simple, but, there is an issue. It requests a credit card,…
asked 2023-09-20T09:33:51.5833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 88%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
Dani Masso
0
Reputation points
edited the question 2023-09-21T05:08:28.2233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 59%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SnehaAgrawal-MSFT
20,241
Reputation points
1 answer
Windows 10 + access MDB file shared in windows 2012R2 server access too slow
I have several computers with windows 10 Pro, running applications that access MDB files that are in a network drive in a windows 2012R2 Server. The programs run very slow. The same computer computer with Windows XP runs the applications with no…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 1%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
0 answers
Loss of state of a checkbox or togleButton of a custom ribbon
Hello, From a form, if in the event of a button click, we open a 2nd form followed by the invalidate command from the ribbon, the checkboxes or togleButton lose their selected state. Here is the test VBA code: Private Sub cmdOpenForm_Click() 'If Not…
asked 2023-09-19T16:25:42.09+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 1%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
jacky Perpète
41
Reputation points
edited the question 2023-09-19T16:30:37.7766667+00:00
jacky Perpète
41
Reputation points
1 answer
One of the answers was accepted by the question author.
Importing data from Access using ADODB References
I need help with this to import the data successfully from an MDB file to a Data Grid View control by using the ADODB and Access Interop assembly references. I have this code snippet below: using System; using System.Windows.Forms; using…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,853 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,602 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 76%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
3 answers
How can I add x amount of working days to a date?
Suppose I wanted to add 85 working days, meaning only the weekdays, to a field with an existing date, how could I do this? Same scenario, but also take into account holidays so don't count the holidays as a working day. How could I do this?
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,694 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
852 questions
asked 2023-09-12T18:15:40.18+00:00
Lopez, Ahiezer
236
Reputation points
edited an answer 2023-09-13T16:49:41.06+00:00
Ken Sheridan
2,756
Reputation points
0 answers
Can't access ADO Tasks; the ADO links are not working
Unable to access ADO Tasks; when I launch the link, then it says, Bad request HTTP Error 400 - request too long
asked 2023-09-12T03:36:15.16+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 73%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Siddarth Mandalika (Aquent LLC)
0
Reputation points Microsoft Vendor
commented 2023-09-12T06:04:57.8033333+00:00
Olaf Helper
42,926
Reputation points
0 answers
Inappropriate appearance of a horizontal banner below the form after using the maximize button if the properties 'NavigationButtons' is set to false and 'ScrollBars' is set to Vertical Only or Both.
Access 2021 Hello, If a form's 'NavigationButtons' properties are set to false and 'ScrollBars' is set to Vertical Only or Both, we perceive a horizontal banner below the form after using the Maximize button and decreasing the window size until the…
asked 2023-09-05T04:51:41.65+00:00
jacky Perpète
41
Reputation points
edited a comment 2023-09-11T16:20:05.43+00:00
jacky Perpète
41
Reputation points
0 answers
Access Europe meeting on Wed 6 Sept - Database Analyzer and other tools
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST Please note that the…
asked 2023-09-02T10:07:35.0666667+00:00
Colin Riddington
85
Reputation points
commented 2023-09-10T17:56:37.56+00:00
Colin Riddington
85
Reputation points