Version 12 of Microsoft Office Access software.

learn more… | top users | synonyms (1)

0
votes
1answer
15 views

Strange behavior with keyboard shortcuts on MS Access Form

This is an odd one. On a MS Access 2007 form, I am getting intermittent copy/paste keyboard shortcut problems. I will select text, hit Ctrl+C, and my text is replaced with a letter "c". I then try to ...
1
vote
0answers
32 views

MS Access 2007 in Wine: hyperlinks couldn't be opened

I need to set up a machine with Linux (Ubuntu or Mint) and install MS Access on it using wine (MS Office programs that I worked with before, Word and Excel, worked in wine just fine). But I'm facing ...
0
votes
0answers
21 views

MS Access - Updating a path in a .mdw

I have an Access 2007 DB (.mdb) which used to live on a networked machine in an office but the machine has since died and the .mdb file has been moved to a networked drive. To launch the DB's UI, I ...
1
vote
1answer
23 views

Access 2007 - Inherited another user's project. Why do some of his forms NOT show up in the navigation pane?

I inherited an Access 2007 frontend with a SQL Server 2XXX backend and need to make some basic changes to the interface. The problem is, some of the forms I need to edit are nowhere to be found in the ...
0
votes
0answers
15 views

Can not print numbers in Hindi in Access while can in word 2007

I am trying to print Access 2007 report where the numbers appears in Hindi on the screen but it prints in English (Arabic) while I can print Hindi numbers in Word
3
votes
1answer
357 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
178 views

Can data in the Access 2007 ACCDE file format be viewed outside of Access?

There is free software on-line that is capable of reading the data stored in Access MDB and MDE format. Is there software that is similarly capable of viewing data in non-password-protected Access ...
0
votes
1answer
69 views

Access 2007 - Auto Refresh Without VBA?

I have developed a system using Access 2007 and would like to know if it is possible to auto refresh the data within each element of the entire form after the selection changes. For example: I enter ...
0
votes
1answer
274 views

Access keeps asking to enter parameter value

I have the following query in Access: SELECT Death.AccountNumber, Count(*) AS NumberOfRecords FROM Death GROUP BY Death.AccountNumber HAVING (((Count(*))>1)); The field AccountNumber has ...
0
votes
0answers
36 views

Why does runtime version of Access 2007 app fail?

I have an Access 2007 DB that was migrated from Access 2003. It runs as expected in full Access. However, when executed from the Access 2007 run-time it fails with "The Microsoft Office Access ...
2
votes
1answer
958 views

Change the names of a field

I am looking for a way to change field names in Access. I am importing data through a macro, from text files. Which i then review through a crystal report. Now, sometimes, the report needs to read ...
0
votes
1answer
26 views

Access Options Window Link is hidden

I created a database and I chose there in the "Access Options" window to hide the navigation menu. As a result, my access database doesn't show up the "Create" tab anymore, or any other tabs but the ...
0
votes
1answer
2k views

How do I insert a row into the middle of a table?

I got two pieces of A4 paper in ms word i want insert 2 name in each part using Mail Merge wizard I create the following table in an Access database: but when i try to insert name in ...
1
vote
1answer
157 views

Access 2007 list all the Sunday and Saturday in a year?

Is there any way to list all the Sunday and Saturday for a given year (2013 for example) in Access ? I tried to search and see that VBA might do the trick. What I want is that I have a Form that ask ...
1
vote
1answer
88 views

Exporting Data into a form type format from Microsoft Access query to Microsoft Excel Worksheet

Thanks for any help you can provide. I would prefer not to use VBA if possible, but will if necessary. I have MS Office 2007. I have a query which holds information for products that need user ...
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 ...
0
votes
1answer
3k views

Access 2007 wont open in 2013 just gives errors saying not compatible

This is my first attempt at a big access project so please be gentle :) I have created a database in Access 2007 on my works PC and it is a .accdb format files. I tried to open it in Access 2013 on ...
0
votes
1answer
288 views

Can Access display a related field on a data entry form?

Let's say I'm building an Access database to hold recipes and calculate the cost of those recipes. I need a table of recipes, a table of possible ingredients, and a table of recipe line items. Each ...
0
votes
1answer
140 views

Where is missing searchbar left-hand panel in MS Access 2007?

I recently opened a reporting database in Access 2007 that appears to be missing a search bar in the database objects panel. I'm familiar with MS Access, but not the new ribbon functionality. How do ...
0
votes
1answer
411 views

Excel 2007 table gets data from Access 2007 Table or Query

I have a table in an Excel file which has a connection to an Access Query. When I first create the table in Excel, the data comes in with exactly the same order as how I set up the Access query. ...
0
votes
1answer
2k views

Automating Access 2007 Queries (changing one criteria)

So, I have 6 queries and I want to run them all once at the end of each month. (I know a bit about SQL but they're simply built using Access's design view). So, in the next few days, perhaps I'll ...
1
vote
3answers
564 views

Compare Spreadsheet to Database to Generate Document

I am trying to streamline the production of a document that has to be created on a regular basis. There are tasks associated with detailed instructions on how to complete them, and each of these has ...
0
votes
1answer
58 views

Adding logic to a sub form in Access?

I have a sub form in Access: The CopyNo is a combobox that lets me select from the MovieCopies table. When I select one, I want the Title field to show the correct movie title associated to that ...
0
votes
1answer
873 views

Form no longer updates table; what'd I do?

I've been working on an "Enter Scores" type of form for a database that's used in a competition. What should happen is - I pick a team from a combobox, enter their score in a text box, then upon the ...
0
votes
0answers
693 views

Acess 2007 System.mdw Error

I'm having a issue with Access 2007. I'm currently running it on a HP Windows 7 machine, and I continue to get this error message when I try to create or open a new database, even a template. Access ...
0
votes
1answer
237 views

Prompt to select excel spreadsheets in Access?

I have a Microsoft Access 2007 database that uses excel spreadsheets to track changes between the two. A new file is generated every week. I then do a compare against the two of them with some custom ...
1
vote
2answers
2k views

Access 2007 - Lock users out of form design mode

Is there a way to lock users out of being able to view and edit a form in design mode in Access 2007?
1
vote
0answers
184 views

How can I split an Access report into equal parts?

I have an access report based on a query that contains around 160 records. This number varies over time. I would like to be able to split this into 36 equal(ish) parts which will be emailed to various ...
0
votes
0answers
27 views

Open a second form linked to the first form [duplicate]

Possible Duplicate: Link new record to existing form Could someone please tell me how to link a form? I enter data on a form, click save, then click a button that opens form2 which is ...
0
votes
1answer
997 views

How can I format a text field in Microsoft Access Report Designer?

I have a field (a string) that looks like this: '0000000840509001' when printed on my report. I want it to look like this: '84-05-090.01'. Is there any way to do this at the report design level? ...
1
vote
2answers
4k views

MS Access 2007, find and replace character with new line

In Access 2007 how do I replace a character (say "~") with a new line. I have tried using the Replace box with ALT+010 but it is not accepted as new line. Any suggetsions?
0
votes
1answer
3k views

How to send an HTML Email using Microsoft Access 2007

I want to create a Access 2007 form / report which will send a HTML mail. There will be a "button". When someone click on that button then an Outlook 2007's "New Email" window will be opened with a ...
1
vote
2answers
3k views

Access 2007 create report from query

Where is my Query??? I'm using Access 2007, until this version I would create a query then create a report based in that query, using create-blank report. If I use the report wizard it does give me ...
1
vote
1answer
622 views

Visio 2007 - Reverse engineer access database fails

I'm trying to document a number of Access databases using Visio 2007. The process I'm following is create an ODBC connection for the database, pointing to the appropriate file (all files are on my ...
1
vote
0answers
282 views

Access 2007 crashes when started in Win 7 pro standard user

I have Windows 7 Professional 64-bit on a Dell desktop with Office 2007 Professional installed. Whenever I open a file in Access as a standard user, it crashes after about a minute of activity, but ...
0
votes
1answer
605 views

How can I compare data from an Excel file with an Access 2003 database?

I'm wondering if there is a way compare data from an Excel file with an Access 2003 database? I have a list of contacts in an Excel File and also within Access 2003. I would like to know if any of ...
1
vote
1answer
2k views

Using a PivotTable to Count Items in Access

I have a list of text entries and I want to count how often each entry appears in the list. e.g. Berlin Paris London London Paris Paris Paris The result would be Berlin 1 Paris 4 London 2 This ...
0
votes
1answer
685 views

Import Paradox db to excel 2007

I have Paradox database (its a file ) which i like to import into excel 2007 but i dont know how. After doing some research i found that i can do this in Ms access when i try to import the database in ...
0
votes
1answer
325 views

.lnk doesn't open, no errors

I have a shortcut (.LNK) on my desktop to a MS Access database out on a network drive. When I double click that shortcut I get an hour glass for about 10 seconds and then nothing. No errors, no ...
0
votes
1answer
118 views

How to implement repeating questions in Access 2007 forms?

I want to repeat questions in a fillable form containing: Name, Address Name, Address Name, Address ... Access says I can't repeat entries. I am trying to make a list of persons.
0
votes
0answers
434 views

MS ACCESS 2007 ERROR: #NAME?

That error is shown in a Date field (month name) and year in a report. It could be because Windows is in spanish and Office in english?
0
votes
1answer
29 views

How to display more items in access 2007

I have this template "Customer Database Support" downloaded from the MS website, and i would like to know if you can select more items in one box instead of only one. For example, there is a table ...
0
votes
1answer
275 views

is it possible to integrate word to access 2007

Hi guys I'm wondering if it's possible to integrate word 2007 to access 2007. I downloaded this template "Customer Service Support" from the Microsoft site and one table of this database represent ...
0
votes
1answer
3k views

How to create a multi-table input form in Microsoft Access?

Is it possible to a make a form in Microsoft Access where a you can create entries in 2 tables in the same page? Imagine there is a table with 3 fields: ObjectId ObjectName TypeId where TypeId ...
0
votes
1answer
287 views

Customer service access 2007 template

anybody is familiar with this? can you please help me understand where can I find the other tables, Cases_1 and Employees_1? If I click on the relationship I can see these tables but I can't see ...
3
votes
2answers
263 views

what's the difference between “Resolved” and “Closed” access db 2007

Hi I would like to know what is the difference of the two: "Resolved" and "Closed" I have seen this in the template of ms access db 2007 Customer Database Support. And there is the status that ...
0
votes
1answer
527 views

Does anyone know what is this “Phrase Predict” in Access 2007?

Does anyone know what is this "Phrase Predict" in Access 2007?
0
votes
1answer
55 views

how to open a database access 2007

I would like to know how to open a database access. To see the form. I'm sorry I forgot it. I can remember it is something like you have to press the CTRL or ALT or SHIFT together but not really sure ...
1
vote
0answers
58 views

Update Billing Email Addresses in Sage MAS90

I have been tasked with trying to find a method of updating about 500 customer email addresses in MAS90. I recently discovered that they had the ability to email invoices to their customers and ...
0
votes
1answer
791 views

How to disable Access 2007 Exclusivity Mode

Does anyone know how to do this? I get the message that I can't lock the database. The network database won't open!