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
Access VBA
<p>Relational database design, SQL integration, and form logic.</p>
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
May 30, 2013
what is the alternative to NVL function in MS Access 2007
I wrote an SQL query in MS Access select NVL(count(re.rule_status),0) from validation_result re, validation_rules ru where re.cycle_nbr="+cycle_nbr+" and…
thumb_up 7
trending_up 6
Solved
May 20, 2013
C# AND ACCESS – Data type mismatch in criteria expression
I've created a code that updates/edits details of a/an computer/electronic product for a C# program connecting to the MS Access. Here are the codes:…
thumb_up 10
trending_up 2
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
December 31, 2012
SQL LIKE operator with parameters and wildcards
I have a query where I want to return all Clients that have a certain string in the name with wildcards on either side.…
thumb_up 5
trending_up 6
Solved
November 29, 2012
Wrong number of arguments with SQL ISNULL() on Access DB
I have this query in VB application on Access DB: SELECT DISTINCT Specialization, MAX(a.faultZone) AS faultZone, ISNULL(a.faultCount, 0) AS NoOfFaults FROM Technicians AS t…
thumb_up 7
trending_up 5
Solved
November 7, 2012
Combine values from related rows into a single concatenated string value
I'm trying to aggregate some instructor data (to easily show which courses an instructor taught in a semester), and up until now I've just…
thumb_up 9
trending_up 5
Solved
October 22, 2012
bound and unbound controls in ms access
What is the difference between bound and unbound controls in MS Access? How do they differ? And when on an MS Access Form in…
thumb_up 9
trending_up 4
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