0
votes
0answers
69 views

How can I reinstall the 64-bit version of MSO2013 if I've purchased a Dell computer with MSO2013 32-bit installed?

W7/64. I'm a SQL Server developer dealing with the mess described here, which is that the 32- and 64-bit versions of the MSA10 engine cannot coexist on a single server. This problem might be solved ...
1
vote
0answers
49 views

Removing Access 2013 password

I have MS Office Access 2013 installed on my machine. I've set an application password a while ago but now I forgot... Since this is not a mdb or accdb specific password, I couldn't find a way to ...
3
votes
1answer
385 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 ...
0
votes
0answers
72 views

Viewing tables from Microsoft Access database on Mac/OSX

I'm looking for a way to VIEW (not edit) tables or queries in a Microsoft Access database on a mac. The database file is located on a Windows computer, and can be put in a shared network location. ...
0
votes
0answers
38 views

Microsoft Access shows part of dataset as empty in pivot chart

I have a dataset which doesn't have any empty cells. But when creating a pivot chart of a query there is a column named empty (leer is German for empty). The datasets within this column are missing in ...
1
vote
1answer
2k views

Install MS Access 2013 alongside Office Home and Business 2010

I currently have Office Home and Business 2010 (64 bit) installed on my computer (running Win7), and the trial period of Access has just ended. I don't want to purchase a whole new office suite if ...
2
votes
1answer
120 views

'Select Table' screen when trying to open MDB file

One of my end-users is having an issue when they open an MDB (Microsoft Access) file over the network. This user only uses this access database once per month, and it worked fine last month. This ...
0
votes
0answers
84 views

Difference between Access 2003 Reports and Access 2010 Reports

I am in the process of replacing Office 2003 with Office 2010. I have noticed that some of the Access reports that displayed fine with access 2003 are not displaying correctly with access 2010. It is ...
0
votes
0answers
376 views

Why is MS Access Report repeating the details section?

I am using MS Access 2010, and I created a form that then produces a report. Because it is designed to print on a label instead of a regular piece of paper, the entire report is smaller than usual, ...
1
vote
1answer
2k views

How to convert from Access 2010 (.accdb) to Access 95/97 (.mdb)?

How can I convert an Access 2010 .accdb file to an Access 95/97 .mdb file? Is there a conversion facility available within Office?
3
votes
1answer
13k views

Why won't Access 2013 open an .mdb file?

Please not that I hardly ever use Access, so I might be missing something very obvious here, but a quick Google revealed little. I am trying to open an .mdb file used by an in-house application, ...
1
vote
2answers
2k views

Access ignoring default printer settings

I have several Access programs, they're fairly complex, lots of VBA in them and dozens of reports, linked tables, etc. When I print these reports, they don't respect my default printer settings ...
1
vote
2answers
5k views

How do I use Expression Builder in Access to create a LOOKUP function?

I recently moved from Excel 2007 to Access 2007 to manage what never should have been spreadsheets. Unfortunately, from what I can tell, the LOOKUP function in Excel does not exactly work the same as ...
0
votes
2answers
2k views

How do I publish/export Microsoft Access Forms

I developed some forms in Microsoft Access and have yet to connect the forms with the database. However I would like to build and maybe publish the forms so I can view them outside of Access. how do I ...
0
votes
1answer
116 views

How to write a query to see who called who the most in an Access database of phone calls?

I have a phone bill in Excel that shows all calls made to and from my phone and I imported it into a table in Access 2007. I want to learn to use Access to do a simple query to determine who I talk to ...
0
votes
0answers
227 views

Access 2012 - Can't find object

When opening certain macros, whether in design or run, I get ' Microsoft Access cannot find the object 'whatever the object name is>'. This only is on certain macros, but most of them work properly. ...
-1
votes
1answer
77 views

Create a query in microsoft Access?

Create a query using all the fields from the Customers table that will show those customers who have purchased a product with the Product ID 2. Save the query as Product and close the query. How can ...
2
votes
2answers
360 views

Access 2000 doesn't start

I have 3 identical new HP laptops, on which I have installed a fresh (legal) instance of Windows XP SP3 32bit from an original media, and a legal copy of Microsoft Office 2000 SR-1 Premium, also from ...
0
votes
2answers
4k views

Cannot write to registry while installing Microsoft Access 2010 - Error 1406

While installing I get an error: : Microsoft Access 2010 encountered an error during setup. Error 1406. Setup cannot write the value to the registry key ...
0
votes
1answer
256 views

Copy & Paste with Microsoft Office

I have 300 rows of data in a table with a single column ( Excel, Access or Word-table doesn't matter) and I want to resize it for printing. So the data will have size 25x12 instead of 300x1. Is there ...
1
vote
1answer
4k views

MS Access 2003 - Format a Number with Commas AND Auto-Decimal

On a report I have a control bound to a column that can have up to 3 decimal places. I want the number to format with commas separating thousands and millions, but I also want the number of decimal ...
0
votes
0answers
186 views

Help with Ms Access 2007 Combo boxes

What's the most efficient way to "chain" combo/boxes in an Access 2007 form, so that the result of the first affected the contents of the second? I already know how to associate a combo box on a form ...
1
vote
2answers
623 views

Microsoft Office has stopped working

Every time I try to run MS Word,Excel, PP, OneNote (2007), it crashes. I get: microsoft office has stopped working.. Safe mode also doesn't run. I have windows server 2008 (32bits) and MS ...
0
votes
1answer
2k views

VBE6.dll not found when opening Access 2007 database in Access 2010

I have an access 2007 database that has some VBA code in it. I need to open this database in Access 2010, but when I first open it I get an error that says: the expression on open you entered as ...
0
votes
2answers
3k views

How can I publish MS Access project (forms and all) to the web?

I'm not sure if this is even possible with Access 2007 (or 2010 Beta), but I would like information on ways to make a project with forms, macros and modules accessible via the Web. Any good links or ...
4
votes
3answers
12k views

What's the equivalent of Microsoft Access on the Mac?

I want to use a Microsoft Access 2007 database on my Mac. However, it appears that Office 2008 for Mac does not have an equivalent to Microsoft Access. I'm new the Mac so can anybody suggest a easy to ...