Newest 'ms-access' Questions - 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.

0
votes
0answers
27 views

mysql failed connecting to MS Access

I'm trying to transfer my database from Microsoft Access to MySQL (I'm using MySQL workbench). for that I need to connect MySQL to Access but I'm facing some problems. I'm following these guidelines: ...
0
votes
0answers
12 views

Microsoft Access Calendar Report

I have inherited a MS Access 2003 Database that used to have a working Calendar that then passed the value you picked from calendar to a report. I have managed to fix the missing calendar by ...
0
votes
1answer
16 views

How to set query criteria to select all when combobox is left empty

I have been trying to use combobox's value as a criteria for a selection query. I want it to select all options when combobox is left empty. I have tried to use isNull and isEmpty functions with IIF ...
0
votes
2answers
35 views

I have a syntax error with my update query

I am trying to update a column by summing up data from another column in another table but I don't understand why I keep getting syntax error. UPDATE [Reference No - Quotation] RQ INNER JOIN [...
0
votes
2answers
24 views

user-defined mixed listing query in sql

suppose that, I have a db which is included USR_NR field (integer type). and I know all datas in field. no any surprises nr. USR_NR : 1,3,4,7,9,12,44,13,78 I need to listed this field as mixed like ...
0
votes
1answer
38 views

Dynamic Union Query with Primary Key

I have a union query that is a dynamic reference to a group of tables covering varying types of items. I want to create a linked table (via query)that will have manual entry that will use the union ...
-3
votes
0answers
25 views

Converting a vbs script to vba for source control [on hold]

The aim: is be able to update the current Access DB while using it. So click a button on a form, select location of new database schema files and update the DB with those files. Current solution idea:...
0
votes
0answers
24 views

Need help populating text from a form containing a Start Date and End Date onto my calendar

I don't understand VBA much so I've got a lot of help from the web to construct a simple office calendar where the employees can fill out a time-off request form and submit it to the supervisor. The ...
0
votes
0answers
39 views

Access VBA: Shell command broken in one particular database

I have two Access databases that I'm opening on the same computer. In one, running this in the immediate window works as expected (opens Notepad): Shell "notepad.exe" In the other, I get this error ...
0
votes
0answers
14 views

Using a form ,enter a range of sequential numbers in a table not using auto number

I hope you folks can help with this: I have a table named: tbl_Boards In tbl_Boards is the primary Field named: iBoard_Serial_Number. The serial numbers field contains unique series of numbers that ...
1
vote
2answers
41 views

VBA drops the decimal point when multiplying decimal with whole number

I have a userform that retrieves price amount from an Access table. Prices can be decimals. To compute the total prices of a line, I have to multiply it by the quantity. A typical example is: ...
0
votes
0answers
20 views

Calculate date using future date minus number days excluding weekends and holidays [duplicate]

I am trying to write a formula that calculates a date using a future date (effective date) minus the number of days prior to the effective date that a task needs to be completed and exclude holidays ...
0
votes
1answer
11 views

Unable to edit record after immediately updating the same record

I have a form that is used to update project status. The main form is used to filter by name/type/status, I have no issues with that and don't believe it impacts the issue on the subform. My subform ...
0
votes
0answers
17 views

Change Data Type of a Column before Import

I have a form to import an Excel File into an Access Table, but there is a column in this Excel Sheet that contain Numbers and Words and when importing this file using VBA, it assigns a Number data ...
0
votes
1answer
30 views

Display Button on Form (Continuous) Depending on record

I have a list of Records that I am Displaying in a continuous form. I am also putting buttons in this form. IE I have a list of "exams" on the list I have buttons for each exam such as a DELETE ...
2
votes
1answer
19 views

How to “count” two different criteria from the same column in a table?

I'm trying to write a simple query that groups by day, populates one column with the count of "valid" AND "running" points in that day, and another column with the count of all "valid" points. So the ...
1
vote
1answer
20 views

Join Field to Range of Values

I am trying to extract data from a table that references transactions from another table. I cannot figure out how to obtain the desired output. Table1: +--------+-------------+---------+ | Widget | ...
2
votes
1answer
34 views

Run-time 52 Bad file name or number error on one network system

I am receiving the Run-time error '52' bad file name or number error, however all of the questions which cover this on stackoverflow that I can see have answers which involve changing the code. The ...
-3
votes
0answers
38 views

Is there a relational DB that can allow users to edit table content using a spreadsheet style inferface? [on hold]

I've been using MS Access as a DB which allows users to edit the contents of a relatively small table (< 50K recs) using a spreadsheet-like interface. They just open the table and edit "cells". It ...
0
votes
1answer
18 views

Parameter in the Like clause of the criteria in MS Access

I am looking to create a query in MS Access that searches by a name provided by the user. However, I would like to let the user enter only the beginning of the name. So, I would imagine a search ...
0
votes
2answers
38 views

SQL Subquery in VB.Net with Access Database

I have developed an SQL query that uses sub-query based on a result set (i.e. a query queries the results of a sub-query). The query executes as expected in MS Access but will not execute in vb.net (...
0
votes
3answers
41 views

Update MS Access table empty fields based on same table

In MS Access database, I'm working with a table that has rows. In some cases not all columns of the rows are filled. I want to create an update query to update the values of the empty fields with data ...
2
votes
2answers
31 views

Access - Update local table with linked table (but without primary key)

I've got a little ACCESS tool where I want to read a linked table and update the local one. Import new entries works like a charm but when I try to update an existing one it always throws an exception ...
0
votes
1answer
24 views

Subform doesn't requery

I have a acces Form in which you can select a User with a dropdown Then i have a subform with all the licenses of that user. The licenses can be removed from that user with a button. After a license ...
1
vote
2answers
17 views

How to populate a ComboBox with query results

I had a problem populating a ComboBox from query results in access vba. My goal was to query for one column of a table and use every record from the result as an option for the combobox. There are ...
2
votes
0answers
33 views

“Data Source Cannot be Shared” following upgrade to O365

I recently updated to Office 365 and with it a few of my vba tools fell over, but the majority have been easily fixable. This one is confusing me: My code uses query tables to get some data from an ...
1
vote
1answer
39 views

Making pivots in xlsx files in Access VBA

There are some xlsx files in "c:", exported from Microsoft Access table. There are about 4 files with equal number and names of columns but different data. When the code starts running, it makes the ...
0
votes
0answers
15 views

How to use Dlookup for 1 field in Tab Control of Access Form

Still working with Access 365, I have 4 Tables and 1 form Table Plant {PID(key), Name} Table Provider {VID(key), Company} Table Contractor {CID(key), Plant, Provider} Table KPI {KID(key), ...
0
votes
1answer
26 views

Using VBA OR PowerShell to export all MS Access SQL queries to text files

Wishing to export the underlying sql of ~200 queries from access 2013 to separate txt/*.sql files - not the data that the queries collect. This q/a provided a suitable answer: Using VBA to export all ...
0
votes
2answers
37 views

Any way to create and insert data via query?

I want to create a table and insert data into it using a single query in MS Access. student_id | roll_no | name ------------------------------- 1 | 1 | Ankit 2 | 2 | ...
0
votes
0answers
30 views

Import txt file into MS Access with query

I need to import file txt into Access db with a query (c# in asp.net). But the format of a txt can be change and use , ; for the delimiter. I have different file.txt with different delimiter and for ...
0
votes
1answer
23 views

Query columns based on values of table

I'm new to DB and SQL so I don't know if there is anything new I need to try for this. I want to solve this table my senior has given to me: Passbook(Table Name) Date | Amount | Type ----------...
0
votes
2answers
19 views

Using Dlookup in the Default Value field of a form control

I am trying to populate a form controls default value based on the value of a combobox on that form. The combobox is called Title, and I want the control HIPAA to populate based on the value of HIPAA ...
-2
votes
0answers
22 views

How do I set certain criterias for 2 different textboxes in the same page? [on hold]

I have 2 textboxes. I want to require textbox1 to verify and accept what's typed inside it after I press the button IF it has exactly 12 numbers only (no characters). textbox2 is a textbox of the ...
0
votes
1answer
21 views

Combo Box Query to show all records

I have multiple combo-boxes with a query that filters one after the other (drill-down) and the last combo-box selection shows the records via subform-query. My concern is if I leave any combo-box ...
0
votes
3answers
50 views

Access SQL (or VBA code) to list all tables with at least one attachment field

I have an Access database with ~150 tables and I need to find a way to list all tables with at least one attachment field. Going and checking by hand would probably be a nightmare :/ Did anyone use / ...
0
votes
0answers
15 views

Combining several crosstab-queries with simple queries

Several simple queries and crosstab queries are sharing the same data (row heading in cross-tabs, key in underlying tables for simple queries). For reporting needs, I need to present a merged version. ...
0
votes
0answers
28 views

Tracking changes made to tables by another source

I have a program that centralizes a large number of work orders from multiple different sources. Each user that uses this program can track specific work orders and see their status. These work orders ...
0
votes
1answer
28 views

Delete a row but checking two columns that are PK

Hello guys I am coding on VB.net. My problem is that I am deleting two rows which I do not want. I know already why is causing that. Is because in this table I have the columns called "Group", "...
3
votes
2answers
90 views

SQL 'CREATE TABLE' Syntax issue

I'm having difficulties identifying the syntax issue in the first CREATE TABLE statement, and sadly I'm unable to identify the issue. I'm receiving the following VBA error: Run-time error '3290' ...
-1
votes
1answer
41 views

Access error 2683 - There is no object in this control

I got this code from a friend and I actually never programmed Access apps. Well, every time I click a button, I get an error like this: Runtime error 2683 - There is no object in this control ...
-1
votes
1answer
46 views

Solving syntax error, missing operator when transferring XML contents to access table

Hey I'm transferring the contents of an XML file to access. Now everything works but when I try transferring the data from the "desc" section of each node to the "desc" column in the access table I ...
0
votes
2answers
53 views

How to search within 5 words of a keyword

I want to search multiple variations of the same keyword in a title, without having to list every variation. For example, we are searching "access to care" "access to healthcare" "healthcare access" ...
0
votes
2answers
48 views

Looping Code is not moving through the form

I have a form in my database that pulls data from a query to calculate the subassembly parts needed on a weekly basis and with the click of the "complete" button the required components should be ...
0
votes
0answers
26 views

SQL Server Multi User Windows Authentication Through MS Access

We have a built-in-house Customer Relationship Management(CRM) program that we are transitioning to a SQL Server back-end. We use Windows Authentication to authenticate users in SQL Server for the ...
0
votes
2answers
40 views

Downloading Data from Access using a Month-End Date and a Function

I'm new to VBA and am writing a macro that downloads data from Access based on a month-end date entered by the user. Currently, I am having issues getting information to download from Access. To be ...
1
vote
1answer
25 views

MS-Access in Sharepoint - what data available?

For better or worse we are launching an Access db from Sharepoint. Note that this db is not PUBLISHED to SP, people just double-click the link and open the db on their desktops. So now we need to ...
0
votes
1answer
26 views

How to get the Control with the focus in a subform?

Ms-access VBA raises an error when when me.myControl has the focus and I am trying to set me.myControl.visible=false So I use Screen.ActiveControl to figure out if myControl has the focus: if me....
0
votes
3answers
41 views

Split STRING into OR in Access SQL Query

I'll start by saying I understand very little of SQL which is why I haven't tried doing this myself. What I'm looking to achieve is as follows. I have a string with several unique IDs and I'm trying ...
-1
votes
0answers
17 views

How to display table reading from ms access in R shiny [on hold]

I have a database in ms access, I want to read that database and display a table in r shiny. I am able to read the content of the database in R studio by using following code: library(RODBC) db<-"...