Version 12 of Microsoft Office Access software.
Questions tagged [microsoft-access-2007]
67 questions
3
votes
5 answers
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?
Johan
- 163
2
votes
2 answers
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 too long.
Note that the quotation mark is part of…
John316
2
votes
2 answers
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..
Arnold
- 171
2
votes
0 answers
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] TEXT(50),
[NAME4_ID] TEXT(50),
[NAME5_ID]…
Inka
- 21
1
vote
1 answer
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 navigation pane, though some of them are in fact…
Ivan
- 165
0
votes
1 answer
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 country code to the 'customerID', giving something…
Gloria
- 1
0
votes
1 answer
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?
KevinDeus
- 317
0
votes
2 answers
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,word insert same name(ex:Jeson Park) in two part
but i…
AminM
- 510
0
votes
1 answer
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 form's close, a separate table should have a…
Mike P
- 3
0
votes
1 answer
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.
Gerry
- 1
0
votes
1 answer
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 that on the Main Page?
are they some kind of being…
tintincutes
- 1,237
0
votes
1 answer
Does anyone know what is this "Phrase Predict" in Access 2007?
Does anyone know what is this "Phrase Predict" in Access 2007?
tintincutes
- 1,237
0
votes
1 answer
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?
Kath
0
votes
1 answer
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 fields, but how?
Christopher Bottoms
- 1,763