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,656 questions
1 answer
One of the answers was accepted by the question author.
Exporting Access Forms to Microsoft Visual Studio 2019
I want to know currently, if it is possible to Export an Access Form along with its controls to Visual Studio 2019? If it is possible then can it be done using C#? Regards, JohnCTX
C#
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.
859 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(153.6, 0%, 24%)' 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)
9 answers
Why doesn't Access quiery work for the year 2021?
I have an access query that I need to pull all the records for a certain month and year. It works fine for all years that are on the list of records except it will not query for the year 2021. Why?
![](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(163.2, 36%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
Pass-thru query ODBC error
I have a DSN that connects my Access database to a SQL Server database called "Hotlist". I then created a pass-through query that works fine when I apply the DSN interactively, but throws an ODBC-Connection Failed error when I run the same…
asked 2021-02-14T17:12:28.873+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(214.4, 50%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Darrell Burns
141
Reputation points
commented 2021-02-15T20:36:07.65+00:00
Darrell Burns
141
Reputation points
5 answers
One of the answers was accepted by the question author.
MS ACCESS Report Design Detail Section
Hi Experts I am designing an invoice in MS Access. I need to make the height of detail section fixed so that the height remains same. Mainly i want the report footer to be positioned a little below. Currently if there is one row the detail section…
asked 2021-02-10T08:49:04.73+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(35.2, 0%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
MS-LovesAccess
96
Reputation points
answered 2021-02-15T06:14:54.75+00:00
MS-LovesAccess
96
Reputation points
0 answers
Access 2019 Date function problem
The Access 2019 fail to using date function, such as date(), year(), month(). Is it some I missing or needed attention?
asked 2021-02-14T06:59:59.507+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(12.8, 13%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Mr. LAI Long Chau Vitus
1
Reputation point
commented 2021-02-14T20:02:14.517+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, 46%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Albert Kallal
5,231
Reputation points
0 answers
Query search problem in Access 2019
When I create a new file using query search by current date or by year function in Access 2019, there’s a pop-up window immediately came out. The meanings something like : Visual Basic Module contains a syntax error. However, when I use old version file…
asked 2021-02-12T08:47:47.727+00:00
Mr. LAI Long Chau Vitus
1
Reputation point
asked 2021-02-12T08:47:47.727+00:00
Mr. LAI Long Chau Vitus
1
Reputation point
0 answers
Creating a Family Tree with photos in MS Access Report or Form
Has anyone ever created a MS Access Report or Form that has a family tree hierarchy with photos and text? I can do it with a tree view without photos, but to arrange the photos between lines with levels of descendants is eluding me. Any help would…
asked 2021-02-11T02:06:51.587+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(217.60000000000002, 48%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jeff Harding
41
Reputation points
asked 2021-02-11T02:06:51.587+00:00
Jeff Harding
41
Reputation points
0 answers
MS Office with Access on Remote Desktop Server
Hello, A Customer asked to install a Remote Desktop Server, but MS Office must have Access included. Could the Volume License "Office Professional Plus" (79P-05729) be a solution ? And which Office 365 subscription could be a suitable…
asked 2021-02-09T17:48:30.063+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(204.8, 19%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBC%3C/text%3E%3C/svg%3E)
Bernard Coudron
1
Reputation point
commented 2021-02-10T02:07:20.727+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(252.8, 30%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEY%3C/text%3E%3C/svg%3E)
Eleven Yu (Shanghai Wicresoft Co,.Ltd.)
10,726
Reputation points Microsoft Vendor
3 answers
Log in form in visual basic 2019.
I want to create a login form in access database program which allows each user to create his username and password and resetting password via forgot password link.
asked 2021-02-03T13:23:11.517+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(44.800000000000004, 82%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sheelnath Kekre
121
Reputation points
answered 2021-02-05T12:55:46.88+00:00
Sheelnath Kekre
121
Reputation points
1 answer
One of the answers was accepted by the question author.
MS Access Date Format
Hello everybody, I have a simple selection query with just two fields: 1) Date (dd/mm/yyyy format), 2) # of Items (net daily increase) and I need to add a third field with the cumulate # of items up to that date. Using the DSum() function I…
![](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(304, 45%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
Microsoft Access 2016 syntax error when openining Design View in queries
Dear All, I have the below error messages when I try to open a Design View in a few Queries. I tried to repair Office 2016, uninstall and reinstall with no avail. I copied the Access program to another compter and run it. Everything…
![](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(227.2, 21%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
1 answer
Refresh Report within Form
I have a form with a few data entry fields, with a report below. The idea is that as the user enters data, the report gets updated with the new records. I am having difficulty getting the report to "refresh" after the user selects a "Save…
asked 2021-01-29T20:09:06.13+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(131.20000000000002, 19%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kris Schmidt
1
Reputation point
answered 2021-02-02T23:23:56.593+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(192, 44%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
C Data
6
Reputation points
2 answers
New to SQL in Microsoft Access and having major issues
I am tasked with tracking Overtime hours worked by Department/Employee. Our work week is 35 hours, first 5 additional is Straight Time, any additional is OT (at time and a half). Tables collect Week of Date, Employee, # of OT Hours and Department. I…
asked 2021-01-31T20:49:37.337+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(76.8, 71%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Mark Davis
1
Reputation point
answered 2021-02-02T23:13:20.447+00:00
C Data
6
Reputation points
3 answers
One of the answers was accepted by the question author.
Data type mismatch when querying Tax ID
I've created a simple query to look up customers by Tax ID. Since the users don't always insert the hyphens in the right place, I strip out the hyphens using the REPLACE function. But the query throws a Data Type Mismatch error (see example). I've tried…
asked 2021-01-26T18:02:38.297+00:00
Darrell Burns
141
Reputation points
accepted 2021-02-02T11:57:36.587+00:00
Darrell Burns
141
Reputation points
1 answer
Can't Open ACCDE made with Access 2016 (32-bit) | Eine mit Access 2016 erstellte ACCDE (32-Bit) lässt sich mit Access 2019 nicht öffnen.
I made an Access application (ACCDE) for a user using Access 2016 (32-bit) that uses VBA and connects to an MS SQL-Server database on our network via ODBC. It used to work, but the user can no longer open it. The first error message the user reported is…
asked 2021-01-29T16:45:19.677+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(198.4, 94%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBC%3C/text%3E%3C/svg%3E)
Bryant, Curtis
1
Reputation point
answered 2021-02-02T02:29:06.203+00:00
Albert Kallal
5,231
Reputation points
1 answer
accessing adobe acrobat dc
i want to open a pdf in adobe acrobat dc with a link from access vba, but it opens in edge. is it possible
asked 2021-01-30T11:49:55.847+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, 15%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGD%3C/text%3E%3C/svg%3E)
Griet De Groote
1
Reputation point
answered 2021-01-30T14:48:14.807+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(256, 41%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
Tom van Stiphout
1,701
Reputation points MVP
2 answers
ACCESS VBA - "DoCmd.RunCommand acCmdNewObjectAutoReport" doesn't add all fields to Report
Hi, I have been trying to create an access report from an existing table using below VBA code. It creates the report successfully, But the issue is it doesn't add all the fields from the table to the report created. It is adding only 15 fields. I am…
asked 2021-01-28T15:01:40.57+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(102.4, 92%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
Vikhanasa Manojav Agnihotram
1
Reputation point
commented 2021-01-29T01:09:42.287+00:00
Albert Kallal
5,231
Reputation points
0 answers
How To Reference Hidden Field in Combo Box using VBA
Hello: I have an Access form with a combo box. It has two fields, a product ID and a Product name. The Product Id is hidden from the drop-down. How can I access the hidden field using VBA? Thanks, Rich Locus
asked 2021-01-25T21:20:32.303+00:00
Rich Locus
61
Reputation points
commented 2021-01-27T01:38:53.207+00:00
Rich Locus
61
Reputation points
1 answer
How to write access VLOOKUP formulas as field default value based on another table
For example, I have two Access tables (backend database): TableUser and TableWorkingHours For TableUser, Username is unique. I understand that I should not have FirstName and LastName in TableWorkingHours. For some reasons, I don't feel…
asked 2021-01-23T17:07:33.7+00:00
VAer-4038
761
Reputation points
answered 2021-01-23T17:46:54.527+00:00
Tom van Stiphout
1,701
Reputation points MVP