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
<p>Relational database design, SQL integration, and form logic.</p>
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
January 20, 2014
No read permission on MSysObject error
I am trying to connect to an MS Access database (.mdb) through OleDb. My query is SELECT * FROM ListQueries which fetches me the…
thumb_up 8
trending_up 5
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
October 31, 2013
VS 2012.3 Referencing MS Access COM DLL, could not resolve COM reference error
I created a new Console project in VS2012.3 (32bit exe) and added a COM Type Library reference to Microsoft Access (I tried both 2003…
thumb_up 7
trending_up 4
Solved
October 24, 2013
Access SQL syntax error when using OleDbCommandBuilder
I am going to INSERT data in Access Database using OleDbDataAdapter in C# but i got an error with message Syntax Error in INSERT…
thumb_up 10
trending_up 3
Solved
October 17, 2013
MS-Access – you tried to execute a query that does not include the specified aggregate function
SELECT SUM(orders.quantity) AS num, fName, surname FROM author INNER JOIN book ON author.aID = book.authorID; I keep getting the error message: "you tried to…
thumb_up 17
trending_up 9
Solved
July 3, 2013
Trouble writing to database in C# WinForm Application
I'm relatively inexperienced with professional programming, but I'm trying to write a program that interfaces with a MS Access Database. Essentially I'm gathering information…
thumb_up 7
trending_up 3
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 24, 2013
Row numbers in query result using Microsoft Access
I always use this query in sql server to get Row number in a table: SELECT * FROM (SELECT *, Row_number() OVER( ORDER BY…
thumb_up 8
trending_up 5