Microsoft Access is a rapid application database development tool.

learn more… | top users | synonyms (1)

0
votes
1answer
12 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
12 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
26 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
14 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
33 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 ...
1
vote
2answers
65 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
21 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
10 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
18 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
7 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
13 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
13 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
21 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
43 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
25 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
43 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
30 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
21 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
15 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
18 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
23 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
32 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
27 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
52 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
39 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
34 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
11 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
24 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
49 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
15 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 ...
1
vote
1answer
80 views

Back end already in use

We are using an Access Database divided in front end and back end (in a shared folder). I distributed copies of the front end to every user. All users have the shared folder and subfolders added to ...
0
votes
0answers
29 views

AddContactFromOutlook command not working after splitting database

I built a small Access database to track my tasks and a have a few forms where I add clients and contacts. To simplify this, I used a build-in command to add the contact from outlook which worked ...
0
votes
0answers
28 views

Microsoft Outlook Address Book Icon Property

When I export my Outlook address book using Microsoft Access (and then to Excel), no column is added for the Icon property. You know the one, showing either one person, two People, a person with a ...
0
votes
0answers
64 views

MS Office 2010 with standalone Access

I have Office 2010 on my computer and a couple of years ago decided to get Microsoft Access. Microsoft were happy to sell me a standalone Access 2013 download which I duly installed and have been ...
0
votes
1answer
24 views

How can I determine which SQL db my Access app is pointing to?

There is no ini file containing any kind of connection string so it must be embedded somewhere, but where can I find this? The linked table manager appears to point to something but doesn't give ...
1
vote
0answers
242 views

Where can I download Microsoft Access 2013? [closed]

My company has an Office365 ProPlus subscription. Here are the apps included: SEE THE ICON FOR MS ACCESS Unfortunately, since I need Visio, I had to install the non-365 version of Office. This ...
0
votes
0answers
47 views

data type mismatch in criteria expression when navigatin to last record

I have a table where I created a query in MS Access 2010. My problem is that, when I try to navigate to the last record, the Access throws me the following message: data type mismatch in criteria ...
0
votes
0answers
60 views

Convert Access desktop application to Web based

We have an SQL Express database with an Access 2003 front end which we can convert to Access 2010 or 2013. The database has a lot of forms, queries & tables & complex VBA code. What is the ...
0
votes
1answer
106 views

How to automatically refresh MS Access tables in excel, without breaking formatting of other cells in worksheet

I have an inventory spreadsheet that contains a table of records imported from a Microsoft Access database. To the right of this table there is a field for workers to input the amount currently in ...
0
votes
0answers
19 views

How to avoid access db compaction?

My access db pulls data through odbc every few mins and deletes data in local tables and writes new data. After a while db size exceeds 2gb and it has to be compacted. How can I avoid this compaction ...
0
votes
0answers
7 views

How to correctly link remote MS Access tables which may be refreshing?

On Computer A, I have Access database, which every few minutes accesses my AcuCobol server, pulls latest data and creates/refresh data in corresponding local tables. On Computer B, I have another ...
1
vote
1answer
63 views

How do I make a macro to generate a record number based on the fiscal year? (Access 2013)

I would like to create a record number that is based upon the fiscal year and automatically advances... Something like: 2015001, 2015002, 2015003, 2015004; 2016001, 2016002, etc. I already have a ...
1
vote
1answer
34 views

Add column in SQL

I am currently learning SQL, and my current question is. Is it bad practice to have the word "COLUMN" after add when you want to add a column in SQL code? ALTER TABLE FICTION add COLUMN Best_Seller ...
0
votes
0answers
103 views

ms access filter subform based on query

Currently I am developing an Access application for reporting in a small office, however, I am having issues filtering a subform with a combo box in the main form. The subform does respond by removing ...
0
votes
0answers
35 views

Creating a permanent text-piece for several word documents and changing it at-once

Preliminary details I use Windows 10 home and my question deals with MS Office. I use Office 365 business. I have several work-order forms that I send to customers. The header of each document is ...
0
votes
0answers
93 views

Ignore 32-bit office applications installing MS Office 2013 64bit

I have a silent deployment setup for Office 2013-64bit. Works great as long as there aren't any 32bit Office programs installed. However these 32bit Office programs installed are Access Database ...
0
votes
1answer
124 views

Compare two date fields in ACCESS

In MS Access 2013, if you have two short date fields, a and b how, to make a validation rule such that, b >=a ? i tried >= 'a' didn't work so i want to make sure that date b is never less than ...