2020欧洲杯手机版注册

A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

Questions tagged [ms-access]

2020欧洲杯手机版注册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
0
votes
0answers
8 views

How to Embedd a Select in a Where in SQL Access

I'm attempting to plug in the result of a SELECT statement into an IIF in order to change the value of another column, and having some difficulty.In pseudocode what i'm trying to do:FROM employees ...
0
votes
0answers
11 views

How to Add Data From MS Access 2016 Query to SQL Server Table

Is it possible to transfer Data directly using a query from an Access table to an SQL table ?I have in mind something like that:INSERT INTO tableTSQLSELECT * FROM tableAccess2016WHERE condition;
0
votes
2answers
33 views

How can I join three tables in MS Access SQL?

I have a simple table model with 3 tables but I am not able to join them in the way I need it.Table: TOPICID TITLE1 Talk12 Talk23 Talk34 Talk4Table: SPEAKERID NAME20 Speaker20...
0
votes
0answers
39 views

Replace Subquery in SQL Statement

I'm having a SQL Query named "Test" like this:SELECT INPUT_BASIC_ELEMENT_DATA.FROM_NODE_NAME AS SupportFunction,[OP].sumax_Fx, [OP].sumax_Fy, [OP].sumax_Fz, ....[OP] is a query that I ...
0
votes
0answers
24 views

convert mdb to accdb into excel vba

In my project, I'm updating access database table datas with excel vba. I used to use .mdb file. To do this I wrote this codesDim db As DAO.DatabaseDim rs As DAO.RecordsetSet db = OpenDatabase("\\...
-6
votes
2answers
44 views

Query for students passed or not passed in specific Subjects [closed]

I have a Table with Column Headings:ID Student_Name Roll_Number Subject1MarksObtained Subject1TotalMarks Subject2MarksObtained Subject2TotalMarks Subject3MarksObtained Subject3TotalMarks ...
0
votes
0answers
14 views

Could not save as .ACCDE file (Could not use <file>; file already in use)

I'm trying to save ACCDB file as ACCDE but I got "Could not use [file path]; file already in use" error no matter how many times i tried.. i got 2 tables, 1 forms and 3 reports. Using Microsoft Office ...
0
votes
0answers
10 views

MS Access adp program not displaying data

I am supporting an application that was working fine on Windows 7 and we migrated to Windows 10 and now the program runs with no error messages but the data from the main screen does not show any data....
-1
votes
0answers
16 views

How can I add data from a Access Table to another Access Table in the last row using VBA? [closed]

can anyone help me? How can I add data from a Access Table to another Access Table in the last row using VBA?The Insert Into option in VBA is different?
0
votes
1answer
19 views

Error reading data from MS Access database using RODBC package

I've got hundreds of individual MS Access files that contain data on individual locations, each with an identical table structure. Rather than creating one database with all these files, they were all ...
0
votes
1answer
25 views

Use of WHERE with IIF, or is HAVING Preferred?

I have a WHERE statement that produces values in a field depending on two conditions. I then want to modify another column depending on what is returned from the new column.In Code - the below ...
0
votes
1answer
31 views

Adding the word 'and' to a list in a message box

I need help getting started on the code for adding the word 'and' to a message box after the user has selected items from a list box to make the message box grammatically correct. Possibly removing ...
-2
votes
0answers
18 views

selecting data from access database using a primary key vb.net [closed]

I want to select an specific data from my access database using a primary key, then pass it to reportviewer with a button, but I don't know how to implement it
0
votes
0answers
40 views

Run Excel Macro from Access VBA [duplicate]

I am trying to run a VBA module from Excel in Access. I am posting my core code below with some comments to step through it. Basically I want to:Create an Excel Object in Access Open the workbook ...
0
votes
3answers
34 views

For Table A, Return All Values in Column X in Table B

I have two tables, one is a table of employee names, 176 records. The other is a table (with duplicates) of employee names (same format) and their locations (7943 rows).From this answer i deduced i ...

15 30 50 per page