Access Development

1 answer

Can not use ribbon program for 64 bit

Dear all, I have an issue when changing access 365 from 32 bit to 64 bit OS. My applycation got error in this code: Public Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _ (ByVal hWnd As Long, ByVal lpOperation…

asked

Trinh Nghi 1

answered

Robert 1

1 answer

Update query in MS Access with more then one criteria

OK need some help on this one, I have the following: I am using MS access 2016 I have stores: A,B,C,D All four stores have the same inventory type for fruit they have lets say: apples, oranges, plums and bananas and Drink they have coke, sprite,…

asked

Keith 1

answered

Robert 1

2 answers

Using Adobe Sign REST API from Access VBA

Can anyone help with using the Adobe Sign REST API from Access VBA either using the MSXML library or if there are any .net objects out there that can be called from VBA I have fair experience as an Access DB Developer working with VBA so comfortable…

asked

Larkhill 1

commented

Albert Kallal 5,226

4 answers

Visual Studio 19 Reporting

Hi- I am brand new to VS. I wrote a lot of MsAccess VBA. I am working on a Desktop. I have just installed the free version of VS2019 and created 2 forms and a module, importing Excel data, processing it and storing the processed info in datasets. I then…

asked

Olddude 21

answered

Olddude 21

3 answers

In Access 2016, for high frequency access, creating an instance of OLEDB connection for each access may cause the client application to crash

Hello everyone. I would like to ask a question about Access 2016. I am using Access 2016 from an application created in C# using an OLEDB provider. When I create a connection instance for every access, the application crashes. The frequency is…

asked

taisei ishiyama 1

commented

taisei ishiyama 1

0 answers

AC.2016..SYSTEM RESOURCES EXCEEDED on WIN 10(1909)...!!

Hi , on PC 16 GB RAM Again troubles with WIN.10(1909) MS ACCESS 2016...:pullhair:, EVERY LARGE TABLE FILTER....SYSTEM RESOURCES EXCEEDED...:shrug: But it seems like this is working again, at least now.. …

asked

PACALA_BA 1

commented

JamesTran-MSFT 36,531 Microsoft Employee

2 answers

Does windows 2016 server support Microsoft Access Database Engine 2016 Redistributable

In order to read the XLSX files I planned to install AccessDatabaseEngine_x64.exe available at: https://www.microsoft.com/en-us/download/details.aspx?id=54920 I realized however that Windows 2016 Server is not listed in the <System Requirements>…

asked

Sylwester Santorowski 21

accepted

Sylwester Santorowski 21

0 answers

Access 2016 Public Sub error - User Defined Type Not

Upgraded from Access 2013 to 2016 which uses a custom ribbon. In the Main Module, I declare a Public Sub as follows which bombs out right from the get go saying User -Defined Type Not defined. Any thoughts? 'Callback for Form OnButtonPress Public Sub…

asked

Ladydraper 21

0 answers

DLookUp() in query with criteria matching a field of the queary

Is it possible to use DLookUp inside query and have the criteria match a a field in the query.? The field being a string.

asked

imodett 41

1 answer

Exporting an XSL, XML file formats from Microsoft Access to Visual Studio IDE

I may have successfully exported a Microsoft Access form file into an XSL, and an XML file (two files) to be exact. What's next is that I want to import them into the Visual Studio IDE using C# programming techniques. Can that be done? If it can…

asked

JohnCTX 636

commented

Albert Kallal 5,226

1 answer

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

asked

JohnCTX 636

accepted

JohnCTX 636

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?

asked

kidsvavo 1

answered

kidsvavo 1

2 answers

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

Darrell Burns 141

commented

Darrell Burns 141

5 answers

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

MS-LovesAccess 96

answered

MS-LovesAccess 96

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

Mr. LAI Long Chau Vitus 1

commented

Albert Kallal 5,226

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

Mr. LAI Long Chau Vitus 1

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

Jeff Harding 41

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

Bernard Coudron 1

commented

Eleven Yu (Shanghai Wicresoft Co,.Ltd.) 10,706 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

Sheelnath Kekre 121

answered

Sheelnath Kekre 121

1 answer

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…

asked

GMax64 96

accepted

GMax64 96

Filter

Content

849 questions with Access Development tags

Can not use ribbon program for 64 bit

Update query in MS Access with more then one criteria

Using Adobe Sign REST API from Access VBA

Visual Studio 19 Reporting

In Access 2016, for high frequency access, creating an instance of OLEDB connection for each access may cause the client application to crash

AC.2016..SYSTEM RESOURCES EXCEEDED on WIN 10(1909)...!!

Does windows 2016 server support Microsoft Access Database Engine 2016 Redistributable

Access 2016 Public Sub error - User Defined Type Not

DLookUp() in query with criteria matching a field of the queary

Exporting an XSL, XML file formats from Microsoft Access to Visual Studio IDE

Exporting Access Forms to Microsoft Visual Studio 2019

Why doesn't Access quiery work for the year 2021?

Pass-thru query ODBC error

MS ACCESS Report Design Detail Section

Access 2019 Date function problem

Query search problem in Access 2019

Creating a Family Tree with photos in MS Access Report or Form

MS Office with Access on Remote Desktop Server

Log in form in visual basic 2019.

MS Access Date Format