The access-2007 tag has no wiki summary.
0
votes
1answer
22 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
57 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
44 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
20 views
Open a second form linked to the first form [closed]
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
134 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
314 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
703 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
1answer
173 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 ...
0
votes
0answers
49 views
Problem with Dates in Excel 2003 from Access 2007
The user gets the front end of Access 2007 from an outside entity. We have no ability to put code in it to export/create a spreadsheet. She exports data to an Excel 2003 format, which includes dates. ...
1
vote
1answer
119 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
87 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
0answers
38 views
0
votes
1answer
171 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 ...
0
votes
1answer
329 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
182 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
146 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 ...
-1
votes
1answer
194 views
Microsoft Access 2007 role management
I need to create MS Access 2007 sales management database with ability to restrict some actions to some users. Can it be achieved?
0
votes
1answer
64 views
Repeating questions in Access 2007 forms
Access 2007. I want to repeat questions in a fillable form. 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
173 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
24 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
111 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
493 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
159 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
111 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
134 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
39 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
36 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
238 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
299 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
252 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
345 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 ...
2
votes
1answer
131 views
Access 2007 problem
I can't open .mdb files or create new one. Every time I try to open a new or existing file I get a password login prompt and my host login from Windows doesn't work.. how can I reset my Access :(!!
1
vote
1answer
295 views
Meaning of asterisk following table name in MS Access 2007
In MS Access 2007, what does the asterisk indicate when it appears next to a table name in the Navigation Pane?
0
votes
1answer
57 views
How do you name a field with a reserved keyword in Access 2007?
I'm sure you will say this is bad, but sometimes it is necessary. In Sql Server, you just put [brackets] around the field name.
Is it possible to do this in Access?
2
votes
2answers
942 views
How can I delete linked tables in Access 2007?
I can't delete links to linked tables in Access 2007. I receive the following error:
" is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not ...
0
votes
1answer
4k views
ms access 2007 link table manager
I'm new to Access 2007, and would like to know what this "Link table manager" does which can be found under database tools?
I'm migrating Access 2003 to Access 2007 and found out last time that if I ...
0
votes
1answer
515 views
merge multiple fields into one and keep data
ok, tricky one:
i need to merge one field in an access 2007 database and merge it into one filed in a query. hard part: i need to keep the data that goes with the new records.
example:
col1 |col2 ...
2
votes
4answers
365 views
Is it possible to disable ctrl + a in Access 2007?
I want to disable the command ctrl + a (select all) in Access 2007. Is that possible?
2
votes
1answer
418 views
ms access 2007 error messages
Good Day to Everyone!!
Just wanna ask if there is a setting in MS Access 2007 to ignore all error messages, when i ran my application in MS Access 07 there are annoying messages that pop-ups. All I ...
1
vote
1answer
181 views
Microsoft access 2007 filter
Is there a setting in Microsoft Access 2007 to disable toggle filter button permanently? Everytime I load a form the filter button is toggled automatically..
1
vote
3answers
182 views
Is there a way to restrict direct write access to the database in Microsoft Access 2007?
I'd like to set up an Access (2007) project that contains queries on a database (actually in MS SQL Server 2005), but I don't want to allow any direct writing to the database.
How can I make it ...
0
votes
5answers
12k views
Why can't I open my Access application in design mode?
I have been given an Access 2007 application (mainly VB code) that I need to modify. It has been locked down for production, so the toolbars and so forth are not visible. However, it is a .mdb file, ...
