Microsoft Access is a rapid application database development tool.

learn more… | top users | synonyms (1)

-1
votes
0answers
14 views

Corrupted MDB Access File

a customer of mine has a software for managing its store. The software house that produced it has closed, so he can't ask for assistance. One of the DB files of that software is now corrupted and so ...
0
votes
0answers
35 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
29 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
34 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
36 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
22 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
60 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
53 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
19 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
54 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
36 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
18 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
39 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
139 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
35 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
1answer
217 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
105 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
53 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
62 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
17 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
168 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
23 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
61 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
19 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
39 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
44 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
36 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
49 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
59 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
208 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
167 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
24 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 ...
0
votes
0answers
88 views

How to select multiple tables when using Access 2013 linked table ODBC

Would anyone know how to select multiple tables when linking to an ODBC connection in MS Access 2013? I used to be able to hold down the shift key and skip lines that would automatically highlight ...
0
votes
1answer
101 views

Duplicate a record but needs to increment one of the data fields [closed]

I'm a newbie in ms access and i need someone to help me how to duplicate a record, but one of the fields should increment (+1).. thanks Database is already been populated, one of the field is ...
0
votes
1answer
379 views

Microsoft Access Left Join Query Giving “Invalid Operation” Error

Here's the question: I'm getting an "Invalid Operation" error on a LEFT JOIN query and, although I think I can identify the field causing the issue, I can't figure out why and what to do to fix it. ...
0
votes
1answer
64 views

Append info to an existing field based on the value of another field

I would like to run a query that updates a field's value with whatever is already there but with an "cbt" appended in the end. For example say there's a field called Currency and for a certain record ...
1
vote
1answer
83 views

Find a student with select grades

I have just made an Access 2010 database for analyzing students’ grades in an exam. I was able to get grades for all students right. There are six subjects. What I want to do now is find who got A ...
0
votes
0answers
93 views

RegEx (or RegEx-like) validation rules?

I've built my own (crude) version control system for Access and I'm looking to validate the version number in my update log table. The version number should match the regular expression ...
0
votes
1answer
41 views

Enforce referential integrity with linked table

I'm currently constructing and maintaining a number of MS Access databases intended to replace paper document systems where I work. As part of this work I'm using simple username/password combinations ...
-2
votes
1answer
38 views

MS Access 2013 append(+ sign) option gives error

I deleted the relationships,saved the database and opened it again after 15 min and this mysterious append option appears and when clicked this error occurs in employee data and payment table ERROR ...
0
votes
0answers
61 views

Why does Access return “Conversion Type Failure” if I'm importing text into… text?

For some reason, no matter what, I get a "Type Conversion Failure" (found in a generated log-table) after importing data from an Excel spreadsheet. It's only happening to a few columns that have ...
0
votes
0answers
165 views

Changing the Table name for a linked table in Microsoft Access

I have a Access form application to create a labour posting import file. we use it enter the labour posting details and create a edi import file, which is later imported to our ERP software(Syspro). ...
1
vote
0answers
29 views

MS Word 2010 - database links no longer prompting on open

I have numerous documents that used to automatically link to a database upon opening with the statement: Opening this document will run the following SQL command: SELECT * FROM ...
1
vote
1answer
288 views

XML to Microsoft Access — avoid losing keys

I want to import an XML document into Microsoft Access 2010. Here is a sample from the XML: <ROWSET> <BIOG> <BIOG_NBR> 10021616 </BIOG_NBR> ...
0
votes
1answer
519 views

mail merge to separate documents with filename based on Merge field

I'm doing a mail merge from a Access database and I'd like to make many documents from the mail merge, instead of just one. I found a macro that lets me split the merged document after it's made, that ...
0
votes
0answers
82 views

Update Combobox Fields via an Access 2013 Form

Simplified version: I would like to update a table field based on a combobox: SELECT [Table].[ID], [Table].[Name] & " " & [Table].[Year], [Table].[Info1], [Table].[Info2], [Table].[Info3] ...
1
vote
0answers
26 views

Data model for services quotes with MS Access

I'm trying to create a simple quoting tool using MS Access. It's supposed to be a variation on the standard Orders - OrderDetails - Products type of M2M data model, however the complication is that ...
1
vote
1answer
90 views

Need help building an Expression [closed]

Need to know how to build an expression from this query:Create a new column to display High Priority for all loans that have an InterestRate of 7.5% or more, and Low Priority otherwise.
1
vote
1answer
56 views

Microsoft Access force override table row ID

I have a table with a missing record, when I recreate it (18) the new id is 127 because it's autoincrement. When I go to change the row id to 18 (and there is obviously no row with the id 18) it ...