Stack Overflow
Stack Overflow

Questions tagged [ms-access-2007]

Microsoft Access 2007 - a rapid database application development tool

Microsoft Access 2007, also known as Microsoft Office Access 2007, is a rapid application database development tool.

Microsoft Office Access 2007 reached its end of extended support on October 10, 2017

It commonly uses the Jet or ACE database engine, but is not limited to these.

It is a member of the suite of applications, included in the Professional and higher editions or sold separately. Applications built with Microsoft Access can be distributed to end users with a free runtime version of the application that lets them view databases without needing the full installation of Access.

Please tag your question so others know what version you are using. Tag your question with if your question involves VBA.

Links:

4371 questions
12
votes
5 answers

Record cannot be read; no read permission on 'MSysObjects'

I'm trying to get a list of all tables from an Access 2007 ACCDB format database using Excel VBA. I have followed this post: How can I get table names from an MS Access Database? Using: SELECT MSysObjects.Name AS table_name FROM MSysObjects WHERE …
VBGKM
  • 121
  • 1
  • 1
  • 4
12
votes
2 answers

Access VBA find the last occurrent of a string?

Access VBA has Instr to return the position of the first occurrence of a string in another string. Instr ( [start], string_being_searched, string2, [compare] ) Is there any method to return the position of the last occurrence of a string in…
Nexus
  • 811
  • 3
  • 9
  • 20
12
votes
3 answers

default value for switch in access 2007

I am using switch statement in access 2007, i want to know how I can specify default value select switch ( MyCol = 1, 'Value is One', MyCol = 2, 'Value is Two' ) from MyTable Thanks
Mandeep Singh
  • 2,016
  • 7
  • 19
  • 32
11
votes
1 answer

Getting Combobox.Value in Access VBA

I have this code: If Me.Combobox.Value = "My Text" Then As I want to test if "My Text" is the only value selected, however, the conditional is skipped. I have also tried Me.Combobox.Column(1) and Me.Combobox.Text I believe there is some simple…
hrezs
  • 782
  • 1
  • 8
  • 23
11
votes
4 answers

Query a table that has spaces in its name

I have a situation, I have a Access table named Gas Flow Rates that I want to add records. When I try to run my insert query for a similar table Common Station, I get the following error: "error hy000: syntax error, in query incomplete query…
LaDante Riley
  • 521
  • 4
  • 14
  • 26
11
votes
5 answers

Meaning of MsysObjects values -32758, -32757 and 3 (Microsoft Access)

I'm quering the table MsysObjects for making a list of the objects in my database: SELECT MsysObjects.Name, MsysObjects.Type FROM MsysObjects WHERE (((Left$([Name],1))<>'~') AND ((Left$([Name],4))<>'Msys')) ORDER BY MsysObjects.Name; I know the…
waanders
  • 8,907
  • 22
  • 70
  • 102
11
votes
2 answers

How to loop through all controls in a form, including controls in a subform - Access 2007

As the title of my question suggest, how is it possible to loop through all the controls in a form, including subforms. For example I use the below sub routine to set the background colour of controls with the tag * Public Sub colCtrlReq(frm As…
noelmcg
  • 1,057
  • 3
  • 21
  • 44
11
votes
3 answers

How do I correctly use "Not Equal" in MS Access?

Objective: The intent of this query is to select all of the distinct values in one column that don't exist in a similar column in a different table. Current Query: SELECT DISTINCT Table1.Column1 FROM Table2, Table1 WHERE Table1.Column1 <>…
Bryan
  • 1,851
  • 11
  • 33
  • 56
11
votes
2 answers

linked table read only

I have an access 2003 (mdb) database on housing projects I update for our local planning office on a quarterly basis. Other folks in our office could benefit from seeing the same data. I thought the easiest way was to give them a separate access…
ako
  • 3,569
  • 4
  • 27
  • 38
11
votes
1 answer

Differences between DAO.Recordset,DAO.Recordsets,DAO.Recordset2

Can anybody explain the differences between DAO.Recordset, DAO.Recordsets, and DAO.Recordset2 in MS Access 2007? Basically recordset is used....Give an example so that its more clear. I found some references from Help Option but I am not clear with…
user2230817
11
votes
2 answers

Ms access select data greater than datetime range

How to select Data in ms access above this datetime range like select * from logevents where logTime>='12/6/2012 3:54:15 PM' logTime is Datetime field
Spen D
  • 4,225
  • 9
  • 39
  • 47
11
votes
1 answer

Is it possible to use subquery in join condition in Access?

In postgresql I can use subquery in join condition SELECT * FROM table1 LEFT JOIN table2 ON table1.id1 = (SELECT id2 FROM table2 LIMIT 1); But when I try to use it in Access SELECT * FROM table1 LEFT JOIN table2 ON table1.id1 = (SELECT…
Nelson Tatius
  • 7,693
  • 8
  • 47
  • 70
10
votes
5 answers

SQL Query Syntax Error - Spaces in Field Names

The database my application uses has field names containing spaces. I believe this to be the cause of my problem. Here is a typical query: SELECT * FROM 'OV2 BAS' AS bas INNER JOIN 'OV2 RefID' AS ids ON 'bas.Ref ID' = 'ids.Ref ID' WHERE…
Jim Fell
  • 13,750
  • 36
  • 127
  • 202
10
votes
1 answer

Update Table in Access

In MS-Access 2007, I have a table, [Test_Master] where I have a field [DT_REPORT]. I want to update [Test_Norm_Due] by 2 months if field [Size] = "small". If the field "Size" = "Med." then by 3 months. I create below query but it is throwing Syntax…
Shakti
  • 103
  • 6
10
votes
3 answers

"join expression not supported" in Access

I am writing a SQL query with inner join as this select * from (table1 inner join table2 on table1.city = table2.code) inner join table3 on table3.col1 = 5 and table3.col2 = 'Hello' This giving me the error "Join expression not…
Mandeep Singh
  • 2,016
  • 7
  • 19
  • 32
1 2
3
…
99 100