Microsoft Access 2010 is a Rapid Application Development (RAD) and desktop/workgroup database application.

learn more… | top users | synonyms (1)

0
votes
1answer
63 views

How to store a Display text along with Hyperlink in Microsoft access 2010 database?

i mean how to store "Display text along with Hyperlink" in microsoft access database so that when you generate "Forms" from the database table. and you click on the that item text , you are actually ...
0
votes
0answers
62 views

Text Box and Combo Box conflict

I should mention that I'm brand new to Access, so please don't vote down my question. I really need help on this. If someone doesn't help me, then I'm just going to keep posting the same question ...
0
votes
0answers
31 views

Recover back end database password from front end connection string

I built an MS Access database about a year ago and set separate passwords for the "front end" and "back end" components of the database. It's been a long time since I've had to access the back end ...
0
votes
0answers
124 views

Microsoft Access 2010 and 2013 not responding when trying to filter columns

In Windows 8, when we try to use the filter option in Microsoft Access 2010 and 2013 using the keyboard option (arrow keys), the application stops responding. The error occurs only if the rows are ...
0
votes
0answers
7 views

Unable to display text in chrome url bar from ms access 2010

When trying to run Follow.Hyperlink passing a string variable as a url (partially in Greek), in MS Access 2010, Chrome displays Greek characters as ? making it impossible to load the correct page. The ...
0
votes
0answers
32 views

How to customize Services template in Microsoft Access 2010

I am currently using the Microsoft 2010 Access "Services" template. I am trying to customize it. I am specifically trying to make the template let me number my quotes and invoices manually after they ...
0
votes
0answers
19 views

2010 Microsoft Access Relational Table Insert

I am working with a Microsoft Access 2010 database with 3 tables. What I want to do is edit the 3rd table (Street) and be able to call information via combo boxes from City and State. When I add a row ...
0
votes
0answers
30 views

Query doesn't run after I save it

I found a similar issue on another site (http://www.pcreview.co.uk/forums/query-doesnt-work-after-saving-t1167541.html) but there doesn't seem to be a solution. I have the following query: SELECT ...
0
votes
0answers
37 views

How to place query data of one column into multiple report columns

I have a multi-table query in Microsoft Access 2010. The Employee Table (name, employee #, position, etc.) and a Time Input Table (date, cost code, Reg hrs, OT hrs). After inputting hours, cost code ...
0
votes
0answers
49 views

Some images do not display on Access Report though image url is valid

I created a report in access 2010 with an image that is controlled by a text field in a table that stores the image URL (thanks to the solution here). The report has about 500 records (each with it's ...
0
votes
2answers
141 views

How to lock Access 2010 record after it has been saved?

How can I create a macro to permanently lock a record once it has been saved? My problem: Every Access 2010 lock command that makes the saved records un-editable, also locks the 'New Record' form ...
2
votes
1answer
417 views

When importing an Access table into Excel, a look-up column is showing all values as numbers

I have a basic Access to Excel question that has me frustrated. I have two Access 2010 data tables. One is a list of managers. The primary key is a manager ID (which is an autonumber because managers ...
0
votes
1answer
73 views

Can I change the default Access 2010 view to allow for “Window”ed objects?

Before Access 2007, Microsoft Access was an MDI Container. For those who aren't developers, this means that each time you opened a DB object (i.e. Data Table, Query, Form) it appeared as a window ...
0
votes
1answer
1k views

Access 2010 Table appears to be locked and can't be modified? How do I unlock it?

I have rather simple Access 2010 database. I needed to add a new field to one of the tables. While in Datasheet View, I Clicked the "Click to Add" column header and defined a new field. I went to ...
0
votes
0answers
131 views

Microsoft Access - how to show document location in quick access toolbar?

In Excel 2010, I am able to show the location of a workbook by adding "Document Location" to my quick access toolbar (this is found under "commands not found in the ribbon). This is shown in Excel ...
0
votes
0answers
19 views

How do I export my access contact web database to outlook so I don't have to reenter them from scratch?

I want to know how I can export all of my contacts from my access account into my outlook contacts. I have tried to link tables and it just goes back to my database in access and not my outlook. I ...
0
votes
2answers
141 views

Access 2013 file to open in Access 2003

I made Access Form which was working fine in Access 2013 and Access 2007 until I add some new features(I don't remember what) to it. After adding them, it keeps giving me error "Unrecognize file ...
0
votes
0answers
48 views

Access 2010 Can Shrink property

I am trying to print a report with Access 2010. I have managed to get the Can Shrink Property to show correctly in Report View but it does not show in Print Preview. What setting am I missing?
3
votes
1answer
850 views

How to avoid rounding numbers in MS Access 2007-2013?

I have an MS Access 2007-2013 database (.accdb format) which I open in MS Access 2013. It has just one table with several columns Lat Long PositionDate -54.82045 -68.33834 ...
1
vote
1answer
65 views

MSAccess - Updating all fields in form when selecting one field from listbox

I have a form which has the following fields Club Player Handicap Membership Number Score I have set the Club as a list box how do I get the other fields to automatically polulate when I ...
0
votes
0answers
102 views

Microsoft Access change default row height for inserting rows on form?

I frequently insert new rows in a table layout on an Access form. I am unsure where to change the "default row height" - the rows are always 0.1667" height when I insert them. The rows I am adding ...
0
votes
2answers
789 views

Password Protect Access Database from Edits

I'm familiar with how to encrypt an Access database with a password (requiring a password to view data). Is there a way to allow data viewing w/o a password, but requiring one for editing the ...
0
votes
1answer
27 views

Automating the input of query criteria

New user to this site and found an extremely informative answer to a question I had but can't find an answer to this one. Using Access 2010, I have 42 different criteria that I need to run ...
0
votes
2answers
155 views

Why is my pivot chart not saving properly in Access 2010?

Working in Access 2010 and am trying to build a pivot chart from a query. My query is looking at an item type (multiple possible) and closure date with the intention of creating a stacked bar chart. ...
0
votes
1answer
406 views

MS Access List Box Lookup on Table Not Showing in SubForm

I have a list box lookup embedded into one of my tables: This works fine and shows up in the datasheet view of the table. However, I built a form, bound to the table, but the drop down list does ...
0
votes
0answers
32 views

Add Microsoft Access to my 2010 package

Let me know if I am sinful for asking this and I will delete it. I would like to add Access to my 2010 Office package (for a few months). Is that possible? How is it possible? The issue is that I am ...
0
votes
1answer
339 views

How to automatically make all entries to become Hyperlinks to files in folder in Microsoft Access Database

I have Microsoft Access database, where I want to keep hyperlinks for the pdf files. I got the list of filenames and put in corresponding fields in my database. I made that Field of Hyperlink Data ...
0
votes
1answer
412 views

Export an entire Access (accdb) database to csv/txt

There is no option to export the whole db, rather Access only allows export of one table at a time. I'm not familiar with any VB scripting so how would I go about doing this? CSV must be exported ...
0
votes
1answer
663 views

Save multiple Selected Items From List box In Access

I have a simple form in Microsoft Access 2010 in which I have a list box with Multi-Select Enabled. I want to save the selected items in table. How would I go about it in Access 2010?
0
votes
3answers
3k views

Active content security warning in all files

Every time I open a *.mdb or *.accdb file I get the yellow Message Bar with a text in Spanish that translates as: Security Warning: Some active content has been disabled. Click for more details. ...
0
votes
0answers
691 views

How do I control MS Access navigation pane by macro or VBA?

I would like to use either macro's or VBA to programatically control the Access Navigation Pane (i.e. hide and unhide it). I've found plenty of resources to hide the Navigation Pane (e.g. ...
2
votes
0answers
78 views

Error when validating formula

I am trying to create a field to convert currencies from one of 2 fields, thus I am putting the following code in "Default Value" as I want this field to be open for my manual input too: =iif([£ ...
0
votes
0answers
46 views

Microsoft Access 2010 upgrade issues

I have just been upgraded to MS Access 2010, and am experiencing: syntax error (missing operator) in query expression "xx" Is this because all the tables were created in Access 2007, and Access ...
1
vote
1answer
1k views

Is there a way to convert a memo field to a text field in Access 2010 in an expression?

I have two tables (each in an Access DB) -- called LinkedTable1 and LinkedTable2 linked to my working Access database. I got them on my computer after downloading them from a SharePoint site (Actions ...
0
votes
2answers
496 views

MS Access Default Images Used On Access Forms and Reports (header section)

From within Access, if you click on the Create tab and then click on the Form button, it creates a basic form with all the fields from your table/query. In the top left hand corner, an image always ...
0
votes
1answer
678 views

Move The New Record Entry Row In Access Table To The Beginning Row

Is it possible to move the "New Record Row" in an Access table to the beginning of the table? For example, say you have 200 items entered into your table, you would have to scroll the whole way down ...
0
votes
0answers
34 views

Access Query: Matching days up days of the week for past years

I have historic data in a table in Microsoft Access from seven years ago. I need to create a query with a column for each year and match up in each row the 1st Monday in 2007 with the 1st Monday in ...
1
vote
1answer
429 views

Access 2010 Multi Table Report Combining Fields with same info

I am creating a Microsoft Access database for my office and am trying to create a Report to show every purchase for the whole office. My office is split into 4 teams, and, due to the differing ...
3
votes
2answers
418 views

Truncation of Calibri rich text in preview/PDF mode on a report

I am experiencing truncation of text in rich text boxes in preview/PDF mode on a report. There is enough space for the text box to grow on the page, and the text appears in full in layout mode, but is ...
0
votes
1answer
4k views

how do you use RunSavedImportExport from a macro

I have yet to figure out all the 'musts' for getting this gem of a macro step to even show up in my macro step drop down. does anyone know what you have to do?
0
votes
2answers
7k views

How can I change the default datasheet font in MS Access 2010?

I've never liked the default font that is used as for datasheet views in MS Access. Recently, I've upgraded from 2003 to 2010, and for the life of me I can not find out how (via Google or otherwise) ...
0
votes
2answers
5k views

Why won't MS Access 2010 show my list of System DSNs when I attempt to link data tables from SQL Server?

Recently the company that I work for has upgraded my PC from Windows XP to Windows 7. On my new PC they've also update my version of MS Access from 2003 to 2010 and they also gave me a new domain ...
0
votes
3answers
3k views

Is there a batch command to check for Access 2010 Runtime installation?

When using a batch file, is there a command I can use to check if Access 2010 Runtime is currently installed and if is not, then invoke it's installation? This will be used on both Windows 7 and ...
0
votes
1answer
2k views

Microsoft Access 2010 tables not showing the new record row with the asterisk

I have an .accdb on the network. The .accdb has various objects (queries, tables, forms). The problem lies in a form which has the following dependency form <--- table <---- query <---- ...
1
vote
1answer
395 views

UTF/unix time conversion in access

I am fairly good with access/excel/etc. However I am running into a brick wall with a database I query regularly for information. It has date/time fields that are tracked in unix time format (number ...
0
votes
1answer
737 views

Focus the property sheet in Access 2010

Is there any keyboard shortcut in Access 2010 to focus the property sheet? In Access 2000 and 2003, I could press F4 (or Alt-Enter) and then type to change the value or the selected property, or use ...
0
votes
1answer
1k views

Access 2010 forms: direct entry of foreign key into text box

In a form I am creating for an MS Access 2010 database, one of the fields represents a foreign key. I would like this field to be displayed as a text box, rather than as a combo or list box as is ...
1
vote
2answers
12k views

“MSCAL.OCX” error when moving from Access 2007 to 2010: I don't have a calendar

I have a database created in Access 2007. When opening it in Access 2010 I get the following error: "Your Microsoft Office Access database or project contains a missing or broken reference to ...
2
votes
1answer
873 views

Is it possible to create groups of objects in Access 2010 forms?

I have a form with 3 option buttons, and about 50 labels, textboxes, and buttons. Is there a way I can group some of these objects so that way when I select an option, some of the objects get disabled ...
0
votes
0answers
547 views

When using the Access Table Analyzer Wizard, I get the error “Cannot define field more than once”

I'm trying to normalize a very simple dataset: user_id | role_id I have a table with 60,000 records, and all I need to do is turn this into a join, so one table contains users, and another table ...