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.

-2
votes
0answers
14 views

BUG Report ACCESS 365/CTR

Incompatible Settings Bug! There appears to be a new bug in ACCESS 365 / Click to Run. It DOES NOT EXHIBIT on Access 2010. Issue: Combo Boxes (drop-downs) fail to Auto-Complete List Items when user ...
0
votes
1answer
29 views

How to write SQL statement to flatten multiple records down to a single record?

I have a table with multiple grouped by fields as shown in first table. I'm struggling to even start the query statement to how to make it look like the second table. Your help is greatly ...
0
votes
1answer
33 views

What does the # mean in this statement? [duplicate]

Converting Access DB Application to PHP/MySQL and am having trouble with some of the syntax. Can't figure out what the # is in this statement. I've looked through all the documentation on Access I ...
-4
votes
1answer
28 views

I want to populate data from a table then save it in another one with additional fields [on hold]

I'm working with a project that manages my Documentation with University. In a sub-campus, i require a software to manages transcripts and degree forms to be setup. In this regard i made a solution ...
0
votes
1answer
12 views

Using text boxes as a criteria for list boxes in Access 2016

I have a form that has 3 list boxes that I am trying to query based off the range given from 2 entry/text boxes. I'm not sure how to get the script to look at the text boxes. Me.lstDailytop....
0
votes
1answer
24 views

How to update BegAtt & EndAtt values by MDB query?

I want to update the BegAtt & EndAtt values based on the Control Start, Control Stop, Application, and Record Type fields in MDB by query. Below is the record set of my MDB database where I want ...
0
votes
0answers
31 views

SQL Aggregate (concat) text based on another text field value

I am looking for a sql statement that aggregates (concatenates) a text value based on another text value. I’m working in ms access. Here is an example of the table source. ChangeNumber Approver ...
0
votes
1answer
75 views

Why am I getting an Error with TADOQuery select statement?

Every time that I try to set the caption of this variable, it gives me "unspecified error" and I have concluded... I've tried to set the caption straight from the TADOQuery and by assigning the value ...
0
votes
0answers
28 views

How can I exclude holidays from working days calculation in a request (SQL) [duplicate]

First of all I would like to precise that i'm a beginner/self learner and tried many codes before posting this, thank you for your consideration. I have a request in my MS Access that calculate ...
-1
votes
1answer
20 views

I am unable to create a logic

Display the detail of the customer who have contributed the maximum amount of charges to through all of their parcel delivery orders I have one customer table: Customer CustomerId CustomerName ...
0
votes
0answers
15 views

Need assistance with database importing from differently laid out excel files to access

So I'm trying to easily find a way to import data from one file which, strangely enough, is formatted a different way from all other rate data files I have to work with and I'm having trouble getting ...
0
votes
1answer
14 views

Trying to populate a textbox with the result from sql/vba and getting #Name error

I am trying to populate a textbox on an Access form with a value from a query where the selection criteria is another variable. The code is generating the sql, which I then put into the rowsource of ...
0
votes
0answers
17 views

Modifying records in groupby query

I am creating application for ToDo list and I have there three tables. Table with ToDos ("tblToDo"), table with Labels ("tblLabels") and mapping table where each ToDo can have one or more label ("...
0
votes
0answers
18 views

MDB ExecuteNonQuery throwing Exception but data is changed

When I'm trying to do ExecuteNonQuery on an MDB, surrounded with a try catch, the ExecuteNonQuery always throws an exception but the data does get changed. The exception I'm receiving is "Has been ...
0
votes
0answers
19 views

MS Access DB Data Load via ODBC Fails in Azure Data Factory after the first successful load

I try to fetch data from a MS Access DB (.accdb) in Azure Data Factory via an ODBC connection while using the on-premise integration runtime. The first time that the data copy pipeline is running, it ...
3
votes
2answers
38 views

How can I find duplicate records \ values after left join?

I have: TABLE1 with ID, and Name. TABLE2 with ID, and Address. I want to get ALL TABLE1 records and add a STATUS column: If this record exists in TABLE2 - 'OK'. If this record is not exist in ...
0
votes
2answers
25 views

How to SELECT all records where the event date is weekend and export to another table

I am new to MS Access VBA.. I have imported the log file to the table and would like to extract to another table. 1) all logs/records where DATE_Field = Weekend. 2) all logs/records where DATE_Field ...
0
votes
0answers
17 views

Microsoft Access Automate Export Query with Parameters

I have a Microsoft Access query that when exporting to excel will prompt the user to enter 4 digit parameter then export the results with those 4 digits in the .xlsx file name. I have a list of about ...
-1
votes
1answer
29 views

Transferring XML data to access table

Hey I previously asked this question a few weeks ago and the feedback did help but I'm still struggling to transfer the contents of my XML file to an access table. The error with this code is: "input ...
0
votes
0answers
25 views

How can I pass parameters/filters into my DoCmd.OutputTo Method?

I'm having a very hard time trying to add a parameter into my DoCmd.OutputTo Method. I can export my report successfully, but when I add a parameter or filter, either it gives me an error, or the ...
0
votes
1answer
11 views

Removing Combo Box value without having to lose focus

I have a combo box with a list of customers which I am filtering as the user types. When the form loads there is a preset value in the combo box, however when I backspace the combo box doesn't update ...
0
votes
2answers
13 views

MS Access syntax error in insert to statement

I'm working on a program in MS Access, and I'm just trying to enter some data into a test table to see how it works. I can't for the life of me see what is wrong with the syntax. I'm getting a 3134 ...
0
votes
2answers
19 views

Can I change the column showing in the same report through a button?

I have a report that opens from like 7 different forms, and I wanted it to show a bit different from each one (not by much, just 1 column). Is there a way that the report can show different columns ...
0
votes
2answers
32 views

How to order a recordest returned from a query by a field created within that same query (MS ACCESS)

The Query (For this question I do not think that you need to see schema): SELECT Agencies.AgencyName, (SELECT DISTINCT MAX(Invoices.CostsTotal) FROM Invoices WHERE Contracts.ContractID = Invoices....
0
votes
1answer
15 views

Collapsing database fields to rows using field names as values

So microsoft access sql is a bit limited but I am curious if its possible to use some field names to generate values for rows. It is a bit hard to explain but here is an example: IDNum 010101 ...
-6
votes
1answer
21 views

how to calculate median in Access query using function in VBa

I'm using ms Access query to calculate the MEdian AGe of Patients grouped by Clinic name using Query. since Access doesn't have build-in Median function. I have to create it using VBA, I tried many ...
0
votes
0answers
23 views

MS Access macro won't output a column in its query to the output text file

In our home-grown MS Access app (Office 365 ProPlus), I added a column to the query which powers our “Export Fixed-Width” macro. The new column is not getting output to the text file. It was easy to ...
-2
votes
0answers
10 views

Variance between years and months in MS access

I have access files 1. Customer 2. Year 3. Period 4.Sales value 5.Revenue Please guide me how to get a calculated value by customer and variance between Year & period
3
votes
2answers
55 views

How to create a function in VBA to return column names matching a certain criteria for each record in a recordset?

I have a table that contains a response to a survey. e.g., TableA: CompanyID Q1 Q2 Q3 Q4 Q5 CompanyA I I N N I CompanyB I I I I I CompanyC I I N N N I am using ...
-2
votes
0answers
18 views

Error 3141 Reserved word or mispelling in procedure

Error 3141 - Reserved word or mispelling when trying to code VBA in access, Please help Private Sub textLotSequence2_LostFocus() ' If textLotSequence1 contains 4 valid (non "~") characters then ...
0
votes
1answer
21 views

During bulk insert date is detected as null

In one of my applications I am importing csv data into mt Access db using the following bulk insert query. INSERT INTO Log_134_temp ([DATE],[TIME],CH0,CH1,CH2,CH3) SELECT [DATE],[TIME],CH0,CH1,CH2,...
0
votes
1answer
15 views

Run time error '3075' - Syntax error (missing operator) in query expression

I am creating a new database that will store test requests that people input through a request form. On my data input form, I have a "field name" section where the requestor will input the name of the ...
0
votes
1answer
12 views

Can a report have multiple record source?

I have different queries and I want to include certain columns from each query in my report. I seem to be able to only choose one query for the record source. I want to be able to sum the columns that ...
0
votes
1answer
22 views

MS 365 Access Form Dlookup #Name?

Working with MS Access for the first time and coming across a few problems if someone could please help me I have 3 tables and 1 form: Table Plant {PID(key), Name}; Table Contractor {CID(key), ...
-1
votes
0answers
41 views

When pressing button to run procedure 7_Click(), the program works for 5 hours to open file .csv How does i increase speed

When pressing button to run procedure Кнопка7_Click(), the program works for 5 hours to open file .csv How does I increase speed for opening file .csv? example of .csv file MKMASTER,MKMASTER,...
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 [...
1
vote
1answer
45 views

How how use IF condition for comparing date with SQL

I have a MS ACCESS table from an attendance machine, which consists of USERID, CHECKTIME column. With below SQL Query in MS Access, I manage to sort and find the MIN (date and time) as starting/...
1
vote
1answer
39 views

VBA if statement before executing SQL?

How can I correctly write an if statement in MS Access VBA that checks if the value in a textbox located on a form is equal to a record in a table column? The form is called FormExample has a textbox ...
0
votes
2answers
33 views

How can I save a GUID correctly as a string?

I have GUIDs saved in a SQL server table which is linked to a MS-Access database (Data Type in Access: "Replication ID"). In the forms I see the GUID like this: {CFFACB63-5EB1-43B2-BCCB-ACF6B226B4F4} ...
0
votes
1answer
14 views

How to convert short text to datetime in access 2007

I have a table whose column is of type short text that has data like the following example: 01/04/2014 10:45:47 p.m. How can I convert to date/time? Thanks in advance
0
votes
1answer
41 views

Add 7 days to values in Access date column

I have a date of journey column in Access with DateTime data type. I want to update it to [date of journey] + 7 using VB.Net, but it shows the error: Data type criteria mismatch What should i do?...
0
votes
0answers
44 views

Updating database at runtime

I can't update even if my code is correct. I tried to change the data type from String to Integer but still nothing happens. Private Sub UpdateQuanLoop() For x As Integer = 0 To ...
0
votes
1answer
26 views

Can't use ADODB.Connect for delete queries in SQLite Database

I need to delete a row in my SQLite database but ADODB Connections 'Execute' doesn't seem to work. I think that maybe it's because of my query or is my syntax just wrong Dim cn As Object Set cn = ...
-1
votes
2answers
18 views

Trouble with checkbox filtering

I'm having problems with filtering a field that comes from an sql database. I have managed to make a textbox filter, but I'm having trouble making a checkbox one. Here is the code I have right now ...
0
votes
1answer
35 views

What is the optimal way to show custom data from MSAccess DB at Wordpress site?

I need an advice from skilled Wordpress developers. My organization has internal MS Access database which contains numerous tables, reports and input forms. The structure of DB is not too complicated (...
0
votes
1answer
51 views

Is this query non compatible with php? It there a glaringly obvious syntax error because I can't get it to run

So, I am currently making a dashboard for my boss, displaying data from a logistics perspective, he has sent me his own MS Access query, for the life of my I cannot make it run, in an attempt to make ...
0
votes
1answer
31 views

'Search as you type' Form with KeyPress Event doesn't work

I was setting up a main-form in MS-Access, from which I could execute my queries and everything. As Part of this, I wanted to have a search bar that searches for Items (Vendors) from a local Table you ...
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
27 views

MS Access Syntax Error: When I select the ID in the list table it gives a syntax error with the ID=

I am pulling in salesforce tables from a sql server db and the picture below shows how the data types were set. I am using the customer template and the list and detail screens work with the sample ...
0
votes
1answer
24 views

How to display the contents of a global [static] variable in a textbox?

I am setting up a form that displays calculated string variables. The data comes from subs that put their results in a variable accessible by other procedures. How do I define the textbox....

http://mssss.yulina-kosm.ru