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
17
votes
2 answers

Comparing date in Access SQL query

I'm having trouble with Access sql query. Im new to this so bieng a rookie its difficult to figure out the syntax. below is my query. SELECT * FROM BookingMaster WHERE JourneyDate = #01/08/2012#; below is the respective table data: BookingID …
roshanK
  • 409
  • 4
  • 10
  • 19
16
votes
4 answers

How to find all queries related to table in MS Access

I have a database. In this i have hundreds of tables,macros and forms. No my problem is i have to find what all queries,macros that are related to specific table. I'm using microsoft acess 2000. But i even i tried objet dependencies in access 2007,…
shanmugamgsn
  • 820
  • 5
  • 16
  • 27
16
votes
5 answers

Preset the "save as type" field while using Application.FileDialog(msoFileDialogSaveAs) with MSAccess

I searched all over for a way to do this. I want to open a Save As dialog box so the user can choose the location to save a file. But, I want the "Save as type" field to be preset with "comma seperated value File (*.csv)" The problem is the "Filter"…
pec
  • 614
  • 3
  • 12
  • 28
16
votes
5 answers

C# Inserting Data from a form into an access Database

I started learning about C# and have become stuck with inserting information from textboxes into an Access database when a click button is used. The problem I get is during the adding process. The code executes the Try... Catch part and then returns…
Kentao
  • 197
  • 1
  • 1
  • 11
16
votes
3 answers

How to show row number in Access query like ROW_NUMBER in SQL

I have a table in Microsoft Access, and I want to show row number in a column using a select query in Access just like using ROW_NUMBER() function in SQL Server. In SQL Server, I can using this query: SELECT ROW_NUMBER() OVER (ORDER BY…
Fauzi88
  • 713
  • 3
  • 11
  • 23
16
votes
5 answers

"Return without GoSub" when using subforms in Access

Why do I get a "Return without GoSub" error when using subforms in Access 2007?
Sinister Beard
  • 3,570
  • 12
  • 59
  • 95
15
votes
3 answers

cycling through values in a MS Access list box

I have a list box that populates with different sets of data based on user selections. How can I cycle through any given values that may be in the list box? Is this a For Each statement, or what?
Justin
  • 4,461
  • 22
  • 87
  • 152
14
votes
6 answers

Use SELECT inside an UPDATE query

How can I UPDATE a field of a table with the result of a SELECT query in Microsoft Access 2007. Here's the Select Query: SELECT Min(TAX.Tax_Code) AS MinOfTax_Code FROM TAX, FUNCTIONS WHERE (((FUNCTIONS.Func_Pure)<=[Tax_ToPrice]) AND…
mammadalius
  • 3,263
  • 6
  • 39
  • 47
14
votes
1 answer

Insert SQL command with Datetime in MS-Access

I am trying the following query in MS-Access 2007, but it fails on the time field. INSERT INTO LOG ( EMPLOYEECODE, STATUSID, LOCATIONID, TIME, DURATION, SHIFTID, LATECOMING, EARLYGOING, LOGDATE, STATIONID ) VALUES ( 1, 1, 0, '4/21/2009…
lesbegue's alter ego
  • 1,145
  • 2
  • 8
  • 9
14
votes
7 answers

How to disable access security notice "A Potential security concern has been identified"

i have a shared access application, i created an accde file for 32-bit machine, when user open the application he/she getting a security warning is there any way to disable this message from appearing to the users thank you
Noora No
  • 309
  • 1
  • 4
  • 10
14
votes
7 answers

The action or event has been blocked by Disabled Mode

I am using Microsoft Access 2007 to move and massage some data between two SQL Servers. Yesterday everything was working correctly, I was able to run queries, update data, and delete data. Today I opened up the Access database to finish my data…
mattruma
  • 16,589
  • 32
  • 107
  • 171
13
votes
6 answers

Select records based on what a field begins with?

I have a database with a table that has identifiers c1, c2, c3..etc.. Instead of writing a query that has a bunch of ORs in it, how can I modify the below query with something that will catch all the records that begin with a certain letter?…
dzilla
  • 782
  • 5
  • 13
  • 22
13
votes
3 answers

MS Access Link Table With VBA

How can I link a table from one MS Access Database (*.mdb or *.accdb) to another Access database in VBA? Basically I just was to use VBA to replicate what the External Data wizard does. I've googled this and I see many examples of how to update or…
Mark
  • 1,277
  • 3
  • 13
  • 27
12
votes
2 answers

How to define composite keys in MS Access?

I am new to MS Access. Could anybody tell me how to define a composite primary key in MS Access 2007.
Ahsan Iqbal
  • 1,422
  • 5
  • 20
  • 39
12
votes
4 answers

Can't resize Access 2007 Navigation Pane

I resized my A2007 Navigation Pane and somehow closed it up so tight (maybe 8 mm) that I can't resize it again (can't grab the right margin....) The pane is open and operates, I can type a search into the pane's search bar, and it works, including…
JimS-CLT
  • 665
  • 4
  • 13
  • 30
1
2
3
…
99 100