473,385 Members | 1,470 Online

Home Posts Topics Members FAQ

home > topics >

Microsoft Access / VBA Questions

newest replies last post views AllQuestionsArticles

+ Ask a Question

Access Announcements

question by: NeoPa | last post Feb 7 '22 by: isladogs

How to ask "good" questions -- READ BEFORE SUBMITTING A QUESTION!

question by: NeoPa | last post May 8 '16 by: NeoPa

POSTING_GUIDELINES: Please Read Carefully Before Posting to a Forum

question by: PEB | last post Jan 21 '07 by: MMcCarthy

Overlay image on a report

question by: jimatqsi | last post 1 Week Ago by: coldbluts

How to disable "Do you want to allow this website to open an app?"

question by: Aftab Ahmad | last post 3 Weeks Ago by: NeoPa

Batch Import text files to Access

question by: gdaniels | last post Feb 28 '24 by: cactusdata

Automate a search field into a web page hyperlink??

question by: davi5007 | last post Feb 16 '24 by: cactusdata

Why is Me. suddenly not Okay?

question by: jimatqsi | last post Jan 16 '24 by: NeoPa

Cannot edit or delete rows of linked MS SQL table from MS Access

question by: efe2023 | last post Dec 26 '23 by: jimatqsi

Applying ComboBox filters Sequentially

question by: SueHopson | last post Dec 8 '23 by: NeoPa

Take a Database to the Next Level

question by: GKJR | last post Dec 5 '23 by: NeoPa

Finding a record, and then saving a new record after the record has been amended.

question by: nia12 | last post Nov 1 '23 by: NeoPa

Report value list

question by: Teri B | last post Oct 26 '23 by: NeoPa

Send Current Object to PDF

question by: NeoPa | last post Oct 16 '23 by: NeoPa

Windows 11 and Access Combo Box Issue

question by: DJRhino | last post Sep 15 '23 by: DJRhino

I would like to get rank by using ms access

question by: Samuel Wekesa | last post Sep 15 '23 by: isladogs

How to attach a File to a subform?

question by: ielamrani | last post Sep 15 '23 by: NeoPa

To verify entry of a dropdown

question by: DJRhino | last post Sep 14 '23 by: NeoPa

Cancel Print Action if Sub form has No Records

question by: DJRhino1175 | last post Sep 13 '23 by: NeoPa

How to resize subform after using source object to change source in vba

question by: Wanie2023 | last post Sep 2 '23 by: isladogs

Error when using DoCmd.SendObject ac

question by: CRAZImat | last post Aug 17 '23 by: NeoPa

how to lock a combo box in a form after selecting data

question by: eilaw | last post Aug 8 '23 by: NeoPa

MS Access Linking to SharePoint not showing all columns

question by: anoble1 | last post Aug 1 '23 by: Nauticalgent

How to send live message and notification to all the Access Database frontend users

question by: iamroshm | last post Jul 12 '23 by: iamroshm

Referencing a control on a tabbed form

question by: RonFreudenheim | last post Jun 16 '23 by: NeoPa

Hide Labels depending on checkbox value

question by: ezappsrUS | last post Jun 13 '23 by: NeoPa

In Access - History for each User

question by: F22F35 | last post Jun 11 '23 by: NeoPa

question by: sjohnson | last post Jun 8 '23 by: stefanzare

Datasheet Form, iterate through records

question by: Johno34 | last post Jun 7 '23 by: jimatqsi

Problems to capture mouse_down event on a control within a form with lots of controls

question by: Ricardo de Mila | last post Jun 7 '23 by: jimatqsi

MSGBox win conditional Formatting is True

question by: DJRhino1175 | last post May 27 '23 by: isladogs

Text file to access Table

question by: ChelseaNaomi | last post May 25 '23 by: isladogs

Command button to go to previous record in an Unbound combo box

question by: Aviqq | last post May 24 '23 by: Aviqq

default the find box to match "Any part of field"

question by: matthardwick | last post May 16 '23 by: TheoKrane

Using Update query to change a part of a value?

question by: Ms Rusty Boyd | last post May 3 '23 by: rokgod7

Advancing unbound combo box

question by: Rig20 | last post Apr 28 '23 by: jimatqsi

Open an Excel spreadsheet after it has been exported from Access

question by: glat | last post Apr 25 '23 by: glat

how to add multiple recode in one data entry

question by: AJIT VYAS | last post Apr 22 '23 by: XPS35

Reserved error (-1524); there is no message for this error.

question by: NyaguraM | last post Apr 21 '23 by: isladogs

Problem referring to existing tabledef object

question by: TheSmileyCoder | last post Apr 21 '23 by: isladogs

BeforeUpdate event running but record not being saved

question by: gbyerly | last post Apr 15 '23 by: NeoPa

Data Validation when using a Close button

question by: SueHopson | last post Apr 14 '23 by: SueHopson

Alternate colors in an Unbound Continuous Form

question by: SueHopson | last post Apr 12 '23 by: SueHopson

Passing a new CustID back to a ComboBox and Requery/Refresh the form.

question by: SueHopson | last post Apr 12 '23 by: SueHopson

Need help normalizing a table(s) in MS Access 2007

question by: AshAccess | last post Apr 9 '23 by: NeoPa

Set focus but record not selected

question by: donraf | last post Mar 30 '23 by: NeoPa

recover deleted records in MS access database

question by: Dharmasiri | last post Mar 30 '23 by: isladogs

MS Access Query Criteria

question by: Computer0300 | last post Mar 29 '23 by: NeoPa

Group serial number

question by: Bright1Light | last post Mar 23 '23 by: cetpainfotech

My custom serial number reach number 10 then stop

question by: Bright1Light | last post Mar 19 '23 by: Bright1Light

Button hover shadow

question by: Bright1Light | last post Mar 13 '23 by: isladogs

How to create a custom shortcut menu command

question by: bounthong | last post Mar 9 '23 by: NeoPa

Access Front End Bloating?

question by: twinnyfo | last post Mar 9 '23 by: NeoPa

Automatically Relink Frontend to 2 Backends via form

question by: bobbyer | last post Mar 3 '23 by: NeoPa

how to sending mail each person with query result

question by: Shanfe | last post Mar 2 '23 by: Shanfe

Microsoft Access Run-time Timer Event No Firing

question by: DJRhino1175 | last post Feb 14 '23 by: DJRhino1175

I am unable to connect to an SQL Azure database through OBDC in Access. What am I do

question by: sdcoates | last post Feb 10 '23 by: cetpainfotech

Calculating Rate hours for late shift running after midnight

question by: Sullster47 | last post Feb 8 '23 by: NeoPa

How to format multiple sheets in Excel?

question by: anoble1 | last post Feb 8 '23 by: NeoPa

Generating and Export pdf files keep overwriting existing files

question by: aharleston | last post Feb 8 '23 by: NeoPa

Can someone tell me why this insert query is not working

question by: bsorge | last post Feb 1 '23 by: NeoPa

using the docmd.gotorecord command

question by: CD Tom | last post Jan 25 '23 by: NeoPa

Difficulty in Creating a Delete Query

question by: Petrol | last post Jan 25 '23 by: NeoPa

Insert into and default fields

question by: SueHopson | last post Jan 18 '23 by: SueHopson

Access Report to Send to Multiple Recipients

question by: kjhyder | last post Jan 17 '23 by: kjhyder

Access User Group – Europe

question by: isladogs | last post Jan 7 '23 by: isladogs

Need to divide a group

question by: CD Tom | last post Dec 21 '22 by: NeoPa

Updating values in Table1 based on date condition from Table2

question by: Oleksandr | last post Dec 16 '22 by: XPS35

Refresh a specific subform

question by: YollemCrumble | last post Dec 9 '22 by: NeoPa

Not able to paste full string from database into excel

question by: anoble1 | last post Dec 6 '22 by: NeoPa

Double Booking Code needs a little extra jazz

question by: DanicaDear | last post Nov 22 '22 by: NeoPa

Where Clause with Multiple Criteria

question by: Aftab Ahmad | last post Nov 20 '22 by: Aftab Ahmad

Recurring Events and the Task Manager

question by: Debbieto | last post Nov 20 '22 by: NeoPa

MS Access VBA Password

question by: Aftab Ahmad | last post Nov 19 '22 by: NeoPa

Get The Minimum Value From A Textbox

question by: Curious27 | last post Nov 17 '22 by: Curious27

Access Backend Cloud

question by: Joe Y | last post Nov 15 '22 by: NeoPa

ComboBox Selection to PDF

question by: Curious27 | last post Nov 9 '22 by: Curious27

How do you combine 2 items in a Group By while doing a Crosstab query?

question by: anoble1 | last post Nov 2 '22 by: NeoPa

RS Object invalid or no longer set (hair pulling out)

question by: WannaKatana2 | last post Oct 29 '22 by: NeoPa

Syntax error 3075 when typing name with apostrophe in form

question by: eseng | last post Oct 28 '22 by: jameswalter

Deleting Duplicate Records in Access 2016

question by: EverettMiller | last post Oct 28 '22 by: jameswalter

Comparing two field values in access vba

question by: hydra69 | last post Oct 27 '22 by: NeoPa

Sending email through Access from secondary email address

question by: kjhyder | last post Oct 26 '22 by: ylimejoy27zv

Run Time Error (Type Mismatched)

question by: Aftab Ahmad | last post Oct 26 '22 by: NeoPa

Runtime Error 2487

question by: DJRhino1175 | last post Oct 24 '22 by: NeoPa

Clearing invalid date from a combo box

question by: Petrol | last post Oct 24 '22 by: zmbd

question by: birdlegs | last post Oct 23 '22 by: NeoPa

Match two fields in a table against a combo box selection and a text box entry / 2 fields on a form.

question by: Davism4 | last post Oct 23 '22 by: NeoPa

question by: bibo1dd | last post Oct 23 '22 by: NeoPa

Sub report with pass thru datasource

question by: PCGram | last post Oct 4 '22 by: PCGram

Comparing user input date in a form with a date which is stored in another form (and therefore its database)

question by: accecssuser | last post Sep 29 '22 by: isladogs

Inactive Record Transaction

question by: Usman55 | last post Sep 27 '22 by: XPS35

Duplicate Main form & Sub form "Run-time error '3022'

question by: Mick3911 | last post Sep 23 '22 by: ADezii

Button to open form where ID=ID, and setfocus on a certain control

question by: MNewby | last post Sep 21 '22 by: NeoPa

Using Access VBA to update Outlook

question by: didacticone | last post Sep 21 '22 by: NeoPa

ComboBox Columns & Blanks

question by: Curious27 | last post Sep 17 '22 by: NeoPa

How to use TransferSpreadsheet to transfer query data to Excel Template selected rows

question by: sheikhsab | last post Sep 16 '22 by: sheikhsab

how to get the dates from different Dropdown list options

question by: sheikhsab | last post Sep 16 '22 by: NeoPa

Calculate first and last day of week

question by: CDeCinko | last post Sep 16 '22 by: ahmadMBAAAA

Error message I don't understand

question by: CD Tom | last post Sep 16 '22 by: NeoPa

Report Losing Group Count

question by: Curious27 | last post Sep 13 '22 by: Curious27

CurrentDb.Properties("MDE")

question by: PhilOfWalton | last post Sep 8 '22 by: NeoPa

Data type for .Value in MVF

question by: Spuds | last post Sep 7 '22 by: isladogs

Calculating ComboBox Columns

question by: Curious27 | last post Sep 3 '22 by: NeoPa

Import excel into database

question by: CD Tom | last post Aug 31 '22 by: CJ_London

SubForm Problem

question by: Curious27 | last post Aug 28 '22 by: NeoPa

If subroutine to get Now() value in date controls on parent form depending on an action on the subform

question by: MNewby | last post Aug 27 '22 by: NeoPa

Open and read a serial Com Port connected to a scanner

question by: neelsfer | last post Aug 25 '22 by: serialcomms

Taking value from a control in a form and place that value in a field in another table.

question by: MNewby | last post Aug 24 '22 by: NeoPa

Refresh or requery parent form's source data when tabbing to a new record in the subform

question by: MNewby | last post Aug 23 '22 by: NeoPa

Two Experts Meet

question by: CJ_London | last post Aug 18 '22 by: CJ_London

Insert Existing Fields to a Form through code or macro

question by: jithb4u | last post Aug 18 '22 by: NeoPa

Trying to do OpenRecordset and Getting a "Too Few Parameters" Error

question by: sleach | last post Aug 17 '22 by: NeoPa

How to find the controls on different forms or reports having same tag?

question by: mshakeelattari | last post Aug 15 '22 by: isladogs

Opening ms access report based on dates

question by: OSWOM | last post Aug 9 '22 by: NeoPa

New Access MVP Colin Riddington (isladogs)

question by: NeoPa | last post Aug 9 '22 by: isladogs

How to remove quick access toolbar from access application

question by: mshakeelattari | last post Aug 4 '22 by: nata4444

Automatically modify date field in Form

question by: Videot7 | last post Aug 4 '22 by: NeoPa

Automate macros in 20 access database files

question by: hansy | last post Aug 3 '22 by: hansy

Like Filter in Query Based Form

question by: DJRhino1175 | last post Aug 2 '22 by: NeoPa

Microsoft Access 2000

question by: buchert1 | last post Aug 2 '22 by: buchert1

I can not connect my access database to sharepoint site

question by: MoonNbl | last post Jul 21 '22 by: zmbd

How to export Access data to Quickbooks?

question by: Susan Littlefie | last post Jul 20 '22 by: Willjoe

Can't open 2019 accdb in 2016!!

question by: ScudaMcGruder | last post Jul 15 '22 by: NeoPa

Subtract records from two different tables

question by: Fomson | last post Jul 15 '22 by: NeoPa

Crosstab query for time duration from 2 fields

question by: jackjee | last post Jul 1 '22 by: CJ_London

Sending Unique Emails to Distinct Recipeints

question by: kjhyder | last post Jun 1 '22 by: zmbd

Problem with Chart Data ....

question by: irsmalik | last post May 30 '22 by: NeoPa

Combo Box, Option Group and Check Box all in One Form

question by: irsmalik | last post May 27 '22 by: isladogs

question by: Korara | last post May 27 '22 by: zmbd

question by: Eliasendashaw | last post May 21 '22 by: ADezii

Access unable to save backup or make .accde

question by: Petrol | last post May 18 '22 by: Petrol

Combining Rows-Opposite of Union

question by: LoneStar | last post May 18 '22 by: NeoPa

Calculating Retirement Date from DOB in an Employee Table

question by: nityanda10 | last post May 11 '22 by: cactusdata

Calculated Form Field, with Criteria?

question by: ScudaMcGruder | last post Apr 30 '22 by: zmbd

Converting date in a form

question by: Machi413 | last post Apr 29 '22 by: zmbd

MS Access crashes when subform is on a tab control AND calculated control used.

question by: MariaTorvalds | last post Apr 27 '22 by: ShutterBug

Credit card payments

question by: Raizyros | last post Apr 27 '22 by: isladogs

Need Correct Syntax for moving data from a Record in a table to a form

question by: Zinenagetto | last post Apr 22 '22 by: zmbd

Having a problem with query criteria coming from a subform

question by: ajhayes | last post Apr 21 '22 by: NeoPa

Need help setting a validation rule. Microsoft Access

question by: jess4444 | last post Apr 16 '22 by: zmbd

Adding a calculated field from a stored query to a new query

question by: jrol | last post Apr 15 '22 by: zmbd

Using DateAdd with ODBC drivers

question by: JXWD | last post Apr 15 '22 by: NeoPa

InStrRev Not Giving Correct Results

question by: Vaulcul | last post Apr 13 '22 by: WannaKatana2

Continuous Form #Error On New Record

question by: SunnyTaru | last post Apr 3 '22 by: NeoPa

question by: TMatharu | last post Apr 2 '22 by: NeoPa

Continuous Form #Error On New Record (Closed)

question by: TMatharu | last post Apr 2 '22 by: NeoPa

Default Shortcut Menu

question by: EnglishMon | last post Mar 31 '22 by: Mia White

End a loop error

question by: DJRhino1175 | last post Mar 24 '22 by: NeoPa

How to display all group headers even if there is not data for that group?

question by: cjyoung22 | last post Mar 23 '22 by: NeoPa

Check that date range has no dates in another existing date range: overlapping dates

question by: DanicaDear | last post Mar 21 '22 by: NeoPa

question by: Lou699 | last post Mar 21 '22 by: DanicaDear

Having trouble updating a recordset

question by: Wazza0161 | last post Mar 17 '22 by: NeoPa

Keeping Track of New Records

question by: markld68 | last post Mar 9 '22 by: GazMathias

Create Summary Report With 7 reports

question by: Usman55 | last post Mar 4 '22 by: NeoPa

Store Multiple Image Paths with one command button

question by: AS Mughal | last post Feb 25 '22 by: NeoPa

Ability to Create/Print Report from User Filtered Sub-form

question by: Tamille2020 | last post Feb 25 '22 by: NeoPa

question by: igop | last post Feb 23 '22 by: isladogs

Report Filtering

question by: williamson1979 | last post Feb 21 '22 by: NeoPa

Set Visibility of Subform controls

question by: williamson1979 | last post Feb 20 '22 by: williamson1979

question by: Alireza355 | last post Feb 19 '22 by: Freddyboy

Is it possible to indent a memo field?

question by: Thomas Bea | last post Feb 18 '22 by: NeoPa

UK Access User Group (AUG) Seminar

question by: isladogs | last post Feb 7 '22 by: isladogs

starting and stopping dragon naturally speaking from MS Access

question by: jackiemasson | last post Feb 7 '22 by: isladogs

How to add "Continued...." if rows go to next page or column on a report?

question by: mshakeelattari | last post Feb 6 '22 by: NeoPa

Prevent Duplicate Entry within a Month

question by: Usman55 | last post Jan 22 '22 by: isladogs

Opening a Macro in Design View

question by: jkwok | last post Jan 20 '22 by: isladogs

Need to modify existing code in order to transfer *string* values (vs. numeric values)

question by: skydivetom | last post Jan 18 '22 by: jimatqsi

Append Query trying not to add duplicate records to new table

question by: anoble1 | last post Jan 16 '22 by: isladogs

Opening Balance

question by: Kwabena10 | last post Jan 15 '22 by: NeoPa

When inventory is not yet sold

question by: cmo187265 | last post Jan 14 '22 by: cmo187265

Undesired #Name? Result

question by: Waqarahmed | last post Jan 12 '22 by: NeoPa

Many many to many headscratchers

question by: cmo187265 | last post Jan 5 '22 by: cmo187265

Form not opening completely

question by: Petrol | last post Dec 31 '21 by: NeoPa

How to control exit from the Access application

question by: Petrol | last post Dec 30 '21 by: Petrol

Crosstab query based form data update

question by: jackjee | last post Dec 24 '21 by: isladogs

ComboBox is not Refreshing the List after the Change event.

question by: Ademar | last post Dec 12 '21 by: isladogs

Custom right click menu strange behavior

question by: Seth Schrock | last post Dec 9 '21 by: NeoPa

Concantenate Numbers and Text in Query

question by: jerryg72 | last post Dec 6 '21 by: NeoPa

Open Another Database from a Form

question by: JamesNapier | last post Nov 30 '21 by: NeoPa

Shrinking/Stretching Forms

question by: tridza | last post Nov 20 '21 by: isladogs

Grouping and Sorting a report or form, Please Help

question by: tbutler | last post Nov 18 '21 by: NeoPa

How to Convert Text Dates to Date format

question by: NeoPa | last post Nov 16 '21 by: NeoPa

Too many, many to many?

question by: cmo187265 | last post Nov 15 '21 by: NeoPa

Refresh Calculated Value on Main form as data is input into subform

question by: AccessLM | last post Nov 3 '21 by: NeoPa

Sending email with attachment using Sendobject & Thunderbird client

question by: ACB64 | last post Nov 1 '21 by: GazMathias

Adding values for a period of time in access database

question by: Musoke Herbert | last post Oct 30 '21 by: cactusdata

Access will not show compile error on Button_Click in form

question by: byggarebob123 | last post Oct 29 '21 by: isladogs

Is MS Access Worth Learning in 2021?

question by: MGadAllah | last post Oct 29 '21 by: NeoPa

Disable Print Button

question by: Darius9023 | last post Oct 27 '21 by: GazMathias

How to Clear Form Controls for Next Entry

question by: bloukopkoggelmander | last post Oct 23 '21 by: NeoPa

Insert Into query using VBA

question by: omozali | last post Oct 23 '21 by: NeoPa

HIDE / SHOW OF FORMS in MS Access

question by: kartikss | last post Oct 23 '21 by: NeoPa

How to Calculate opening balance in all ledger accounts

question by: SheikhAltaf | last post Oct 18 '21 by: NeoPa

Where are Access icons located?

question by: wvmitchell | last post Oct 12 '21 by: NeoPa

Duplicate record on form including subform records and multivalued fields

question by: MinkeAccess | last post Oct 10 '21 by: isladogs

Access VBA - Filtered query - Export each row as unique excel workbook - build button at each row to navigate to workbook

question by: gdford | last post Sep 30 '21 by: NeoPa

Left join on three fields giving strange results

question by: Seth Schrock | last post Sep 29 '21 by: Seth Schrock

auto table update of mysql database from access database

question by: ridwan | last post Sep 28 '21 by: Check1123

Required field / error with null value / can't move focus

question by: kiwipedia | last post Sep 28 '21 by: jordimarsa

Delete all records from multiple tables in one shot

question by: Alireza355 | last post Sep 26 '21 by: NeoPa

Is there a way to do a Date Difference with a Date Serial?

question by: anoble1 | last post Sep 24 '21 by: NeoPa

question by: Mortomer39 | last post Sep 24 '21 by: NeoPa

+ Ask a Question

1
2
3
11
>
Last »

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap

Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!