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.

0
votes
2answers
16 views

MS Access, getting total values from two tables

I am trying to get the total values from tables "sales" and "payment" where the customer_id in both tables match the customer selected from a combo box in a form. Table 1: Sales customer_id item ...
0
votes
0answers
24 views

Debugging Excel macro called from Access macro

I use Access to make Excel reports by automating Excel, using a macro enabeled template Excel file (xltm). After having put data into Excel cells, I start an Excel macro from Access VBA code: ...
0
votes
0answers
25 views

Passing Visual Basic variable into SQL query in Visual Studio 2017

I have created a simple database in Microsoft Access 2016 to store job information, and wanted to make an interface in visual basic. I have figured out how to display the database data using the data ...
0
votes
0answers
17 views

How can i save sql query as result in vba access? [duplicate]

Hey i want to save the result of a query as a string in vba But my following Code saves the SQL Statement and not the result: Dim strModel As String Dim strSQL As String Dim rst As DAO.Recordset ...
0
votes
1answer
14 views

[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause because of Offset and Limit

I am using php moreover, codeigniter to access an mdb file. I connect and query the db when using the following: $this->mov->query("Select * from Logger")->result_array(); So no issues ...
-1
votes
0answers
15 views

Need encryption ideas for Log in and sign up form data on ms access [on hold]

I have created a simple log in and sign up form on ms access. I plan to store the data received from Sign Up into a table called Admin. Then to sign in, I will make validation by searching and compare ...
0
votes
0answers
11 views

Table in Excel, based on Access database - update with new columns/variables

I have an excel file, which is built around a sheet with a table, fetching data from Access. the table also has numerous columns added, with calculations based on the raw data columns. This table is ...
2
votes
0answers
37 views

MS Access with SQL Server back-end update fails without error

This simple VBA statement does not work as expected: strSQl ="UPDATE Inventory SET NumberOfBlocks = BlocksReserved, LastUser ='Me' WHERE InventoryID = 1234;" CurrentDb.Execute strSQl, dbFailOnError ...
1
vote
0answers
16 views

How Do I Connect an MVC Razor Pages Project to an MS Access Database

I created a Razor Pages Project in Visual Studio 2017. I have an existing MS Access database with several tables. (Courses and Sponsors). I want to use Entity Framework to have Scaffolding create the ...
1
vote
2answers
19 views

How do I get my Access form to re-open to the last unbound text box entries?

I have created a form to update criteria in various queries in my database. I have 4 unbound text boxes. The user enters the new dates into the text boxes and I've added a button to run the queries. ...
0
votes
1answer
33 views

MSAccess VBA Shell: UNZIP

I am using a simple ZIP/UNZIP utility (http://infozip.sourceforge.net/) called from a WScript.Shell. strPath = CurrentProject.Path & "\Backend_Databases\" strPathUtil = CurrentProject.Path & "...
1
vote
1answer
20 views

Access IIF statement to list results

In Access 2010 I'm trying to list the results from my IIF statement but for some reason is not working. DogTrainingStatus: IIf(([TrainingSuccess]>"*Pass*") And ([TrainingSuccess]>"*Failed*"),"...
2
votes
2answers
35 views

SELECT TOP x in MS Access query based on form field?

I have an Access report whose Record Source references a couple of fields on a form. It works fine. This is it, minus a bunch fields in the SELECT clause for simplicity: SELECT pt.PA, pt....
-4
votes
2answers
71 views

There is a syntax error in the following SQL code. Why?

"SELECT tblStudent.StudentName, tblStudent.Username FROM tblStudent " & _ "INNER JOIN tblClasses/Students ON tblStudent.StudentID = tblClasses/Students.StudentID " & _ "INNER JOIN tblClasses ...
1
vote
1answer
15 views

Combo Box Dropdown List from Table

First time creating forms to insert into a database. I'm trying to create a drop down combo box that lists the entries in the second column... This is in a seperate table. The issue I'm running ...
0
votes
1answer
23 views

MSAccess: Run Stored Proc Asynchronously w/Return - Syntax?

I have had good success in past running single threaded SPs, waiting for a "0" or "-1" reply to indicate success, using: Set cnn = New ADODB.Connection cnn.CursorLocation = adUseClient cnn....
2
votes
0answers
37 views

How to get the precision and scale of a numeric field from table structures in an MS Access database?

I used the solution of How to query table structures from an access database? to read the structure of all the tables and odbc-Datasources in an Access database with C#. But now there is a column ...
1
vote
2answers
34 views

How do I automate this date code,s o that I don't have to change it every year. I need all dates greater than or equal to Dec of last year

How do I automate this date code,s o that I don't have to change it every year. I need all dates greater than or equal to Dec of last year. For example in 2019 i need dates of dec 2018 +. In 2020 I ...
0
votes
0answers
27 views

Method 'LoadFromText' of Object 'Application' Failed

So I've been at days now trying to solve this bug. After having all functions for Access objects exported, removing binary data from specified fields, and importing Access objects to fresh database, ...
0
votes
1answer
15 views

Join tables based on matching criteria and Subtract the sum of Table2.Quantity from sum of Table1.Quantity for matching rows

I am using the code below: table1-add, table2-remove SELECT add.description, add.size, (sum(add.qty) - sum(remove.qty)) AS OnHand `FROM add LEFT JOIN remove ON (add.description = remove.description) ...
0
votes
0answers
17 views

Add Unrelated Parameter to Query or Form

I have a form based on a query. In the query, for the first field (species), I add this to the criteria: [what species?] This way, people can search by the species they want. No worries. The query ...
0
votes
1answer
40 views

How to convert MS Access query objects to SQLite views? [on hold]

We have Microsoft Access databases containing (1) dozens of tables and (2) dozens of select queries. These select queries are stored as objects in the Access database. Our purpose is to explore ...
0
votes
0answers
50 views

How to close forms from within a form event [on hold]

I have some values stored in variables which can be updated during processing and when I detect that specific values are stored there, I need to have the user enter new values to continue processing. ...
-1
votes
1answer
18 views

Referencing Just Added Record When Using Call to VBA in AfterInsert DataMaco

Access 2016, table with a AfterInsert datamacro. In a comment to a previous question that I can no longer find, Albert D. Kallal (user:10527) noted that if one uses the Set LocalVar approach to call ...
0
votes
0answers
25 views

DSum query slow when it is a Make Table query

I am trying to capture which products account for 80% of sales and therefore need a way of having a running sum as well as a total sum for my data. The query runs relatively quick if it is just a ...
0
votes
1answer
34 views

MS Access Retrieve Values from ListBox

UPDATE: 3/20/2019 After subthread conversation (below), I renamed the ListBox. ItemsSelected property WORKS. Value still returning NULL int he code This is my first time dealing with multi-select ...
1
vote
2answers
29 views

SQL Self Join table - All records from 1 table, 1 record from the other

I have a table that looks like this (in MS Access) rDate | rTime | Horse | Pos | Odds ------------------------------------------ 01/03/2019 | 13:00 | HorseA | 3 | 13.2 01/03/2019 |...
0
votes
1answer
32 views

One function for every Combobox in MS Access [duplicate]

I have multiple sources for one information, so I thought it would be the best to add an ComboBox next to it. With it the user shall choose the source for the information. Im using MS Access with VBA. ...
0
votes
2answers
44 views

“Syntax error in field definition.” when trying to create a computed column

I am trying to create a computed column in my Access Database using C#. When running the following code I get the error Syntax error in field definition. on line 4. OleDbConnection conn = new ...
-1
votes
2answers
50 views

Entity or relationship

I am drawing an ER diagram. Movies (title, year, and rating) are shown in theaters (name and city). A movie can be shown in many theaters and a theater can show many movies. "Show" should hold ...
0
votes
1answer
46 views

Take too long time to write in to Access Data Base using C# WPF application, Visual Studio,

I have a WPF application using C# and VS. And I am using an Access database. I have a loop that has to run in a maximum time of 500MS, But its take 570+- In my program, I have a wait time of ~340MS ...
0
votes
1answer
17 views

Error when runing query from form between two date from a form

I have a form called FirstInLastOut which looks as the image below. Based on Name or badge number I want to search between two dates. I am using the following criteria on the query: >=[Forms]![...
-1
votes
3answers
38 views

How to join two different table using UNION in ms access

I have the below query Select sum (ABC) as ecr from table1 Where a<>'y' or b is null and c<>'g' Union all Select sum(bcd) as ech from table2 Note: I am getting results under one ...
0
votes
1answer
28 views

PYODBC Insert Statement in MS Access DB Extremely slow

I am looking to speed up my insert statement into Access Db. the data is only 86500 records and is takikng maorew than 24 hours to process. The part of the code i am looking to speed up is comparing ...
1
vote
1answer
24 views

MS Access 2016: CTRL+A saves the form?

I have a strange problem that I don't know how to track down. I have a form that closes itself using an _AfterUpdate event. I found, by accident, that when I am inside a TextBox control and I attempt ...
2
votes
2answers
22 views

How to sum entries of different rows in MS Access?

I have a table of orders in MS Access, the leftmost column representing the order ID. But some orders have more than one type of product, I need to compute the total cost of the order. I know how to ...
0
votes
0answers
30 views

Error 3022 - Access not allow the Edit function

The code below should edit the data on my Access when it has the same identifier which is my primary key but it seems that it cannot find it same. I am sure that I have the same value of Primekey ...
0
votes
1answer
25 views

Multi-Field Search Button (Query) Showing Records With or Without Missing Fields

I have a database with only 1 table, this table has 27+ fields and not all of them will contain a value (some will be empty). I have a button ("search alarm") on a navigation form that performs a ...
1
vote
1answer
26 views

Searching function for textbox and letting my function still run when there are none entries in for the textbox and listbox

All I really need to know is how to make it where I can make selections in multiple multi-select listboxes, but leave any number of them blank and still have the macro/query work without having to put ...
-1
votes
0answers
26 views

Pass Value from MS Access to Adobe Acrobat Reader DC

I am creating a database application that will allow users to select a road number from a form in Microsoft Access and open a map to display the road on that form. So far, I have a form that has a ...
-1
votes
2answers
35 views

How to save SQL query result record as integer in VBA

I have a query in Access 2016 and I want to save the record number as integer in VBA module. As example, Query1 has 10 records should be saved as: int query1 = 10 How can I?
0
votes
0answers
33 views

Access to the remote server is denied because no login-mapping exists. (Microsoft SQL Server, Error: 7416)

I'm trying to setup linked server on Access database (.mdb - without username and pass). Everything works fine for Admin account, however for anyone else it reports message: "Access to the remote ...
-3
votes
0answers
16 views

Microsoft Access access error while searching records [on hold]

Hello i am getting some error in MS access database i cant post error code here Code URL See on [pastbin][1]
0
votes
0answers
15 views

read mdb file with PDO in Debian returns “segmentation fault” error

I am trying to read an mdb file with PDO but I get "segmentation fault" error. So far now what I did: - installed php-odbc driver - set correctly "/etc/odbcinst.ini" file - connected to mdb file with ...
0
votes
1answer
21 views

MS Access vba query with Format date

I try to create a query to Count items and having three WHERE conditions but there is no result when I run the code, not even an error one. What am I doing wrong? Private Sub Command5_Click() Dim db ...
1
vote
0answers
41 views

MS Access - Criteria being added to a Query after the Query has run

I'm new to Microsoft Access, I have created a Database to store data in relation to workers and their expertise in specific tasks, the industries they cover and the Geographic area they work in. I'm ...
0
votes
1answer
30 views

Question on Microsoft Access - Cannot link primary and foreign key

I have come across a question concerning Primary keys & Foreign keys in MS Access. I do have two tables, Customer and Sales. Customer has three attributes: CustomerID (short text which is my ...
-2
votes
2answers
37 views

How to write query to find unique records and count of that records in Access query design [on hold]

I have the following table in which each Employee works on multiple Products. The output I want is employee name, diff products they worked on and count of that each product. Ex., Employee ...
4
votes
1answer
61 views

How do I display a messagebox with unicode characters in VBA?

I have a string containing unicode characters in VBA. I want to display that string in a message box containing it. However, instead of the string, the message box only contains a questionmark. ...
1
vote
1answer
46 views

Save DAO QueryDef to Temporary Query and Output Results to Excel

So I have this Access project where at first I created a TempQuery and used that query to output the results to an Excel file which works great. Here is the code for that: Dim qdf As QueryDef ...

http://mssss.yulina-kosm.ru