Microsoft Access is a rapid application database development tool.

learn more… | top users | synonyms (1)

0
votes
1answer
4 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
12 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
13 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
5 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
0answers
47 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
10 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
11 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
31 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
11 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
57 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
15 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
32 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
42 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
18 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
4 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
36 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 ...
2
votes
1answer
30 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
38 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
23 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
47 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
49 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 ...
0
votes
0answers
72 views

Inventory list in Excel

I'm posting this as a new question, because the first one I posted wasn't very clear. I'm making an inventory list in Excel, combined with a giveaway/borrow list. There are 3 spreadsheets containing ...
0
votes
0answers
13 views

Can I include all pages of a PDF in an MS Access report?

I have a table that contains an attachment field in Access 2010. Records in this table will each have a single multi page PDF file attached to them. Currently when I add the attachment control to ...
0
votes
1answer
52 views

MS Access 2013: How to open tables in new tab?

In MS access 2013, if you open multiple tables, it should open like this, by default Something happened to my access DB and now tables are being opened in new window, how to restore the default ...
0
votes
1answer
15 views

How many Access databases can an Access form connect to?

Is it possible to have an Access form send data to or retrieve data from multiple Access databases? I want to have user-input data to be sent to a different database, due to size limitations. Can this ...
0
votes
0answers
23 views

Does Microsoft Access have a “Document Information Panel” like other Office programs?

I really like the "Document Information Panel" that is available in Microsoft Office programs like Word and Excel. Does this feature exist somewhere in Access too? If not, is there a way to replicate ...
0
votes
0answers
17 views

Having MS Access send me emails or updates

I would like to store information on my company's activities in a database, and design it so when a deadline approaches, the database could send an email or an alert notifying us that action is ...
0
votes
0answers
28 views

Hide column in report based on combo box on form

In Access 2010 I am trying to get a report to show or not show the contents of one column based on the value of a combo box on a form. For example, the column name in the report is "foo" and I only ...
1
vote
1answer
183 views

How do I allow multiple people to open my Access database?

I have an incredibly simple Access database. It has one pass-through query and that's it (no tables). The query simply executes a stored procedure against a SQL Server database to display the ...
0
votes
0answers
37 views

Copy table from access with no header

Sometimes I need to copy table from MS Access to MS Excel but I need to copy only data and not headers. So I have to copy once data+headers in Excel than select only data and make a second copy+paste ...
1
vote
0answers
48 views

Can MS Access make a column-of-rows type of form like the one pictured?

I am trying to make a form consisting of multiple forms stacked side-by-side in Access, like the one pictured below but have run into many, many issues. I will settle for a report if I can't get a ...
0
votes
0answers
31 views

Got an Access DB with absolute paths that I can't modify. Migrating to new fileshare PC. Hostname is now wrong

I'd put this on Stackoverflow but it's a "How to fix an MS Access related prob using anything except MS Access". I'm fine with computer problem solving generally but I have zero experience with ...
0
votes
0answers
17 views

Access 2013 Report

new to this site and new to Access. I have made a Volunteer Database and all is OK. Added Photos and lots of data for each Volunteer and all is OK. I added a Summary Report that adds different ...
0
votes
1answer
15 views

How to check if elements are linked up/down in MS access?

I have a MS access file (office 2007) with a lot of "history". So I have many tables and querys. I would like to clean it but I would not know how to check which elements can be deleted without ...
0
votes
1answer
51 views

MS Access won't connect to linked Visual Fox Pro after Symantec Endpoint Update

We have an end user used MS-Access database which connects to a Visual Fox Pro directory of .dbf files via linked tables and an ODBC DSN. This worked fine until Symantec Endpoint Protection installed ...
0
votes
1answer
23 views

Repeating Randomness in Microsoft Access Reports?

I have created a report in Microsoft Access which contains a text box. The text box has a simple expression in the control source to generate a random string of digits in a specific format. I need to ...
2
votes
1answer
1k views

ODBC Data Source Driver 'Does Not Exist' After Updating to Windows 10

I received the following errors in the Microsoft ODBC Data Source manager (64-bit), for my data source an MS Access DB (.accdb), after updating to Windows 10 from 7 and uninstalling MS 2010 and ...
0
votes
1answer
130 views

In Access, how can I pull data from another table by matching a field?

I am working on an inventory system for a tool rental shop. I have two tables: Details and Tracking. Details has all the basic information about all the customers (Name, Barcode, ID etc.). Tracking is ...
0
votes
0answers
4 views

Adding a menu in Access reports

I have an Access 2007 database with a report that contains 2 sub-reports. At the beginning of the main report, I'd like to put a link that navigates to the beginning of the second subreport. Is ...
0
votes
0answers
8 views

Micosoft Access: Calculate totals for filtered query

I have a query that I'd like to calculate each column totals for. The main problem is that I want the totals to be calculated only on visible query items, i.e. if I manually filtered out some of them, ...
0
votes
0answers
20 views

Default open MS access report full screen

When I open any MS access report the window cover about half of the available size. How can I default open the report il full screen? Now I have to tap "large" for every first report, then the ...
0
votes
0answers
114 views

Please wait while Windows configures Microsoft Office Access 2010

Background I’ve been developing a DB application via MS Access 2010. Recently, I installed Office 2013 (I needed something in Excel 2013 not present in Excel 2010) and my Access 2010 was uninstalled ...
0
votes
1answer
64 views

uneditable date-time source for vb.net ms access

We are trying to create a time-in/time-out system using vb.net and ms access as database. I'd like to ask for an uneditable source for our date-timestamp. We can easily use system time but users tend ...
0
votes
1answer
97 views

How can I avoid duplicate records in an Access table when entering data from a subform?

I have a MS Access database with three tables: Foods (Id, Food_Name, Food_Desc) Ingredients (Id, Ingredient_Name) IngredientsFoods_mm (Id, Id_FoodsFK, Id_IngredientsFK) ...in a many-to-many ...
1
vote
1answer
64 views

Microsoft Access 2003 - Multiple checkboxes to fill a text field

I am using Access 2003, I am looking for help with using checkboxes in a form to fill a text field. I am using the following code to get the checkbox to fill a text field. Private Sub CAN_Click() ...
0
votes
0answers
160 views

Can not compact and repair the database - Access 2010

I have Access 2010 and want to compact and repair the database. I get this error message (this is translated, so it is not the exact words): "Cannot compact and repair the database. You may not have ...
1
vote
1answer
109 views

can I run a split ms access database on a linux server?

An ms access database has been split so that the back end of it is on a windows server, while the front end GUI is on each user's windows PC. Is it possible for the back end to run on a Linux server ...
0
votes
0answers
11 views

Merging date fields in Access

I have a query that calculates the dates for multiple future events in multiple columns for multiple entities. How do I show all of the dates in a single column?
0
votes
0answers
48 views

Access 2013 database on a read-only share

We have a database on a Read Only share. Access 2013 will not open the file as it cannot create the lock file. Access 2010 never had this problem What settings can I change to get the database to ...
0
votes
0answers
13 views

MS Access DSN Connection

We have a few end users that have a DSN connection in Access a past DBA gave to them. Now they're asking me to allow other users this same access. I'm waiting to see how they're set up but wanted to ...