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
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?
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…
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…
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?
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…
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…
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…
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.
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…
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…
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…
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…
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…
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…
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
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…
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
![](https://techprofile.blob.core.windows.net/images/o4UT2s39l0-Aj0Ihu-Dbig.png?8D89A0)
![](https://techprofile.blob.core.windows.net/images/o4UT2s39l0-Aj0Ihu-Dbig.png?8D89A0)
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…
![](https://techprofile.blob.core.windows.net/images/e5tpOBPL0k6JER1u91LTeQ.png?8D8AD2)