470,856 Members | 2,573 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

home > topics > microsoft access / vba > questions

Microsoft Access / VBA Questions and Answers

newest replies last postReverse Sort Order views AllQuestionsArticles

+ Ask a Question
isladogs
Access User Group – Europe
15 replies 6,250 views Question by isladogs | last reply: 6 Days Ago by isladogs
isladogs
UK Access User Group (AUG) Seminar
1 reply 5,297 views Question by isladogs | last reply: Feb 7 '22 by isladogs
NeoPa
Access Announcements
15 replies 21,634 views Question by NeoPa | last reply: Feb 7 '22 by isladogs
NeoPa
How to ask "good" questions -- READ BEFORE SUBMITTING A QUESTION!
1 reply 34,007 views Question by NeoPa | last reply: May 8 '16 by NeoPa
PEB
POSTING_GUIDELINES: Please Read Carefully Before Posting to a Forum
1 reply 52,246 views Question by PEB | last reply: Jan 21 '07 by MMcCarthy
Crosstab query for time duration from 2 fields
9 replies 8,560 views Question by jackjee | last reply: 3 Days Ago by CAintheUK
Duplicate Main form & Sub form "Run-time error '3022'
5 replies 16,715 views Question by Mick3911 | last reply: 4 Weeks Ago by ADezii
Access Report to Send to Multiple Recipients
22 replies 22,364 views Question by kjhyder | last reply: 4 Weeks Ago by zmbd
Sending Unique Emails to Distinct Recipeints
2 replies 9,882 views Question by kjhyder | last reply: 4 Weeks Ago by zmbd
Problem with Chart Data ....
1 reply 7,929 views Question by irsmalik | last reply: May 30 '22 by NeoPa
Combo Box, Option Group and Check Box all in One Form
6 replies 10,462 views Question by irsmalik | last reply: May 27 '22 by isladogs
Vb.net
1 reply 9,734 views Question by Korara | last reply: May 27 '22 by zmbd
Calculator
3 replies 7,507 views Question by Eliasendashaw | last reply: May 21 '22 by ADezii
Access unable to save backup or make .accde
25 replies 29,795 views Question by Petrol | last reply: May 18 '22 by Petrol
Combining Rows-Opposite of Union
21 replies 30,599 views Question by LoneStar | last reply: May 18 '22 by NeoPa
Deleting Duplicate Records in Access 2016
1 reply 5,513 views Question by EverettMiller | last reply: May 17 '22 by zmbd
Calculating Retirement Date from DOB in an Employee Table
15 replies 11,541 views Question by nityanda10 | last reply: May 11 '22 by cactusdata
Syntax error 3075 when typing name with apostrophe in form
3 replies 7,112 views Question by eseng | last reply: May 7 '22 by NeoPa
Calculated Form Field, with Criteria?
1 reply 10,669 views Question by ScudaMcGruder | last reply: Apr 30 '22 by zmbd
Converting date in a form
6 replies 11,773 views Question by Machi413 | last reply: Apr 29 '22 by zmbd
Credit card payments
4 replies 12,287 views Question by Raizyros | last reply: Apr 27 '22 by isladogs
RS Object invalid or no longer set (hair pulling out)
2 replies 11,269 views Question by WannaKatana2 | last reply: Apr 26 '22 by NeoPa
Can't open 2019 accdb in 2016!!
7 replies 11,192 views Question by ScudaMcGruder | last reply: Apr 21 '22 by zmbd
ajhayes
Having a problem with query criteria coming from a subform
9 replies 17,616 views Question by ajhayes | last reply: Apr 21 '22 by NeoPa
Need help setting a validation rule. Microsoft Access
2 replies 9,926 views Question by jess4444 | last reply: Apr 16 '22 by zmbd
Adding a calculated field from a stored query to a new query
11 replies 8,690 views Question by jrol | last reply: Apr 15 '22 by zmbd
Using DateAdd with ODBC drivers
5 replies 7,232 views Question by JXWD | last reply: Apr 15 '22 by NeoPa
InStrRev Not Giving Correct Results
3 replies 8,231 views Question by Vaulcul | last reply: Apr 13 '22 by WannaKatana2
Continuous Form #Error On New Record
6 replies 9,010 views Question by SunnyTaru | last reply: Apr 3 '22 by NeoPa
Append Query
1 reply 6,044 views Question by TMatharu | last reply: Apr 2 '22 by NeoPa
Continuous Form #Error On New Record (Closed)
1 reply 6,510 views Question by TMatharu | last reply: Apr 2 '22 by NeoPa
Default Shortcut Menu
2 replies 6,879 views Question by EnglishMon | last reply: Mar 31 '22 by Mia White
DJRhino1175
End a loop error
3 replies 4,134 views Question by DJRhino1175 | last reply: Mar 24 '22 by NeoPa
Days overlap
10 replies 7,546 views Question by Lou699 | last reply: Mar 21 '22 by DanicaDear
Having trouble updating a recordset
7 replies 5,115 views Question by Wazza0161 | last reply: Mar 17 '22 by NeoPa
Keeping Track of New Records
2 replies 9,111 views Question by markld68 | last reply: Mar 9 '22 by GazMathias
Create Summary Report With 7 reports
1 reply 10,925 views Question by Usman55 | last reply: Mar 4 '22 by NeoPa
Store Multiple Image Paths with one command button
1 reply 9,023 views Question by AS Mughal | last reply: Feb 25 '22 by NeoPa
Ability to Create/Print Report from User Filtered Sub-form
5 replies 8,769 views Question by Tamille2020 | last reply: Feb 25 '22 by NeoPa
App error
3 replies 5,170 views Question by igop | last reply: Feb 23 '22 by isladogs
Report Filtering
1 reply 4,188 views Question by williamson1979 | last reply: Feb 21 '22 by NeoPa
Set Visibility of Subform controls
24 replies 6,668 views Question by williamson1979 | last reply: Feb 20 '22 by williamson1979
Alireza355
Textbox indent
8 replies 11,041 views Question by Alireza355 | last reply: Feb 19 '22 by Freddyboy
Is it possible to indent a memo field?
6 replies 7,026 views Question by Thomas Bea | last reply: Feb 18 '22 by NeoPa
starting and stopping dragon naturally speaking from MS Access
3 replies 5,969 views Question by jackiemasson | last reply: Feb 7 '22 by isladogs
Prevent Duplicate Entry within a Month
2 replies 10,321 views Question by Usman55 | last reply: Jan 22 '22 by isladogs
Opening a Macro in Design View
4 replies 14,651 views Question by jkwok | last reply: Jan 20 '22 by isladogs
anoble1
Append Query trying not to add duplicate records to new table
9 replies 12,947 views Question by anoble1 | last reply: Jan 16 '22 by isladogs
Opening Balance
6 replies 13,509 views Question by Kwabena10 | last reply: Jan 15 '22 by NeoPa
When inventory is not yet sold
7 replies 14,520 views Question by cmo187265 | last reply: Jan 14 '22 by cmo187265
Undesired #Name? Result
2 replies 9,068 views Question by Waqarahmed | last reply: Jan 12 '22 by NeoPa
Many many to many headscratchers
6 replies 15,950 views Question by cmo187265 | last reply: Jan 5 '22 by cmo187265
Form not opening completely
6 replies 8,938 views Question by Petrol | last reply: Dec 31 '21 by NeoPa
How to control exit from the Access application
9 replies 10,072 views Question by Petrol | last reply: Dec 30 '21 by Petrol
Crosstab query based form data update
1 reply 8,073 views Question by jackjee | last reply: Dec 24 '21 by isladogs
ComboBox is not Refreshing the List after the Change event.
2 replies 9,060 views Question by Ademar | last reply: Dec 12 '21 by isladogs
Seth Schrock
Custom right click menu strange behavior
4 replies 11,962 views Question by Seth Schrock | last reply: Dec 9 '21 by NeoPa
I can not connect my access database to sharepoint site
answer this 9,574 views Question by MoonNbl | last reply: Dec 8 '21 by MoonNbl
Concantenate Numbers and Text in Query
1 reply 8,895 views Question by jerryg72 | last reply: Dec 6 '21 by NeoPa
Open Another Database from a Form
2 replies 15,823 views Question by JamesNapier | last reply: Nov 30 '21 by NeoPa
Shrinking/Stretching Forms
8 replies 7,731 views Question by tridza | last reply: Nov 20 '21 by isladogs
Grouping and Sorting a report or form, Please Help
1 reply 6,978 views Question by tbutler | last reply: Nov 18 '21 by NeoPa
NeoPa
How to Convert Text Dates to Date format
4 replies 18,985 views Question by NeoPa | last reply: Nov 16 '21 by NeoPa
Too many, many to many?
5 replies 8,199 views Question by cmo187265 | last reply: Nov 15 '21 by NeoPa
Sending email with attachment using Sendobject & Thunderbird client
33 replies 9,552 views Question by ACB64 | last reply: Nov 1 '21 by GazMathias
Adding values for a period of time in access database
2 replies 7,571 views Question by Musoke Herbert | last reply: Oct 30 '21 by cactusdata
Access will not show compile error on Button_Click in form
1 reply 7,271 views Question by byggarebob123 | last reply: Oct 29 '21 by isladogs
MGadAllah
Is MS Access Worth Learning in 2021?
14 replies 9,967 views Question by MGadAllah | last reply: Oct 29 '21 by NeoPa
Disable Print Button
2 replies 6,637 views Question by Darius9023 | last reply: Oct 27 '21 by GazMathias
How to Clear Form Controls for Next Entry
32 replies 94,541 views Question by bloukopkoggelmander | last reply: Oct 23 '21 by NeoPa
Insert Into query using VBA
16 replies 105,103 views Question by omozali | last reply: Oct 23 '21 by NeoPa
HIDE / SHOW OF FORMS in MS Access
3 replies 114,926 views Question by kartikss | last reply: Oct 23 '21 by NeoPa
How to Calculate opening balance in all ledger accounts
3 replies 2,745 views Question by SheikhAltaf | last reply: Oct 18 '21 by NeoPa
Where are Access icons located?
10 replies 33,772 views Question by wvmitchell | last reply: Oct 12 '21 by NeoPa
Seth Schrock
Left join on three fields giving strange results
8 replies 5,689 views Question by Seth Schrock | last reply: Sep 29 '21 by Seth Schrock
auto table update of mysql database from access database
19 replies 9,899 views Question by ridwan | last reply: Sep 28 '21 by Check1123
Required field / error with null value / can't move focus
7 replies 7,804 views Question by kiwipedia | last reply: Sep 28 '21 by jordimarsa
Alireza355
Delete all records from multiple tables in one shot
14 replies 42,723 views Question by Alireza355 | last reply: Sep 26 '21 by NeoPa
anoble1
Is there a way to do a Date Difference with a Date Serial?
2 replies 4,441 views Question by anoble1 | last reply: Sep 24 '21 by NeoPa
Mailer
1 reply 3,749 views Question by Mortomer39 | last reply: Sep 24 '21 by NeoPa
Access and Quickbooks ODBC
3 replies 4,392 views Question by jimatqsi | last reply: Sep 24 '21 by NeoPa
Create query columns from similar rows
2 replies 7,414 views Question by MC42015 | last reply: Sep 21 '21 by NeoPa
mb60
How to uncheck the check boxes in a single click
13 replies 18,933 views Question by mb60 | last reply: Sep 20 '21 by nico5038
TheSmileyCoder
Problem referring to existing tabledef object
26 replies 16,103 views Question by TheSmileyCoder | last reply: Sep 19 '21 by isladogs
Creating Records with Checkboxes on a form
3 replies 4,566 views Question by ZacharyCook12 | last reply: Sep 17 '21 by NeoPa
Converting SQL to VBA
5 replies 5,114 views Question by soggycashew | last reply: Sep 13 '21 by NeoPa
How to set Primary Key with VBA?
4 replies 24,324 views Question by BarbQb | last reply: Sep 8 '21 by Nordo
DJRhino1175
Open an existing Access Database with Libre Database
7 replies 5,420 views Question by DJRhino1175 | last reply: Sep 3 '21 by NeoPa
import xml files which are in folder and subfolder into access 2010
3 replies 7,728 views Question by haha3 | last reply: Sep 3 '21 by twinnyfo
Create a database in access
1 reply 3,378 views Question by jack1980 | last reply: Aug 30 '21 by NeoPa
Creating a "Last Updated By" field
6 replies 4,559 views Question by HopkinsUni | last reply: Aug 25 '21 by NeoPa
Sum of short time values in report footer
5 replies 3,522 views Question by jackjee | last reply: Aug 16 '21 by NeoPa
Problem comparing dates
9 replies 2,798 views Question by Petrol | last reply: Aug 14 '21 by NeoPa
Need to only run a module if the checkbox is checked
8 replies 5,445 views Question by brittaff | last reply: Aug 9 '21 by NeoPa
Export Table Design to Excel
4 replies 28,899 views Question by redcali55 | last reply: Aug 9 '21 by asadullahmalik
Andrew Thackray
Error 2585 - This action cannot be carried out
19 replies 26,111 views Question by Andrew Thackray | last reply: Aug 6 '21 by kkarbasian
How to show all values in a query iif criteria?
15 replies 31,735 views Question by Michael R | last reply: Aug 3 '21 by HouseHandler
openReport
9 replies 3,415 views Question by bryonone | last reply: Jul 20 '21 by NeoPa
Seth Schrock
Query Performance Improvement
15 replies 3,766 views Question by Seth Schrock | last reply: Jul 14 '21 by Seth Schrock
Leave Calculation MS Access
4 replies 2,685 views Question by Ganie | last reply: Jul 12 '21 by NeoPa
browseto nightmare
8 replies 3,824 views Question by hilmi123 | last reply: Jul 7 '21 by NeoPa
conditional autonumber ID's
2 replies 4,791 views Question by cartemj2 | last reply: Jul 7 '21 by randomDude
Configuring Check Out Button To Update Field Value of another table
1 reply 3,173 views Question by hicksmk2 | last reply: Jul 1 '21 by NeoPa
MS Access to SQL server connection string
4 replies 3,570 views Question by rcsmith0712 | last reply: Jun 29 '21 by NeoPa
Import an Excel Sheet with File Dialog in Access into the table
7 replies 3,612 views Question by Barbara1999 | last reply: Jun 23 '21 by NeoPa
List, form and a search box
3 replies 3,162 views Question by Davism4 | last reply: Jun 18 '21 by NeoPa
ODBC to Progress Database
answer this 2,667 views Question by jimatqsi | last reply: Jun 18 '21 by jimatqsi
Cannot pass data to sql delete criteria
4 replies 3,175 views Question by Eddie2020 | last reply: Jun 16 '21 by isladogs
TheSmileyCoder
Can you force Access to quit when PC goes into Standby mode?
17 replies 6,606 views Question by TheSmileyCoder | last reply: Jun 14 '21 by Rabbit
How do I enter into a From that's under a NavigationControl?
1 reply 1,960 views Question by tgifrank32 | last reply: Jun 14 '21 by NeoPa
convexcube
Disable ribbon, office button & quick access toolbar
21 replies 61,601 views Question by convexcube | last reply: Jun 7 '21 by NeoPa
How to Count Multi Value Field
5 replies 2,890 views Question by Bhagaban | last reply: Jun 3 '21 by NeoPa
Import Text files from multiple folders
4 replies 3,375 views Question by jackjee | last reply: Jun 1 '21 by NeoPa
Access Non-Matching Data Query Not Working
1 reply 2,709 views Question by uknod | last reply: Jun 1 '21 by NeoPa
Hyperlink default folder
5 replies 12,608 views Question by topperfox | last reply: May 31 '21 by Zubair Mughal
ListBox Limit
10 replies 14,808 views Question by suzanne099 | last reply: May 26 '21 by isladogs
make invoice number linked with year access
1 reply 2,943 views Question by ahmedmob | last reply: May 26 '21 by NeoPa
Running DDL scripts
3 replies 7,029 views Question by bmg | last reply: May 18 '21 by NeoPa
RunSQL no longer recognizes RTRIM()
13 replies 2,703 views Question by howard w | last reply: May 18 '21 by NeoPa
Show / Hide Fields
2 replies 2,752 views Question by Prometheus73 | last reply: May 17 '21 by isladogs
Fetching the access table data to form
1 reply 1,887 views Question by Mounika Mallipe | last reply: May 17 '21 by cactusdata
Table normalization problem
14 replies 2,346 views Question by usman4575 | last reply: May 14 '21 by NeoPa
isladogs
Access DevCon 2021
1 reply 2,111 views Question by isladogs | last reply: May 13 '21 by isladogs
Run Time Error (Type Mismatched)
1 reply 1,927 views Question by Aftab Ahmad | last reply: May 12 '21 by NeoPa
Storing automatically populated form field data in tables
3 replies 1,935 views Question by MrBee | last reply: May 10 '21 by NeoPa
Opening a specific record on new form
3 replies 1,917 views Question by usman4575 | last reply: May 9 '21 by NeoPa
create a form to filter iD, name, address in related table
3 replies 1,942 views Question by Httsampath | last reply: May 2 '21 by NeoPa
Setting subreport visibility in Report
6 replies 2,002 views Question by enilc | last reply: Apr 30 '21 by NeoPa
List box and searching
2 replies 2,404 views Question by tgifrank32 | last reply: Apr 21 '21 by isladogs
Copying a Database with linked tables
14 replies 3,479 views Question by EricB | last reply: Apr 20 '21 by isladogs
Randomize
30 replies 4,521 views Question by didacticone | last reply: Apr 19 '21 by didacticone
search feature
1 reply 3,132 views Question by gcdp | last reply: Apr 15 '21 by NeoPa
Form blank after changing properties
1 reply 3,344 views Question by travelerq9 | last reply: Apr 15 '21 by NeoPa
Current Record query from subform not working help!!
14 replies 6,291 views Question by ZKAHADI | last reply: Apr 13 '21 by ZKAHADI
Field list in combo of a table from another combo
4 replies 5,323 views Question by mshakeelattari | last reply: Apr 12 '21 by isladogs
Retrieving Deleted Switchboard form
24 replies 21,320 views Question by saurabhpawar | last reply: Apr 2 '21 by NeoPa
twinnyfo
Using a Class Module to Execute Code
3 replies 3,547 views Question by twinnyfo | last reply: Mar 29 '21 by NeoPa
twinnyfo
Access Front End Bloating?
20 replies 5,277 views Question by twinnyfo | last reply: Mar 25 '21 by NeoPa
SQL VBA Delete statement not working
8 replies 4,030 views Question by Joe Y | last reply: Mar 23 '21 by NeoPa
Deleting an Outlook Appointment in VBA
20 replies 16,694 views Question by Cyd44 | last reply: Mar 19 '21 by mnorton123
SueHopson
Adding Unbound Data to Table
14 replies 4,451 views Question by SueHopson | last reply: Mar 19 '21 by NeoPa
Error 3086
10 replies 6,316 views Question by Anon93 | last reply: Mar 18 '21 by NeoPa
One Item Barcode Copies on one Page
1 reply 2,099 views Question by ZKAHADI | last reply: Mar 16 '21 by isladogs
using command button to copy a record in a field
2 replies 3,226 views Question by tgifrank32 | last reply: Mar 15 '21 by cactusdata
Put data into subform with click on List Box items
8 replies 3,243 views Question by ZKAHADI | last reply: Mar 15 '21 by isladogs
isladogs
VBA code to detect if a password has been changed
30 replies 4,174 views Question by isladogs | last reply: Mar 14 '21 by isladogs
Edit Record on a form using a popup form
3 replies 1,379 views Question by Neruda | last reply: Mar 13 '21 by NeoPa
SueHopson
Adding Time in Calculated Time Fields returning as Strings
37 replies 4,685 views Question by SueHopson | last reply: Mar 10 '21 by Rabbit
isladogs
BUG: deep hiding tables removes data from complex datatype fields
2 replies 1,599 views Question by isladogs | last reply: Mar 10 '21 by isladogs
Serial Number
2 replies 1,563 views Question by osasaosasao | last reply: Mar 10 '21 by NeoPa
isladogs
Components dialog in the VBE
10 replies 2,055 views Question by isladogs | last reply: Mar 7 '21 by isladogs
How to show loan installment in OVERDUE
3 replies 1,608 views Question by Akokoh Joel | last reply: Mar 7 '21 by isladogs
Help with duplicated Entries.
5 replies 1,853 views Question by dalaniz85 | last reply: Feb 21 '21 by NeoPa
compile errors Expected expression
10 replies 8,077 views Question by JEFFREY MUSGRAY | last reply: Feb 19 '21 by isladogs
How to speed-up access to strings
63 replies 4,067 views Question by Ricardo de Mila | last reply: Feb 16 '21 by Ricardo de Mila
Create button to add file location of picture on form in access
17 replies 3,284 views Question by debbie1954 | last reply: Feb 15 '21 by debbie1954
Dynamic Report
14 replies 1,531 views Question by Integrating | last reply: Feb 13 '21 by NeoPa
Copy one row after checkbox is checked from one table to another
7 replies 2,549 views Question by DarkBlue140 | last reply: Feb 12 '21 by isladogs
SueHopson
Using a DropDown Lookup to Populate 2 fields in an Access Query or Form
2 replies 1,691 views Question by SueHopson | last reply: Feb 11 '21 by SueHopson
Form Filter Length
11 replies 2,072 views Question by Neruda | last reply: Feb 9 '21 by NeoPa
Form Reference on Update Query Not Working
10 replies 1,928 views Question by Exiis | last reply: Feb 6 '21 by NeoPa
date Filter on form (3 months, non consecutive)
2 replies 1,638 views Question by Neruda | last reply: Feb 6 '21 by NeoPa
Docmd.openForm
9 replies 3,112 views Question by Neruda | last reply: Feb 5 '21 by Neruda
Calculate age in years and months in Query
16 replies 8,713 views Question by CindySue | last reply: Feb 5 '21 by cactusdata
Do Until Loop not executing email to all records in a recordset
2 replies 1,573 views Question by brookse | last reply: Feb 4 '21 by twinnyfo
Text file to access Table
5 replies 5,955 views Question by rajeevs | last reply: Feb 3 '21 by DavidHP
30 records per Report MS access
22 replies 2,868 views Question by ZKAHADI | last reply: Feb 3 '21 by NeoPa
Years in a Subform Not In Order
5 replies 1,170 views Question by lindadee | last reply: Feb 2 '21 by NeoPa
Dependent Combo Boxes between two tables
3 replies 1,232 views Question by wisper1977 | last reply: Feb 1 '21 by NeoPa
API Connection with MS Access Database : VBA
2 replies 1,742 views Question by Raza12 | last reply: Jan 30 '21 by isladogs
MitchR
Access Query Criteria - working with a Domain "\" user list.
3 replies 1,467 views Question by MitchR | last reply: Jan 30 '21 by NeoPa
Report on 2 Columns and Report Total
28 replies 3,110 views Question by irsmalik | last reply: Jan 28 '21 by isladogs
How to create Balloting of a Housing Project Plots....
4 replies 1,492 views Question by irsmalik | last reply: Jan 28 '21 by twinnyfo
DCount - error finding - Date Criteria
2 replies 1,506 views Question by joaofigu | last reply: Jan 26 '21 by joaofigu
tdw
Using Arrow Keys in Combo Box
6 replies 18,550 views Question by tdw | last reply: Jan 24 '21 by Gangatharran
Finding the location of a report on the screen or window.
12 replies 2,491 views Question by Petrol | last reply: Jan 24 '21 by NeoPa
twinnyfo
Using VBA to determine Adobe Check Box state
61 replies 5,074 views Question by twinnyfo | last reply: Jan 22 '21 by SioSio
How to show a query results in a form detail
1 reply 1,795 views Question by AccessUser22 | last reply: Jan 20 '21 by NeoPa
Extract from string
7 replies 4,338 views Question by jackjee | last reply: Jan 20 '21 by SioSio
Multiple list selection in search form
8 replies 4,209 views Question by munkee | last reply: Jan 20 '21 by orkun
Trying to figure why my . are turning into a #
3 replies 1,837 views Question by CD Tom | last reply: Jan 20 '21 by NeoPa
Combo box not working on a subform
6 replies 2,669 views Question by Petrol | last reply: Jan 16 '21 by isladogs

Follow us! Get the Latest Bytes Updates
By using this site, you agree to our Privacy Policy and Terms of Use.