Solved
October 24, 2014
Passing arguments to Access Forms created with ‘New’
I have a form called 'detail' which shows a detailed view of a selected record. The record is selected from a different form called…
thumb_up 9
trending_up 3
access-vba
12 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.
Solved
February 13, 2014
ByRef Argument type mismatch with Boolean
I have some vba code in an Access form which produces a "ByRef Argument type mismatch" error when called under the following circumstances. I…
thumb_up 9
trending_up 2
Solved
December 6, 2013
Inserting data to Access Duplicate Data Error
I have wrote some vbscript that updates all new fields in one access database from a table in another database however I am having…
thumb_up 4
trending_up 8
Solved
June 25, 2013
VBA: Why must I set focus to control every time?
I am creating a personal Library Inventory system using an Access 2007 database. In code, whenever I reference the .Text property of a form…
thumb_up 15
trending_up 5
Solved
June 21, 2013
MS Access RunCode Macro cannot find my procedure
I'm only posting this since I wasn't able to find a solution anywhere. I finally figured it out. Kind of silly really. When using…
thumb_up 15
trending_up 7
Solved
June 12, 2013
Equivalent cURL in VBA?
I have an API for my application which allows me to make cURL requests to it. I need to implement this into VBA so…
thumb_up 14
trending_up 6
Solved
March 11, 2013
Loop through all unbound controls on a form and clear data
I would like to loop through all UNBOUND controls on my form and clear their data or reset their values. I have textboxes, comboboxes…
thumb_up 11
trending_up 2
Solved
September 17, 2012
VBA Code to Close an Access Database Without Leaving a Shell of the application open
I'm currently using Application.Quit which leaves a shell of the MS Access Application open. After processing the calling function against the target application, I…
thumb_up 7
trending_up 7
Solved
May 7, 2012
Invalid Use of Property?
I am working with an Access database and it has a form and VBA behind it. It has been quite a while since I…
thumb_up 7
trending_up 3
Solved
January 10, 2011
Retrieve column values of the selected row of a multicolumn Access listbox
How can I retrieve the value of specified column of the selected row in a multicolumn listbox? I populate the listbox by setting the…
thumb_up 12
trending_up 9