859 questions with Access Development tags

Sort by: Updated
Updated Created Answers
2 answers

Access Crosstab Query

I have the following crosstab query in Access. Is there a way to calculate the percentages for each Order Type by Fiscal Year (i.e., 2018, 2019, etc.)? Example: Order Type "18" for Fiscal Year 2018 = 21,973.55. This would be 23.2% of 2018…

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
asked 2021-05-10T20:32:53.3+00:00
Randal Flinn 311 Reputation points
commented 2021-05-11T01:07:44.033+00:00
DBG 2,301 Reputation points
1 answer One of the answers was accepted by the question author.

Check that if the linked table have a corresponding table in Sql Server

I have an Access program that is as FE and my database is SQL as BE. When I update and send my Access program to my clients, they get the updated version and copy it on their Pc. For the first time before logging in, they press a button that relinks the…

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
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,069 questions
asked 2021-05-10T14:55:28.297+00:00
Amir 181 Reputation points
accepted 2021-05-10T19:04:48.867+00:00
Amir 181 Reputation points
1 answer

Problem with the following code : DoCmd.RunCommand acCmdPaste

I have the following code in MS-Acces VBA, when I click on the button called Paste_Bookmark : Private Sub Paste_Bookmark_Click() Me!hdrBookmarkLink.SetFocus DoCmd.RunCommand acCmdPaste End Sub The URL that is currently on the…

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
asked 2021-05-10T03:34:34.127+00:00
Gilbert Peeters 1 Reputation point
answered 2021-05-10T04:27:39.627+00:00
DBG 2,301 Reputation points
5 answers One of the answers was accepted by the question author.

Connect and relink the Access tables automatically to SQL Server

I have an Access software as FE with SQL as BE. Every week I send an update file (Accde) to my users. The operators and users should call IT manager or assistant to open the updated file and relink the Access tables manually to SQL server. It is a…

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
asked 2021-04-20T20:29:02.237+00:00
Amir 181 Reputation points
commented 2021-05-08T05:14:37.347+00:00
Amir 181 Reputation points
2 answers One of the answers was accepted by the question author.

Problem to query

Hi, Can you help to error "Invalid operation" due to last line below? Option Explicit Private mDbEngine As DAO.DBEngine Private mCurrDB As DAO.Database ... Do While True RowID = RowID + 1 If…

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
asked 2021-05-07T02:35:51.513+00:00
Peter_1985 2,586 Reputation points
accepted 2021-05-07T15:43:30.917+00:00
Peter_1985 2,586 Reputation points
4 answers

Issue to DLookup

Hi, How to resolve issue with DLookup to line below? Public Function TblExists(ByVal strTableName As String) As Boolean TblExists = False If Not IsNull(DLookup("Name", "MSysObjects", "Name = " & Chr(34) &…

VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,670 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.
859 questions
asked 2021-05-06T02:45:48.217+00:00
Peter_1985 2,586 Reputation points
commented 2021-05-06T04:48:43.407+00:00
Peter_1985 2,586 Reputation points
5 answers

Issue to table name

Hi, Why is there error due to this line Set rs = db.openrecordset("select * from " & ActiveSheet.Name & ";") while ActiveSheet.Name is having value like "Week8-13"?

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
asked 2021-05-05T08:30:27.033+00:00
Peter_1985 2,586 Reputation points
commented 2021-05-06T01:20:49.713+00:00
Erin Ding-MSFT 4,461 Reputation points
2 answers One of the answers was accepted by the question author.

Access (Version 2103) Wildcard Behaviour

Hi all Right newbie question here... I have a field in a table which holds drawing numbers of the form 010-04-019-00. The data-type due to the hyphens is short text. I have a query with criteria =[Enter Drawing Number]. If I input the entire…

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
asked 2021-05-05T09:38:33.37+00:00
Phil S 261 Reputation points
commented 2021-05-05T17:45:28.563+00:00
DBG 2,301 Reputation points
10 answers

Issue to code

Hi, To code below, what should DoCmd be declared? Dim StrSQL As String Dim InDate As Date Dim DatDiff As Integer InDate = Me.FromDateTxt StrSQL = "INSERT INTO Test (Start_Date) VALUES ('" & InDate & "' );" …

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
asked 2021-05-03T04:47:46.05+00:00
Peter_1985 2,586 Reputation points
commented 2021-05-05T15:06:57.023+00:00
DBG 2,301 Reputation points
0 answers

Access Chart Size Changed (Office 365)

I have a multi axis chart in a fairly complex Access Report. I built the report in 2020 and it worked well (see image of chart below) but now the chart has been shrunk vertically and is not usable. I have seen references to Display Scaling…

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
asked 2021-05-05T13:51:08.253+00:00
DGP 1 Reputation point
1 answer One of the answers was accepted by the question author.

ADO issue in VBa code

Hi, Can you help it below?

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
asked 2021-04-30T09:48:49.063+00:00
Peter_1985 2,586 Reputation points
accepted 2021-05-05T06:32:47.223+00:00
Peter_1985 2,586 Reputation points
1 answer

Establecer formulario predeterminado que aparece al abrir una base de datos de MS Access

En una aplicación creada con Access 2016 existe un formulario de inicio (-frm-) que se muestra en lugar del símbolo de inicio de MS Access al abrir la base de datos, y realiza determinadas acciones. He comprobado que, desde hace unos meses y sin haber…

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
asked 2021-05-03T07:25:19.733+00:00
Francisco Garcia 1 Reputation point
commented 2021-05-04T15:01:18.767+00:00
DBG 2,301 Reputation points
7 answers

Exception got

Hi, I've set up Access on server. Why is it still having issue below? [InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.]

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,656 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,670 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.
859 questions
asked 2021-04-29T05:07:18.17+00:00
Peter_1985 2,586 Reputation points
commented 2021-05-03T02:55:01.653+00:00
Jack J Jun 24,496 Reputation points Microsoft Vendor
1 answer

How do I convert an ADP project MS Access 2003 with an SQL server database to ACCDB 2016?

I have a .adp ms access project 2003 with sql server database I want to run this project on ms access 2016 as accdb , how can i Convert it ?

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
asked 2021-05-01T04:27:28.283+00:00
Mojtaba_Hakim 281 Reputation points
commented 2021-05-02T14:37:41.41+00:00
DBG 2,301 Reputation points
1 answer

Use of Criteria in Access Query

Hello, I am creating a query where the are (26) items I would like to include in the query criteria (there are 143 different choices). At this point, I have been unable to select the appropriate records using my query. Is there a better way to…

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
asked 2021-04-30T12:18:01.747+00:00
Flinn, Randal J 281 Reputation points
answered 2021-05-01T15:16:33.37+00:00
DBG 2,301 Reputation points
2 answers

Spacing menu options not working on tab page.

I have discovered that I am unable to use the spacing functionality from the ribbon (equal horizontal/vertical, increase/decrease horizontal/vertical) etc. on multiple selected controls (e.g. textboxes) when they are on a tab page. When I select my…

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
asked 2021-03-30T21:17:15.363+00:00
Bruce H 1 Reputation point
answered 2021-04-30T20:40:51.003+00:00
Shane Groff (Microsoft) 1 Reputation point Microsoft Employee
1 answer

Issue with sending emails from MS Access via outlook

I have successfully set up a process within Access that allows me to send emails through Outlook however, I have several Gmail accounts withing the Outlook programme - for different roles I have. I want to be able to specify which account the emails go…

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
asked 2021-04-29T03:10:44.837+00:00
Leonard Weber 1 Reputation point
answered 2021-04-29T14:06:43.663+00:00
DBG 2,301 Reputation points
3 answers One of the answers was accepted by the question author.

Access report is not correct

I am using the following code: Option Compare Database Option Explicit Private Sub Reset_Background() Dim lblCtrl As Control For Each lblCtrl In Report If lblCtrl.ControlType = acLabel Then …

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
asked 2021-04-13T19:04:39.407+00:00
Mark McCumber 431 Reputation points
accepted 2021-04-28T14:30:43.297+00:00
Mark McCumber 431 Reputation points
4 answers

Microsoft Access Query Records On One Table But Not Another

Hello, I had a quick question about a Microsoft Access Query we're trying to write. Our DBAs all left, so we're trying to piecemeal something for a department. We have 2 tables: Table 1 EID Email PW Table 2 EID Demographics…

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
asked 2021-04-21T14:12:05.993+00:00
nicholas conger 1 Reputation point
answered 2021-04-23T12:32:52.883+00:00
Ken Sheridan 2,756 Reputation points
2 answers

Access DSUM in Query

I have a table that identifies costs by Location and Department. I would like to build/run a query that identifies information by the Location and Department (as shown below). Building Electric Department Plumbing Department Roofing Department Etc. A $…

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
asked 2021-04-19T19:00:35.253+00:00
Randal Flinn 311 Reputation points
answered 2021-04-21T17:53:24.77+00:00
Ken Sheridan 2,756 Reputation points