Microsoft Access is a rapid application database development tool.

learn more… | top users | synonyms (1)

-1
votes
0answers
10 views

How to write this Excel formula in MS Access 2013

How to write this Excel formula in MS Access? =if(A2=A1,B1+1,1)
0
votes
1answer
22 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
12 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
30 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
11 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 ...
-4
votes
0answers
38 views

how to disable some (or all) function of an access database after specified duration [closed]

"to block features in a way that is reversible by entering a key you would provide after payment" this is what I ll like to do sire... How will I go abt it. I have nt really researched, I am going ...
1
vote
0answers
14 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
17 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
27 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 ...
-1
votes
0answers
17 views

Microsoft access - enlarge image

A friend of mine has created a database in Access and it contains an image field. He wants somehow, to enable clicking on the image and make it larger. Something like a lightbox. Is this possible?
0
votes
0answers
11 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
53 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
87 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
31 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
13 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
25 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
42 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
75 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
30 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
49 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
40 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
22 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
34 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
36 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
83 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
17 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
79 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
163 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
60 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
23 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
61 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
34 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 ...
0
votes
1answer
107 views

Inserting Autotext (or Quickpart) into Word (2013) on the basis of a Boolean value from Access (2013)

Haven't found any info on this anywhere on the net (at least any that works--more on that in a moment). What I am trying to do is have, at the push of a button that I have created in an Access Form, ...
0
votes
0answers
204 views

Access The object doesn't contain the automation object

I have an Access file producing an error when typing in to any field... The LinkMasterFields property setting has produced this error: The object doesn't contain the automation object How do I ...
1
vote
3answers
391 views

Access Linked Table Manager missing, can't change linked database

In an Access file the "Linked Table Manager" is missing in Office 2010, in fact the only menus are File and Home are visible. How do I unhide the Linked Table Manager so I can fix the location of the ...
0
votes
2answers
34 views

Generate list of Microsoft Access database tables

How do I have Microsoft Access generate a list of Database tables? I came across an SQL query someone suggested on anther website however Access doesn't seem to have any interface to simply allow ...
1
vote
2answers
54 views

Error exporting Access database table to new database, can't find what should not yet exist

How do I export a Microsoft Access database table in to it's own *.accdb database? When viewing the list of tables on the left column under the "Tables" category I can right-click and export but when ...
1
vote
1answer
83 views

Export MS Access 2010 SQL

Using Microsoft Access 2010 how do I export the SQL to an SQL file? The output should be similar to how phpMyAdmin exports SQL; a phpMyAdmin SQL export file can be imported to a database via a source ...
0
votes
1answer
16 views

Expression in Access involving dates

I have written the following formular in Excel to calculate the year a person will be 18 by 1st September based on their DoB (in cell F2). It seems to work ok in Excel: ...
0
votes
0answers
17 views

Access freezes before I can change data source

I have an .adp file that connects to MSSQL Data Source A, on Intranet #1. I copy the .adp to Intranet #2, including moving the .mdb to MSSQL Data Source B. I try to open the .adp to change the Data ...
-1
votes
1answer
26 views

MS Access 2013 Online - How to add SQL?

I have been using other versions of Access that allow for easy reporting and SQL. I am trying to use the MS Access 2013 Online Web App but I can't seem to use SQL. Where is the feature for querying ...
0
votes
0answers
39 views

MS Access Form input to text box changes to a number when form is saved

I have been asked by my employer to "fix" a database error. There is an Access form in which there are several text boxes. One of the boxes is for the Last name of the individual added to the ...
1
vote
0answers
20 views

Microsoft Access database worked before and now old records won't update

This code was working fine on Windows 2003 Server. Updated to Windows 2008 Server and now new records can be listed for update or delete but old records can only list record content, but can't be ...
0
votes
1answer
137 views

Microsoft Access Web App - Sharepoint online - user permission only for the app

I want to publish a access web app (2013) with sharepoint online to the web for costumers. I don't want that the users of the app have access to the sharepoint site behind the app, neither that they ...
0
votes
1answer
28 views

Where'd my ribbon tabs go in ms-access?

In MS access 2010, if I create a brand new project, the ribbon has a lot of options and actions. But if I open an existing project, created in MS access 2003, I can't see any of those tabs. Does ...
0
votes
1answer
18 views

Reading a web based datafile every five minutes with MS Access

I have a local webbased datafile that I would like to query every five minutes and save the data in a table. The data is a flat file that I would need to parse if it just went into a table. I am ...
0
votes
1answer
21 views

Reconcile multiple versions of an Access table [closed]

An access mdb file has bounced around between several computers, and old versions of the file have been used on some computers while the copies were being used on other computers. This has resulted in ...
0
votes
0answers
21 views

MS Access - How are reports connected to queries and how can I find out which belongs to which?

I need to understand MS Access reports. I have old MDBs with connected tables from an Oracle DB. Some queries collect data. And reports are used to present data and to send it via e-mail. (~10 queries ...
0
votes
0answers
49 views

How to combine an Excel spreadsheet with word documents using a field from the excel rows matching filename of word doc

I am trying to combine an excel spreadsheet with associated word documents. There is 1 word document per excel line. I have the Excel spreadsheet with all the rows. I have all the word docs in a ...
0
votes
1answer
43 views

Send Email's from Access 2007 with Lotus 8.5

I've this code bellow. It save the email with all receipts but it only send to the first receipt; On Lotus sent folder --> teste@hotmail.com;test@gmail.com On the Receive end --> test@hotmail.com; ...