Questions tagged [microsoft-access-2007]

Version 12 of Microsoft Office Access software.

Filter by
Sorted by
Tagged with
0
votes
0answers
36 views

Converting from .accdb to .mdb

I want to use mdb viewer plus to convert a .accdb 2007 to a .mdb of 2003 but i'm getting this error : https://i.stack.imgur.com/91Un4.png i'm on a work network and can't download much so i'm stuck ...
0
votes
1answer
13 views

Access 2007 Exports to Excel open in old version of Excel but I want them to open in 365

My company has a database built in Access 2007. We use Office 365, but still have the old version of Access for this database. When we export from the Access database to an Excel spreadsheet, it ...
1
vote
1answer
55 views

Is it possible to create a “self-relationship” in one table?

I use MS Access 2007 and I want to create a relationship from a foreign key of a table to the primary key of itself. I was wondering if this relationship can be created at the "Relationships" window ...
0
votes
1answer
27 views

How to replace hidden elements in access?

I work with MS-Access database with a lot of tables, qureys and reports. It is easy to hidden some elements (by right mouse click then hidden options), but I do not fin the option to replace those ...
0
votes
0answers
176 views

Custom paper size not being applied for Access report

I have a Microsoft Access 2007 report that uses a custom paper size so I can print to a label printer. When I run this report on another workstation, it chooses an incompatible paper size and prints ...
2
votes
0answers
33 views

DDL in Access - AUTOINCREMENT - may I use sql instead of number in argument?

I have a query in Access: CREATE TABLE [t_Clusters_PassportsMicrofilm(fromDuplication)] ( [CLUSTER_ID] AUTOINCREMENT (92561,1), [NAME1_ID] TEXT(50), [NAME2_ID] TEXT(50), [NAME3_ID] ...
0
votes
1answer
29 views

how do i add a value to autonumber in access?

i was given a task to create a customers table with the 'customerID' starting from 100 and increment by 1. in the table is a field called 'nationality', is there a way to auto add the customer's ...
0
votes
1answer
922 views

Combining fields in one table into one field in another table in Access

I am trying to combine multiple fields from one table that has user id and 10 columns of data arranged horizontally to be displayed in two fields vertically having one field corresponding to the User ...
2
votes
0answers
615 views

How to return results of SQL query to Excel sheet with VBA function [duplicate]

I'm trying to create a VBA function in Excel to affect dynamic value from Access to Excel sheet. This is my code. Public Function SQL(DB As String, Query As String) Dim conn As ADODB.Connection ...
0
votes
1answer
1k views

Opening an access 2007 database in access 2013

I have a database in ms-access 2007. Now my new system has been installed with office 2013. So, When I tried to open the access 2007 database in 2013, all the features like HOME, CREATE, EXTERNAL DATA,...
0
votes
1answer
170 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
335 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 ...
1
vote
1answer
43 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 ...
3
votes
1answer
4k 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
2k 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
568 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 ...
1
vote
2answers
12k 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 ...
2
votes
1answer
5k 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
75 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
2answers
26k 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 Parts,...
1
vote
1answer
1k 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
164 views

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

I have a query which holds information for products that need user input for one attribute. The users are not comfortable with Access so the data needs to appear in Excel for them. Each month, I ...
0
votes
2answers
10k 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
2k 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
764 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. ...
1
vote
1answer
4k 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
1k 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
121 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 copy'...
0
votes
1answer
9k 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
2k 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
701 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
5k 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
458 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
31 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 linked ...
0
votes
1answer
2k 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
15k 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
4k 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
7k 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
935 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
394 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
2k 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
6k 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
2k 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
433 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
171 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
667 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
41 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
312 views

is it possible to integrate word to access 2007

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 "Knowledge ...
1
vote
1answer
9k 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 is ...
0
votes
1answer
309 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 ...