Access Development

1 answer

ADO issue in VBa code

Hi, Can you help it below?

asked

Peter_1985 2,586

accepted

Peter_1985 2,586

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…

asked

Francisco Garcia 1

commented

DBG 2,301

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.]

asked

Peter_1985 2,586

commented

Jack J Jun 24,491 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 ?

asked

Mojtaba_Hakim 281

commented

DBG 2,301

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…

asked

Flinn, Randal J 281

answered

DBG 2,301

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…

asked

Bruce H 1

answered

Shane Groff (Microsoft) 1 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…

asked

Leonard Weber 1

answered

DBG 2,301

3 answers

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 …

asked

Mark McCumber 431

accepted

Mark McCumber 431

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…

asked

nicholas conger 1

answered

Ken Sheridan 2,756

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 $…

asked

Randal Flinn 311

answered

Ken Sheridan 2,756

0 answers

The combobox doesn't find the specified item in some PCs

I have a software that has Access as FE and SQL as BE. In one of my forms (Production Schedule) is a Combo box that the operator should type the order number in it and after pressing tab, the row fill with related data of the order. I usually create…

asked

Amir 181

0 answers

Convert Japanese IME to English - after entry

After I enter data is in english, it is converted into japanese. I need a solution to reconvert the same data to english. Actually I will loose lot of personal information if I cannot reconvert. I found solutions where it was told that after changing the…

asked

Acessuser1234 1

1 answer

Cumulative Sum with Duplicate Date

Hi i'm trying to calculate running sum for an account statement but i have problem when there is duplicate dates the sum is not changing until the date changes this is the result : and this is the query : SELECT Trans.TransDate,…

asked

islam qasem 1

answered

Ken Sheridan 2,756

2 answers

Is there a way to really automate sending of emails through outlook mail without having to click on the send button for every record in Microsoft Access?

Hi I have made a Microsoft access System wherein it will automatically generate the reports as a pdf and automatically send it as an attachment to multiple individual emails through outlook mail. It's in a loop too. Is there a way wherein I will not need…

asked

noahjohn 41

commented

DBG 2,301

3 answers

Office 365, how to use MS ACCESS on laptop

I have purchased Office 365 Busines, upgraded it to the level that has MS ACCESS. This app is not showing up. How do I use it on my laptop. Thanks

asked

Suzanne Sands 1

answered

Chris Ward 1

3 answers

The controls location change in form view

Sometimes I design a form in Access and carefully arrange the controls in correct position when I change the view to form view, some controls locations change and overlap each other. I don't know why?

asked

Amir 181

answered

Amir 181

2 answers

The text in combobox disappear after I shift to next row in Subform

I have a subform that the user can select the material that should send to production line. Because the material variety is a lot, I used two unbound comboboxes that filter the material based on the category and classification and after that the user…

asked

Amir 181

commented

Amir 181

2 answers

Failed Record Deletion in Database : Visual Studio 2015: MS Access 2019

When opening the form and following the Form structure to delete the record, it does delete from my Form.datagridview, but when closing and reloading the form, the record is there. my source database shows in the 'server explorer' with the "red…

asked

Fred Peters 1

answered

Fred Peters 1

1 answer

Help: Update Value calculation from one table into one table?

Dear all, I have 2 tables. One TblOutput have some fields: PONumber, OKQty, Process. And one table TblPO have fields: POID, ActualQty that i take them into one Subform. When I open the form, The Dsum will calculate from TblOutput and update on tblPO. I…

asked

Trinh Nghi 1

commented

DBG 2,301

1 answer

Run-Time Error '13' Type Mismatch - ACCESS DATABASE

I am trying to compare two text fields txtTrailerNumber and txtSealNumber to the database table Tab_TrailerDetails. [TrailerNumber] and [SealNumber] as listed in the table. I am trying to get the database to look at the trailer number entered into the…

asked

Joseph Willis 1

answered

DBG 2,301

Filter

Content

849 questions with Access Development tags

ADO issue in VBa code

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

Exception got

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

Use of Criteria in Access Query

Spacing menu options not working on tab page.

Issue with sending emails from MS Access via outlook

Access report is not correct

Microsoft Access Query Records On One Table But Not Another

Access DSUM in Query

The combobox doesn't find the specified item in some PCs

Convert Japanese IME to English - after entry

Cumulative Sum with Duplicate Date

Is there a way to really automate sending of emails through outlook mail without having to click on the send button for every record in Microsoft Access?

Office 365, how to use MS ACCESS on laptop

The controls location change in form view

The text in combobox disappear after I shift to next row in Subform

Failed Record Deletion in Database : Visual Studio 2015: MS Access 2019

Help: Update Value calculation from one table into one table?

Run-Time Error '13' Type Mismatch - ACCESS DATABASE