Questions tagged [ms-access-2016]

Microsoft Access 2016 is a database management system and application development tool.

0
votes
0answers
11 views

Can I calculate the difference between two dates if there is matching data in another column, MTBF calculation

I am attempting to find the mean time between failure of serialized equipment. I am using Access 2013 for my database and have Access 2016 also. My problem is that I have multiple entries for the ...
0
votes
1answer
12 views

Drop down list with values from the same record

I'm setting the new database and can't figure out how to make a combo box with values from the same record. It's about the customers and orders. Customers might have up to 3 delivery addresses. So ...
0
votes
1answer
22 views

How to retrieve values from a query in VBA and assign them as variables in Access 2016

I'm trying to retrieve the values from an existing query and assign variable to it using VBA (Access 2016), to be able to use it in the further code. And I'm totally stuck in that step, a very ...
0
votes
1answer
27 views

Error 424 object required after NULL SQL query

I am running some EXCEL VBA code to update the contents of an ACCESS database table along the lines suggested here: IF @@Rowcount = 0 -- SQL Syntax Error in Access . When I execute the SELECT query, ...
0
votes
0answers
14 views

How to get combo box selection to fill related fields with data

I have a table [inventory] with inventory items, and a bunch of columns with different information for those. Mainly, "part#", "description", "price". I am trying to create both a purchase order form [...
0
votes
1answer
23 views

MS Access Basic Stock Take

Can anyone please point me in the right direction. I have created a Table with a primary key as auto number, barcode, and qty. Barcode field is set to no duplicates allowed. I have Created a form with ...
0
votes
1answer
26 views

How do I requery a combobox every time a new record is added or existing record is updated?

I'm trying to requery a combobox in a Form in Access so that it updates every time A) Any record is updated in the table B) A new record is created. I understand from this question that I need to use ...
0
votes
0answers
43 views

Can I create a form field in Access which selects from items in the same table?

I have a database for a list of items stored in our office. Some of the items are physically located inside a box, bag or another container, so to describe this situation I have one record for the "...
6
votes
3answers
172 views

Access with 1 MySQL Table asking for credentials

I have a access database using a local sql server backend for all tables except 1 web based MySQL table. The MySQL table has 50 rows or so, 3 fields, not big at all. I have a odbc connection setup ...
1
vote
1answer
44 views

Is there a more efficient way to store containers of objects in Access?

I'm trying to create a relational database in Access 2016 to keep an inventory of items stored in our office. Most of them are in boxes of some kind, so I've decided that each record should be a ...
1
vote
1answer
17 views

How to update the server name for all ODBC linked SQL Server tables using Access VBA

I need to be able to provide a method to update the server name in all ODBC linked table connections in an Access database. All tables have been migrated out of Access to a SQL Express instance. An ...
0
votes
1answer
15 views

#Error thrown from `Switch` when string parsing in Access

I'm trying to do SWITCH statement in Access to parse GPS latitudes and longitudes of multiple formats into Decimal Degrees format SELECT IIF(ISNull(a.Lat), NULL, Len(A.lat) - Len(Replace(A.lat," ", ...
1
vote
1answer
31 views

Query inside Access DB faster than external query with Excel (power query editor)?

I am supposed to optimize the performance of an old Access DB in my company. It contains several tables with about 20 columns and 50000 rows. The speed is very slow, because the people work with the ...
0
votes
1answer
17 views

Subform blocking Recordset.AddNew (Error 3027)

Having a subform displaying the same table used in recordset makes the table read only (error 3027). Getting rid of the subform fixes the problem. Similar setup works in my other form interface. I ...
0
votes
0answers
36 views

How to stop 'Enter Parameter Value' after I refresh/close my form in MS Access?

I'm setting up a new tooling managment database using the form in MS Access, there is one command key in my form (Asset List) to open another form (Asset Details) for viewing and editting data, ...
0
votes
0answers
23 views

How Would I Modify 'Purchase Orders' in Template 'Northwind' for Manufacturing?

I understand entirely that Northwind is a learning template, but it appears more feature-complete in the newer versions of Access and appeared to suit my businesses needs. I largely have the database ...
1
vote
1answer
44 views

PYODBC + PYINSTALLER: EXE listing different drivers as compiler (PyCharm), 32 bit Access and 64 bit Python

I have 32bit Access and 64bit Python (on x64 Windows 10). I successfully run the following code to obtain table (or a query) from my .accdb database and get the desired outcome in my Pycharm. import ...
0
votes
1answer
28 views

I keep getting error 3027, I can't update the database. How can I solve this error?

I want to update "DateEmailSent" field in another table but I keep getting the error 3027, it says the database or object is read only. It stops at rs.Edit. I tried rs.LockEdits = False, but it doesn'...
-1
votes
1answer
26 views

How to sort filtered ListBox

I have created search box for a ListBox in form. Search function works as intended, but I would like results to show in ascending order based on first column. I am having trouble understanding how to ...
1
vote
1answer
20 views

CommandBarControl executing .OnAction before click on button

The code in my question in inspired by the solution in the answer provided by this question: How to add a menu item to the default right click context menu I have a ListBox object on a form showing a ...
0
votes
0answers
12 views

Adding a new record in Access 2016 from custom form

I have a form in Access 2016 to capture some simple system information. I have a Systems table and a SystemTexts table with a one-to-many relationship (SystemTexts contains things like abbreviations, ...
0
votes
1answer
16 views

Importing queries from Access to PowerQuery

I am currently trying to import MSaccess 2016 queries into Excel 2016 powerquery, but am having issues with importing as I either get a blank screen or the MSAccess query does not show up at all on ...
1
vote
2answers
33 views

How can I input data for a many-to-many table in Access?

I'm sure that this is a basic question but I'm struggling to get to grips with Access. In my case I have two tables: Student and Subject, linked by a junction table, StudentSubject. Student and ...
0
votes
2answers
31 views

Invalid field definition error when trying to link two tables

I'm trying to link the "Subject" table to the "StudentSubject" table in the image below, but I get the error "Invalid field definition 'SubjectID' in definition of index or relationship." when I ...
0
votes
0answers
25 views

Access 2016 opened dynamically will not minimize Access programming window

When Access opens, and the Main Menu Pops up, I minimize the Access Window using Docmd.RunCommand accmdMinimize and it works great. Access Programming window minimizes to the systray. When the ...
0
votes
1answer
18 views

Like Nz not handling a null value

I have a query that I control with some filtering options using a form. One of those filters is a medical code search. Sometime this field has a value and sometimes it is null. I want to be able to ...
0
votes
1answer
26 views

Enabling/disabling input into certain record's field based on the value of another field, but at the same record

I work with Access 2016 and I'm trying to lock/unlock the fields (Epileptic_activity, Quantifiable_activity and Seizure_aspect) in each record, when "Selection"=No/Yes respectively (I have Yes/No in ...
-1
votes
2answers
43 views

How to convert a column from a table in a dataset to a string separated by commas in C#?

I am making an windows form application in c#, it has to be able to send an email to all the recipient ids that are in a table in an Access Database. I already understand how to send the mails and ...
-1
votes
0answers
51 views

Access 2016 - Cannot add/edit record in group_by query - Used DSum but SUPER Slow

I have 2 tables. Project Data and Site Data. One-to-Many. Dozens of sites per project. I have a continuous form which provides Project info and some fields that add the total cost for the sites per ...
0
votes
1answer
10 views

Adding a wildcard in Query where clause? (Access '16)

My Query pulls records based on a few different unbound fields in a search form. For the searchable fields, I use the following in the criteria second of each query field: Like Nz([...
0
votes
1answer
70 views

Why does Access demand a parameter for my query?

AgencyID produces an output, but not the output I need. I need to create the query without having to enter a parameter value. I've tried ()"" even put the Y separate from the 68 and even tried ...
0
votes
0answers
25 views

How to set conditional formatting for forms, reports, and datasheet using VBA

Well, this is the follow up on another thread. I have a Persontable with a several fields The table is presented to the user in 3 different ways: 1) as a datasheet 2) as a table 3) as a report ...
0
votes
1answer
15 views

How to populate an unbound text in report from table?

I'm sending a report to each customer a daily recap from the day. Instead of creating different reports for each customer, i'm using one report and changing the SQL Where statement of the query used ...
0
votes
1answer
16 views

How to change backcolor of a field of a continuous sub-form, if this field is null

I have a continuous sub-form with 2 fields "id_arriv" and "id_depart" in which only one of these is not null and the other one is null depending of the kind of move. I would like if the one of these ...
0
votes
0answers
23 views

update an Access table using an email?

I have several databases that all produce reports. I need to automate the sending of these reports to a frequently changing list of people. We have a distribution list that is constantly out of date. ...
0
votes
1answer
24 views

Trouble with an Access Query searching within a date range

I have a query that searches saved records and creates a report based on the record(s). Some of the fields are searchable either independently or in association with other parts of the saved record (e....
0
votes
0answers
21 views

Why Access 2016 database is not being imported in visual studio 2017

Is there ant way to use Access 2016 database instead 2003 I was trying to access MS Access 2016 in VS 2017 but it was giving unrecognized database format. I want to know why it's happening as they ...
0
votes
0answers
65 views

How to eval a string containing column names?

As I cannot attach a conditional formatting on a Table, I need an abstract function to chech if a set of records or all records have errors inside, and show these errors into forms and/or reports. ...
0
votes
1answer
31 views

Access 2016 form button to open report based on current record

I'm trying to create a button on a form that will open a report with just the current record. I've done the following: created a button created Event Procedure for On Click (it opens macro mode ...
1
vote
1answer
19 views

MS Access VBA Selenium .getText after Submitting Form / WebPage

Access 2016, just switched from I.E DOM to Selenium /Chrome : ) Need to get eBay listing ID Number after auto submitting Form/WebPage -this part works really sweet! Getting runtime 428 "Object doesn'...
0
votes
1answer
7 views

How to import data from external webpage connection in MS Access like excel has Data- WebPage

Like excel has Data=>From Web to import a table in webpage in excel. How can I achieve this in MS Access? I want to data in table in external web page into the MS Access Table. Just Like we can in ...
0
votes
1answer
57 views

ODBC connection failed error in Excel 64-bit

I have a linked table in ms-access which is linked to a sql server table, and when I am trying to fetch the data in excel via VBA from ms-access linked table the error message "ODBC connection failed" ...
0
votes
0answers
18 views

MS Access 2016 Query

Good Evening, I have an access database that tracks each employee assigned to a job each day. Each job can have up to 20 employees assigned to it each day. I need to list on a form each of the ...
0
votes
0answers
23 views

Database relationship: Shipping Address in Shipping Data

I'm building a database for management of my company. I send the relationships of my database: I would like to introduce a combo box in the "ShippingAddress" Field of the tbl "ShippingData" and ...
0
votes
1answer
40 views

1 MS Access Query to Multiple Excel Files Based on Field Value

I have MS Access query which I want to export to multiple excel files (.xlsx) based on a field value. In English, I have a query which contains all my customers but I want to create an excel file for ...
0
votes
1answer
24 views

is possible to pass variable in a query SQL statement?

I'm wanting to know if it's possible to pass a variable into an SQL statement for a query, rather than making 12 different queries which would also have me making 12 different forms (1 for each query)....
0
votes
2answers
61 views

SQL Code for Max and Min time based on condition ( IN / Out )

I have a table as below and I need to get another table query with expected query return date Username "Min(sign_time)based on IN" "Max(sign_time)based on out" original table Sign_Date ...
1
vote
1answer
95 views

C# DataSet Designer - AccesDB - Combine two rows into one

I need your help with an SQL query, that I am trying to build in C# Dataset Query Builder... SELECT HouseHold.HHID, Client.FIRST_NAME, Client.LAST_NAME FROM ((Client INNER JOIN HouseHold_Client ON ...
1
vote
1answer
23 views

How do I convert to relative paths for image files in access (for using database from a flash drive)?

I would like to move my database to a flash drive (a catalogue for a fossil collection). I want to send it to some colleagues who might use it on different computers. The associated images come to ...
0
votes
0answers
34 views

Web Browser Control in MS Access Form

I am working on an MS Access project where "Web browser" control is used to display a summary chart from the report server. The application has 4-5 tabs and the Web browser is used in the landing tab ...

http://mssss.yulina-kosm.ru