Version 12 of Microsoft Office Access software.

learn more… | top users | synonyms (1)

0
votes
1answer
14 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
9 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
72 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
70 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
31 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
197 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
34 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
554 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
25 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
1k 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
130 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
74 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
33 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
2k 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
139 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
114 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
315 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
1k 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
472 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
55 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
516 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
629 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
192 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
1k 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
170 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
26 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
932 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
3k 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
2k 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
565 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
261 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
516 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
632 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
304 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
401 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
272 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
2k 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
283 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
243 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
490 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
54 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
699 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!
1
vote
3answers
586 views

Access 2007: How can I make this EXPRESSION less complex?

Access is telling me that my new expression is to complex. It used to work when we had 10 service levels, but now we have 19! Great! My expression is checking the COST of our services in the ...
0
votes
1answer
397 views

Combining 3 columns into one in a access query

I have inserted a column into design view of my query. How do I combine three separate columns into one. I need to get the City, State and Zip into my new column?
0
votes
1answer
844 views

How do I make a Memo field sortable?

I have a table with two memo fields. Neither of which I can sort on. The sorting options on the menu is grayed out when I right-click on the column. I have read that it is possible to sort on memo ...