Microsoft Access is a rapid application database development tool.

learn more… | top users | synonyms (1)

0
votes
0answers
4 views

Same Excel workbook fails to connect to Access DB for SOME users

I have an Excel workbook that is pretty heavy with code and connections to Microsoft Access. When the Workbook opens, it looks at the database's full path, written in a cell in the Settings sheet. ...
0
votes
0answers
22 views

internet connection is suspended whenever I run an MS Access query

Whenever I run a query in Access 2010, I can't use the internet. My pages won't load until the query finishes and my downloads hang. Anybody know why that is and how it can be corrected?
0
votes
0answers
9 views

How to only modify data in table of microsoft access through update queries

I am quite new to Microsoft Access and would appreciate if someone can help me with this. I would like to modify data in table of microsoft access through update queries only but also prevent the ...
0
votes
0answers
11 views

Ms access file with with persian and english text

I have a Microsoft Access database file with the .mdb extention. It's database of a flashcard program and it contains English and Persian text. When I open it with Access there is no English or ...
0
votes
0answers
7 views

Run Query to Append to Table and Export to Spreadsheet - Automation

I need to run an initial query which will have to go to one target table, and every time the query is run thereafter it will have to only yield new results not already on the target table. I have to ...
0
votes
0answers
13 views

Access Query Save Path Error

I am trying to save an Access query with a certain path (which i can't modify) but i am getting a save error. The save path looks like this : "C:/FOO/BAR/03. FOO/BAR.accdb" Testing the path i found ...
0
votes
0answers
26 views

MS Access - how to merge query results

I have a couple of tables from which I`m trying to join the results. The query I`m using: SELECT distinct CTCtbl.nombre, CTCtbl.Apellido, CTCtbl.LimitacionB1 AS serie, CTCtbl.NumCertificadoSegTipo ...
0
votes
1answer
21 views

Access MsgBox for automated email

I have an Access DB set up with VBA code for a yes/no command button to send an automated Outlook email. If user selects Yes, it opens the email to allow for attachments. My problem is that when the ...
0
votes
1answer
32 views

Using SQL to merge .xlsx file and over 1,000,000 rows?

I'm having trouble with an operation that I believe is limited by the shear size of the data - the operation is a merge and filtration of two Excel workbooks, each with over 1 million rows. Perhaps ...
0
votes
1answer
11 views

How to replace hidden elements in access?

I work with MS-Access database with a lot of tables, qureys and reports. It is easy to hidden some elements (by right mouse click then hidden options), but I do not fin the option to replace those ...
0
votes
0answers
27 views

MS Access - populate form by clicking on record in subform

Have a form with all the necessary fields. About 100 fields on different tabs. On the form I have a subform (from query) that shows a portion of the fields. I want to click on a record on that subform ...
0
votes
0answers
14 views

MS Access report leaving space when duplicate records not printing

I have a sub-report in an Access 2013 db that prints footnotes from a table in the main report. When there are duplicate footnotes in the table, I only want to display them one time. But when I ...
1
vote
2answers
27 views

How to get two values from one table in ms access

I want to know that How can I get two values from a table in ms access. I have a CustomersTable, which contain CustomerId,Name,Phone,Address.... , Rate. (I am adding Rate in this table because rate ...
1
vote
0answers
54 views

How to put name and registration number in a form

I'm creating a database which stores client related information, in which there are two tables:   A. Client registration   B. Work done. So I have created 2 forms:   a. ...
0
votes
0answers
37 views

How to Create a Query which Combines Two Crosstab Queries under a Split, Merged Column

Sorry if the title is a little confusing. I am attempting to create a query which takes two cross-tab queries and combines them in a slightly different format than the original cross-tabs. I have used ...
0
votes
0answers
11 views

Microsoft Access 2010 Focus Shortcut F6 no longer working as expected

Since Microsoft Access 2010 the shortcut F6 seems to bit "broken". Originally the key was used to focus the details in table design view and query design view for example - and pressing F6 again took ...
0
votes
0answers
28 views

Classic .ASP and OnChange and reading an Access database (WIN10)

I'm trying to populate the contents of a web form with an Onchange header function (select * in database where ID="somevalue") but I don't know how to open the database whilst in the header function ...
0
votes
1answer
18 views

Nested IFF query in MSAccess returning wrong number of arguments

I am trying to write a nested IFF query in MSAccess, but on running the error returned is "Wrong number of arguments" My two fields Paper1 and Paper2 are of datatype True/False The Query I wrote in ...
0
votes
1answer
63 views

Hardwareinventory - Copy Record with values in Access 2016 Web App

I want to make a WebApp in Access which help me inventory all our Hardware. Below is a VERY wip ERM for the Database behind it. Every CPU-Object is its owm physical thing (if we have 2x i5-3450 there ...
0
votes
1answer
81 views

Excel Pivot Table with Microsoft Access Connection

I have a pivot table which sources its data from a query within an Access database file. Whenever I make an update, I make a copy of both the Excel and Access files first - and carry out the update on ...
0
votes
0answers
23 views

In MS Access VBA Designer window all menus, ribbons and tootlbars are missing

The missing items make it impossible to use. Code can be written, but not executed and tested.I have tried many solutions, most of which are to restart the VBE, but that does not work. In fact, none ...
0
votes
1answer
72 views

How to speed up off-site access to Access application

I built a calendar-type application on MS Access 2013 with SQL Server as the back-end (each day on the calendar is a subform). About 20 tables are connected using the line Call AttachDSNLessTable([...
1
vote
2answers
79 views

Difference between <> and NOT operator in Microsoft Access?

What might the difference between "<>" and "NOT" operator be when used in Microsoft Access?
2
votes
2answers
36 views

Which wildcards can I use for a Microsoft Access form asking for month and year?

I made an Access Database that includes dates. I have a Report connected to a query that, when opened, prompts the user for a month in numbers (1-12) in order to produce the report for that months. ...
1
vote
0answers
11 views

How does Access determine filepaths?

In access when the serverpath is declared and a filepath is listed, if there are two separate symbolic paths how does access choose which path is valid and which is invalid? I have a split accdb and ...
0
votes
0answers
9 views

Microsoft access track missing database

I am tasked to find a missing database of an (microsoft) access file to make it work again. I have never worked with access before so I am a total newb. From what I got by opening it, it had a ...
0
votes
0answers
64 views

Windows Task Scheduler running Access using “Run whether user is logged on or not”

My Question: Is there a way to run MS Access from Windows Task Scheduler using the "Run whether user is logged in or not" option? Background: I am experiencing a similar issue to Windows Task ...
0
votes
0answers
12 views

How do I create an aggregate report in Access 2013?

I'm new to Office and struggling to create what should be a simple report. I've got a tablet with customer demographic information: everything from first name, last name to age and ethnicity. I want ...
0
votes
0answers
7 views

Fields not resetting in MS Access form

The issue is: I have user signup form in MS access and once I fill out the form and register the user successfully and then hit "Back" button and view the form, the values are still there. Typically, ...
0
votes
2answers
15 views

How can I create a query that obtains data from two tables, yet includes records that are unmatched on the other table? Microsoft Access

I need a query that displays all data from two tables, and not all records on Table A have matching records on table B. By default, the query only displays records that match other records in the ...
1
vote
0answers
16 views

Miscrosoft Access - Multi-Table Data Entry

I'm using Microsoft Access 2016, and am designing a tool to track our engineer drawings at work. As you can see from the image of my relationships, the project info cascades down on the left and the ...
1
vote
0answers
42 views

MS Access OLE Error Attempting to Insert Object

MS Access 2010 on Windows 7 Pro x64 Right-click on a cell in a table (Data Type = OLE Object) Click on Insert Object... Select Create from File Click Browse to find .bmp file (844KB) Click OK ...
0
votes
0answers
51 views

Win 7, slow network at work, Can I run Access via a 2nd Nic to a NAS?

We have a terribly slow network connection to out offsite server. The boss will not spend the $ to upgrade it. We have three users who need to use the same Access database which takes forever thru ...
0
votes
1answer
28 views

How do I add one value to a variable every time a date field is null?

In Access 2013, I am working on a report. Using the On print event, I have a problem trying to add one value to a variable every time a date field is null. It works fine somaValores =Somavalores + 1 ...
-2
votes
1answer
72 views

Separate fields in comma delimited fields

I am importing a comma delimited file into a ms access database that has statistical information for horse racing. The file has individual horses, dates of their races, finish position, etc. I am ...
0
votes
0answers
35 views

Changing password on Access 2010 database

I need to change the password on a database. I have taken the following steps: I have opened the database as 'Open Exclusive' Clicked file>Input However at this stage where there should be an ...
0
votes
0answers
14 views

Reading an Access-compatible File w/ Access

I have a .dfm file extension, which I can read in Microsoft Access 2010 (by selecting All Files *.* in the open menu). When I open this file it says it's an "Access 2000" file. Microsoft Access 2010 ...
0
votes
0answers
35 views

Merge data with key column in Excel or access

I have hundreds of folders with 4 tab-delimited data files each. Each file contains two columns. The first row is a header. The first column for each of the four files contains a time value in ...
0
votes
0answers
19 views

How can I find the sum of charges that are in the same field of different costumers in Microsoft Access?

So I have a table with these fields Names Surnames Charge. There are 7 names, surnames and charges. How can I find the total of charges using Microsoft Access? I think I should use a query. Can you ...
0
votes
1answer
25 views

Stuck on Access coding

I have a code that adds records from a form to a table, but when the check boxes are selected, it is adding a -1 (true) in the table field. How can I revise my code to have an alternate word added ...
0
votes
1answer
25 views

How to take information from three columns in a spreadsheet and put it into one column on another under a new column name

I have one spread sheet listed by SKU that has three different columns, Image Color, Size, Pack. (There are other columns but they are unimportant at the moment) I need this information moved to ...
1
vote
1answer
64 views

Access report loses elements when exported to Word

I have created a Microsoft Access Report, with a number of elements in it. These include labels, controls, lines, boxes, etc. When I export the report to Word, it loses all lines, borders, boxes, ...
0
votes
1answer
99 views

In Microsoft Office Access 2013 how can I use my mouse wheel to advance to the next record?

I am trying to set up Microsoft Access 2013 to advance to the next record by using my mouse wheel. My older version of Access allowed me to do this. How do I do it in the newest version of Access?
0
votes
0answers
56 views

How to Create Drop Down Tables In Microsoft Access 2013

My question is: how do I make multiple drop-down tables in Access? I'm trying to make a table with multiple entries and drop-down tables underneath. For example: Main file: Car Types, Sub File 1: ...
1
vote
1answer
72 views

Is there a way to automate the conversion of old Access databases (.MDB files) to the newer .ACCDB format?

I have a couple hundred old Access databases, in the old .MDB file format. I'm not sure which version of Access they were created in. My ultimate goal is to make them usable to someone who has Access ...
0
votes
0answers
59 views

Microsoft Access database processing slow even over fast network

A Microsoft Access database file has about 20 MB size and total of 4000 records in few tables. Does not look like a big deal. However, why this database has 3-5 times longer processing times when it ...
0
votes
1answer
24 views

How can I clear MS Access controls for most of a form, but not all of it?

How can I clear access controls for most of a form but not all? I have one control (Combo55) that I would like to reset rather than clear but am unsure how to change my command to do it. Here's the ...
3
votes
0answers
40 views

Terminate the Access macro after a specific time

I am running several MS Access macros from a batch file. The macro runs several queries in AccessDB. Things are working fine. But, I want to add a check. If a macro runs longer than a specific time, ...
0
votes
0answers
81 views

Refer to form control in Access Web App when adding new record

I have an Access Web App in Access 2013. There is a parent form with a company ID which contains a list subview. When a row is clicked on the subview a popup form is opened to view/edit the selected ...
0
votes
0answers
16 views

Access 2007 Query to Text box

I have a table, which lists firewall rules by assets and ip addresses. Say there are 200 firewalls. I want a way to create a form which will allow me to select an asset from the firewall table and ...