Microsoft Access is a rapid application database development tool.

learn more… | top users | synonyms (1)

1
vote
1answer
13 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
19 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
29 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
7 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?
-1
votes
0answers
4 views

validation on MS ACCESS 2010 "number data type

I created a field in Ms Access Database which is Primary Key Called ID_No date_type NUMBER so i want it to confirm from Gender field, if Gender is Male then the firth number is suppose to be 1 if ...
0
votes
1answer
14 views

Unable to delete objects in an Access 2010 database

I converted a database from Access 2003 into Access 2010 by opening the .mdb file in Access 2010 and saving it as an .accdb file. I am now unable to delete any of the forms, queries, etc in this ...
0
votes
0answers
8 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
7 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 ...
0
votes
0answers
8 views

Microsoft Access multi-user issue

I have an issue with a multi-user database; read-only users are getting error messages in the style of "could not use..; file already in use". The database is stored on a network share; I created two ...
0
votes
0answers
31 views

Creating a functional MS Access runtime application

I have created a functional Access database Feuilles.accdb. I want several users to be able to enter information via the form interface I created without having access (hehe) to the tables and ...
0
votes
1answer
19 views

How to replicate a MS Word document's layout and formatting in a MS Access 2013 report

I'm building an order processing system in MS Access 2013 that allows the employee to input order details from the customer's form, then the system records this in the database and generates an ...
0
votes
0answers
20 views

Excel vlookup in two access tables

What i want to do is use vlookup in Excel with data from two tables in Access. Vlookup will search for a first/last name field into both those tables and return info from them. I can't seem to find a ...
0
votes
0answers
17 views

Query Concatenation

I need to concatenate 5 fields together. Now the problem is field field2 could have data but not field1 which gives me a headache of extra white space at the beginning and an un-necessary comma if I ...
0
votes
0answers
21 views

MS Access 2010 compacts on close. How to prevent?

I have an Access 2010 application that runs on a busy network (separate front/back ends). Lately when I close it, the compaction utility runs. It's just as if the option was checked for "compact on ...
0
votes
1answer
32 views

Change background color of text box in MS Access form based upon information from query

I have a form that displays data from a table in MS Access 2010 and allows users to change the data in the table; along with other information this table has a list of unique serial numbers. I would ...
0
votes
1answer
54 views

Excel Formula - Match

Can someone recommend a way to write a formula that will achieve the following. I can achieve these things individually but stringing together seems to be difficult. I have a list of orders with ...
0
votes
1answer
88 views

In MS Access, how can a form provide a drop-down populated with data from a related form?

In my MS Access database, I want to create a form to fill out a new order. I have a table Customers and a table Orders **Customers** => (id, firstname, lastname, address) ^ ...
0
votes
2answers
110 views

Create a query/form that can update a table

I want to know if it's possible to create a form that has read/write access to a very specific (filtered) record set of a table. To achieve this, I: 1. Create a query which filters the records of a ...
0
votes
0answers
39 views

Heterogeneous Workbook Consolidation – Need Assistance

I have several Excel workbooks, each containing a couple dozen spreadsheets. The workbooks have different names and so do the spreadsheets, and simply mass consolidating doesn't help with the issue I ...
0
votes
0answers
84 views

Is there a lesser code to insert records to sql using ms access vba?

Is there a shorter way to insert records to sql more than 30 fields?I am using MS access vba and Linked tables from sql. Can we Insert records using like this Insert into Mytable Values (more than ...
-2
votes
2answers
54 views

Use of Index in Ms-Access Database

Why does an Index make a query run faster? What does an index do? Particularly in Access, if you declare a column as an index how does it affect the query? Any Ideas?
0
votes
1answer
119 views

Connect mysql database to Ms Access directly

I am trying to connect mySql database on our server directly to an msAccess database we have. I want to be able to download data from the mysql database directly and upload it too directly. I want ...
0
votes
0answers
23 views

How to repair a corrupted MS Access database? [closed]

I have 2 databases with 50gb each with very crucial data, now the sql is telling me that both are corrupted. Is there any way to repair? I have run some sql commands that I found on the internet ...
0
votes
3answers
75 views

How do I break up a number in a single cell that doesnt have commas and put it into multiple rows?

So here is what I am looking to do. I have a spreadsheet with a cell that has a string of numbers in it (some are longer than others) I need to extract every eight numbers and put them into single ...
1
vote
1answer
140 views

How can I convert MS Access 2003 (2000 file format) to Sql Server Express 2014?

I've been searching for the past two days on how to get this conversion done, but every suggestion I've seen yields no effective results. I've installed Sql Server Express 2014 and have verified that ...
0
votes
0answers
32 views

How do I set up relationships/queries in this case?

I'm gonna say that I'm a beginner trying to learn by doing. I'm trying to create a database to manage the registration of a summer camp. I started putting it together before I had all the paperwork, ...
0
votes
1answer
76 views

Split data in half evenly by adding column with value: 1 or 2 based on specific cell value - excel

I have a query I pulled from a database with student information. The table has the following columns: StudentID, CourseID, CourseGrade. The CourseGrade column can contain any of the following ...
0
votes
0answers
59 views

Cascaded Combo Box based on multiple comboboxes on Access webapps 2013

I am stuck with combo boxes. I have 3 Combo boxes- Country, Region and City. now I want the city to be populated in case the country OR the region is selected. It should also allow me to select the ...
0
votes
0answers
27 views

Where is the “Click to Map Hyperlink” button?

I don't see the "Click to Map Hyperlink" button and I was wondering where it was because I'm trying to map a contact.
1
vote
1answer
73 views

Using a MS Access 2013 file in MS Access 2007

I've created a database in Access 2013. I thought this would work on Access 2007 which is on the computers out on site. Unfortunately since I added in things like queries to generate reports for ...
0
votes
1answer
555 views

Microsoft Access Form - Auto Populate Form Field From Another Form

I have been searching for the answer to this but can not find anything. I have one main Access form and several Sub Forms in different tabs on the main form. There is a single field on each Sub Form ...
1
vote
0answers
37 views

Is this something I can do with Microsoft Access? [closed]

I'm trying to track usage of over 4000 titles worth of books at a preschool. I was wondering if a web database would be possible. I'd like to be able to go around with an iPad and type titles in ...
2
votes
2answers
269 views

odbc error connecting mysql: “sql server does not exist or access denied”

For a few weeks now I have been trying to create an odbc connection with microsoft access and a mysql database on webhost server with no luck whatsoever. I have no problem connecting to the database ...
2
votes
0answers
213 views

Append values to Access table from Excel with ID autogenerated

I have an Access database with some tables which get updated daily with some values. I need the tables to have an ID field which is auto-generated when the other values of the table are imported from ...
1
vote
1answer
88 views

How to create a MS Access query to show a data in columns by criteria?

I have a little problem with MS Access 2013. I cannot figure out how to create a query to show needed data in one table. The data structure can be illustrated with the following: USERS ID Name 001 ...
2
votes
0answers
18 views

How to return results of SQL query to Excel sheet with VBA function [duplicate]

I'm trying to create a VBA function in Excel to affect dynamic value from Access to Excel sheet. This is my code. Public Function SQL(DB As String, Query As String) Dim conn As ADODB.Connection ...
0
votes
1answer
99 views

How to extract value (hour / minute) from a data field in MS Access?

I have a column with data fields in MS-Access and I need to generate two new different columns with the value of the hour and of the minute. Data column: 24/03/2015 20:33 I need a column with hour ...
0
votes
0answers
27 views

Export specific results of Access 2010 query determined by checkbox

I am working on a planning tool which provides information about how long particular tasks should take. Everything was working as expected but I have just been informed that the user would like to ...
0
votes
1answer
336 views

Access 2013:Trying to write macro to update form fields from a query result

I am trying to create a macro to update the value of a field in a form based off the results of a query. I am entirely new to working with vba in Access so I apologize if I am asking a basic ...
0
votes
1answer
24 views

Access Switchboard routing duplicate work to employees

I have an access database with 30+ users working from the same parts of a switchboard as a work router. It is typical for them to get an error that another user has already updated something they are ...
1
vote
2answers
133 views

Microsoft Access. Working with queries and null values

this might seem an easy question but I can't figure it out. I have a table with a number of fields. 3 of them (SizeA, SizeB, SizeC) are numbers and I have a form which uses a query to query the table. ...
0
votes
0answers
25 views

Determine where an access database is stored

I'm logging onto a machine in a corporate network, which has Access on it. When I open Access there's a Jet database in the recently used files list which I can open. Is there a simple way of ...
1
vote
0answers
53 views

Microsoft Access missing records — Google Drive sync issue?

I have a small Microsoft Access database located on my Google Drive. (The Google Drive is shared between two laptops and one mobile device, but the mobile device never touches the database.) I ...
0
votes
0answers
53 views

updating or changing a value automatically in MS Access

In access 2007 how can I go about it if I want to (for example create two tables “stock” and “customer) and I want to create a particular field that'll be present in both fields (i.e a field like ...
-2
votes
1answer
42 views

issues with referential integrity (access 2007)

I kindly request for a specialist help, probably a database designer or administrator. I have been encountering this problem setting a referential integrity for two tables, setting the referential ...
0
votes
0answers
65 views

Access Forms: Use toggle button to discern if query field contains info

I have a form that uses combo boxes to select certain values from a query. I have a lot of columns that are blank on many records and I was hoping to use a toggle button to filter the query to only ...
-1
votes
1answer
63 views

.mdb file completely corrupt after the frequent recoveries

I am running Access database and one of .mdb files was corrupted for a long time. I got an error messages repeatedly, unfortunately I don’t remember exactly which ones. I let it go because I was still ...
1
vote
2answers
309 views

Access database error: The module name xxx is misspelled or refers to a module that doesn't exist

We are using Access database 2003 (I know, too old) with Win server 2008 in my company. We have one .mdb file split into two. A couple of days ago we had a problem trying to open modules. It all ...
1
vote
1answer
299 views

Automatically adding/expanding new row in MS Access forms

I am trying to build an invoice form in which the user has to select an item and when ever the item is selected from the combo box, a new blank row should be added at bottom as shown in the screen ...
0
votes
1answer
28 views

Access 2010 - Macro to set dropdowns to preset fields

I work with a form in Access daily in which I repeatedly have to type the same words into the same fields. I would like to automate this (those fields auto-fill to predetermined text when I press a ...