Super User
Super User

Questions tagged [microsoft-access-2007]

Version 12 of Microsoft Office Access software.

65 questions
5
votes
4 answers

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, not .mde, so in theory it should be possible to…
mmyers
  • 463
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
3
votes
1 answer

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 20130825 -54.82018 -68.33854 20130827 …
Alex Tereshenkov
  • 237
3
votes
2 answers

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

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 says, "active", "resolve" or "closed". Does anybody know…
tintincutes
  • 1,267
2
votes
0 answers

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

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 Set conn = New ADODB.Connection conn.Open…
Kea
  • 21
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
1 answer

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 want is to ignore all those message without…
Arnold
  • 171
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
1 answer

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 the field which I imported at field 7 instead of…
PsychoData
  • 1,447
2
votes
1 answer

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 :(!!
Markus
  • 505
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
0 answers

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 unexpected problems: user can't follow the http://…
Dmitry Frank
  • 1,134
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
  • 175
1
vote
1 answer

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 2007 ACCDE format? Note that my question relates to…
authentictech
  • 275
1
vote
3 answers

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 previously been [Acc Number] but this has been updated in…
Aaa
  • 266
1
2 3 4 5