Highest Voted 'ms-access' Questions - Page 4 - Stack Overflow

Questions tagged [ms-access]

Microsoft Access, also known as Microsoft Office Access, is an application development and database development tool from Microsoft. It combines the Microsoft Jet/ACE Database Engine with a graphical user interface and software-development tools. Other database engines, such as SQL Server, can also be used as a database server for Access applications.

Filter by
Sorted by
Tagged with
18
votes
3answers
48k views

Create a query dynamically

Hi I need to create a query in MSAccess 2003 through code (a.k.a. VB) -- how can I accomplish this?
18
votes
7answers
32k views

Is it possible to create a recursive query in Access?

I have a job table Id ParentID jobName jobStatus The root ParentID is 0. Is it possible in Access to create a query to find a root for a given job? The database is MDB with no linked tables. The ...
18
votes
11answers
36k views

Parse CSV, ignoring commas inside string literals in VBA?

I have a VBA application that runs every day. It checks a folder where CSVs are downloaded automatically, and adds their contents to a database. When parsing them, I realized that certain values had ...
18
votes
3answers
116k views

How to open Form in Add record

I have a form to input records to a table. I would like it to open on an empty add (New) instead of displaying the first record of the table. To be used by a Navigation Form which opens the input ...
18
votes
3answers
116k views

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 RowSource property with a SQL string. BoundColumn set to value 1. ...
18
votes
9answers
28k views

How to open an .accdb file in Ubuntu?

The development machine I work on has Ubuntu Jaunty Jackalope as its operating system. I have been presented with data for a project I'm working on in the form of an .accdb file created by Microsoft ...
18
votes
3answers
19k views

Do we have transactions in MS-Access?

I am developing a small desktop application using C#.NET and MS-Access. I don't have any prior experience of MS-Access. I want to know if we can use transactions in Ms-Access or not. I have the below ...
18
votes
2answers
70k views

UPDATE statement with multiple WHERE conditions

I'm trying to run an UPDATE query in Access with different WHERE conditions: UPDATE Table1 SET [Ticker] = "TXSFI" WHERE [Acct Numb] like "*03", SET [Ticker] = "TESEI" WHERE [Acct Numb] like "*04"; ...
18
votes
4answers
50k views

Insert record into table if entry does not exist in another table- with an extra twist

Hi to all you mighty SQLsuperheros out there.. Can anyone rescue me from imminent disaster and ruin? I'm working with Microsoft Access SQL. I'd like to select records in one table (table1) that don't ...
18
votes
1answer
18k views

Libraries for connecting node.js to odbc on Windows? [closed]

I'm looking for a library that allows node.js to connect to ODBC on windows. All the libraries I have found thus far seem to work with UnixODBC but not windows, can someone please suggest a library ...
18
votes
3answers
19k views

Nested INNER JOIN vs INNER JOIN vs WHERE: correctness, performance, clarity for a particular case (not a typical JOIN vs WHERE issue)

I'm studying inner joins and I´m a old WHERE SQL-92 man. I'd like to know the implications and understand how it works. So this is just a theoretical question about SQL joins. Is this... SELECT * ...
18
votes
1answer
1k views

ODBC problems in SQL 2000 --> 2005 Upgrade

This wiki post outlines both a problem and a solution. I wanted to post this for others that may be having similar problems, as I couldn't find anything specifically to solve this problem elsewhere. ...
17
votes
7answers
95k views

Using MsgBox without pausing the application

I need to display a message to the user. When I do this using MsgBox, the program stops until the user clicks the box away. I'd like to know if there's a way to open the MsgBox without pausing the ...
17
votes
13answers
12k views

Is MS Access (JET) suitable for multiuser access?

I have a product designed to be a desktop product using MS Access file as a DB. Now, some users need to install it in a few PCs (let's say 2 or 3) and SHARE the database. I thought to place the MS ...
17
votes
6answers
19k views

Debug a bad DLL calling convention

How do I debug a bad DLL calling convention error in MSAccess VBA code? I made some changes to a function in a module and then got the error. How do a debug it to find the cause? The error occurs on ...
17
votes
6answers
19k views

Exporting MS Access Forms and Class / Modules Recursively to text files?

I found some code on an ancient message board that nicely exports all of the VBA code from classes, modules and forms (see below): Option Explicit Option Compare Database Function SaveToFile() ...
17
votes
6answers
60k views

How can you check for null in a VBA DAO record set?

I have an optional field in a database that I'm pulling out using a DAO Record Set. I need to check whether or not the field is set before I concatenate it with other fields. So far I have the ...
17
votes
9answers
27k views

Managing and debugging SQL queries in MS Access

MS Access has limited capabilities to manage raw SQL queries: the editor is quite bad, no syntax highlighting, it reformats your raw SQL into a long string and you can't insert comments. Debugging ...
17
votes
5answers
343k views

Call a VBA Function into a Sub Procedure

I know this is a simple question for someone out there, but I have never really used function module at all because I did not understand what they were. So I have a whole bunch of things I can use ...
17
votes
14answers
95k views

How to List Field's Name in table in Access Using SQL

Can you please let me know if it is possible to list all fields name in a MS Access table?
17
votes
5answers
97k views

Passing parameters between forms in MS Access

I have created a login form named login where the username is typed into the txtEmployee textbox, and I need to display the same in the second page in another form in MS Access.
17
votes
1answer
22k views

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 control, whether it be changing the value, or simply ...
17
votes
3answers
15k views

OleDbCommand parameters order and priority

I have been debugging this query for the last 40 minutes, and the problem apparently is the order of the parameters after all. SELECT * FROM tblSomeThing WHERE id = @id AND debut = @dtDebut AND fin = ...
17
votes
7answers
37k views

Purpose of using sub routines over functions

I've been working with Access for a while now, and although I understand the obvious benefit of a Function over a Sub, been that it can return values as a result, I'm not sure as to why I should use a ...
17
votes
5answers
26k views

How can I use hibernate with MS Access?

I want to use hibernate with MS Access. Which dialect should I use and can you give me a sample hibernate configuration file with MS Access?
17
votes
1answer
31k views

How do I find the current path (directory) of a MS Access database?

I am writing VBA within my Access database and I need to reference the containing directory of this database. This path could change since I will be moving the database around.
17
votes
3answers
56k views

How to loop through all Tables in an MS Access DB

I need to read the properties of over 100 tables in an Access 2003 database and write those details - table name, field name, type and size - to a file for further documentation. I can find nothing ...
17
votes
3answers
28k views

How to search through VBA code files

I just started a job with a new company where previous developers had created many automated tasks. Of course, there is virtually no documentation and I didn't have a chance to work with the previous ...
17
votes
1answer
60k views

how to use LIMIT in query of MS ACCESS 2007

I have created some queries in MS Access 2007. they are giving error if I use LIMIT in query. Can anyone help me out in this? How to use LIMIT in MS Access 2007 query?
17
votes
5answers
61k views

Select multiple (non-aggregate function) columns with GROUP BY

I am trying to select the max value from one column, while grouping by another non-unique id column which has multiple duplicate values. The original database looks something like: mukey | ...
17
votes
8answers
35k views

How to read data from Microsoft Access .accdb database files into R?

The RODBC documentation suggests it is possible, but I am not sure how to read data from a Microsoft Access (the new .accdb format) file with this package into R (on Debian GNU/Linux). The vignette ...
16
votes
10answers
44k views

Linked Access DB “record has been changed by another user”

I'm maintaining a multiuser Access 2000 DB linked to an MSSQL2000 database, not written by me. The database design is very poor, so you'll have to bear with me. On the 'Customer' form there's a '...
16
votes
3answers
14k views

How to destroy an object

It seems that Set Object = Nothing didn't destroy the Fs Object in this code: Sub Test2() Dim Fs As New FileSystemObject Set Fs = Nothing MsgBox Fs.Drives.Count ' this line works End Sub ...
16
votes
11answers
203k views

How to replace blank (null ) values with 0 for all records?

MS Access: How to replace blank (null ) values with 0 for all records? I guess it has to be done using SQL. I can use Find and Replace to replace 0 with blank, but not the other way around (won't "...
16
votes
3answers
68k views

SQL Updating from an inner join

I'm using microsoft Access. If this query: (SELECT FERMENT.FermentId FROM FERMENT INNER JOIN [BELGIUM BEER] ON FERMENT.FermentName = [BELGIUM BEER].FermentId ORDER BY [BELGIUM BEER].BeerId) a ...
16
votes
4answers
63k views

Running Microsoft Access as a Scheduled Task

I am seeking comments on how to schedule auto updates of a database (.accdb) since I am not very comfortable with the process I have set up. Currently, it works as follow: Task Scheduler calls a ....
16
votes
2answers
87k views

Unrecognized database format'C:\…\Employees.accdb for Microsoft Access Database File?

I am trying to access a file stored in a Microsoft Access database. (I am working in Visual Studio 2012) I chose the Database source type, and the Dataset database model, when it asks me "which data ...
16
votes
3answers
120k views

Access 2010 VBA query a table and iterate through results

I have a query that I want to execute against a table. With the results I want to do something. In my head the pseudo code is: var q = "select * from table where some condition"; var results = db....
16
votes
1answer
25k views

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 my desktop database can fire CURL requests to my web app. curl -i --user admin@admin....
16
votes
1answer
78k views

How to save the result of a SQL query into a variable in VBA?

I want to execute a select statement and put the result of it (which is only 1 record with 1 value) in a variable. This is in VBA code in access. Private Sub Child_Click() Dim Childnummer As ...
16
votes
7answers
42k views

changing “Tab Control” color

How can I change the background color of a Tab Control. I changed the forms color, but the tabs stay the same. Thanks.
16
votes
2answers
40k views

Convert Access TRANSFORM/PIVOT query to SQL Server

TRANSFORM Avg(CASE WHEN [temp].[sumUnits] > 0 THEN [temp].[SumAvgRent] / [temp].[sumUnits] ELSE 0 END) AS Expr1 SELECT [temp].[Description] ...
16
votes
3answers
42k views

MS Access trigger?

I have two tables named [Insert_Record] and [Delete_Record] in MS Access. Both tables have the same fields but one table has records whereas another table has no record. Question: I want, whenever I ...
16
votes
4answers
6k views

how can I simulate network latency on my developer machine?

I am upsizing an MS Access 2003 app to a SQL Server backend. On my dev machine, SQL Server is local, so the performance is quite good. I want to test the performance with a remote SQL Server so I can ...
16
votes
3answers
7k views

Hard to debug “Mysql server has gone away”

I'm running a MsAccess with Mysql background database and today I am experiencing some problems. Depending on how far I can get into the program I am able to get a list of all the names and entry. ...
15
votes
3answers
84k views

Access-SQL: Inner Join with multiple tables

i have multiple tables in a database: tblOjt ID studentid courseid companyid addresseeid dateadded datestarted dateended ojthours 1 3 1 1 ...
15
votes
2answers
41k views

ms access - vba: Compile Error: expected: =

I have a subroutine as below Public Sub updateStagesTable(sName As String, percentageValue As Double) stageName = "'" & sName & "'" sSQL = "INSERT INTO StagesT ([Stage Name], [Stage ...
15
votes
4answers
70k views

MS Access call SQL Server stored procedure

I have an MS Access application that contains all tables linked to SQL Server, so in MS Access VBA code or query I work with those tables very simple, I access them via name, like [Customers]. Also I ...
15
votes
8answers
53k views

Is there any way to create multiple insert statements in a ms-access query?

I am using MS Access 2003. I want to run a lot of insert SQL statements in what is called 'Query' in MS Access. Is there any easy(or indeed any way) to do it?
15
votes
6answers
101k views

How to connect to a MS Access file (mdb) using C#?

I'm trying to connect to a mdb file and I understand that I would need Microsoft.OLEDB.JET.4.0 data provider. Unfortunately, I do not have it installed on the (University) machine. Since, they don't ...