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
1
vote
1 answer

crosstab query - dynamically derive column headings based on a related table

I tried: TRANSFORM First([FirstName] & " " & [LastName] & " - " & [Status]) AS Name SELECT qry_DateTemp.Date FROM Customers RIGHT JOIN qry_DateTemp ON Customers.CustomerID = qry_DateTemp.CustomerID GROUP BY qry_DateTemp.Date PIVOT…
Rahul Sharma
  • 63
  • 3
  • 13
1
vote
2 answers

MS Access: index optimisation

Let's say we have a [Valuations] table containing several values per date and per fund: -FundId -ValDate -Value1 -Value2... The Primary key is obviously FundId+ValDate. I have also indexed the ValDate field since I often query for values on a…
iDevlop
  • 24,841
  • 11
  • 90
  • 149
1
vote
1 answer

Checking multiple columns from a table against a column in another table

Table A Name, Address, ..., Item1, Item2, ..., Item10 Table B ProductID I want to run an SQL statement (in access) to Select all records where any item ([Item1] - [Item10]) that does not match a Product code found in [ProductID] in Table B. I am…
Chuck
  • 1,156
  • 2
  • 10
  • 19
1
vote
1 answer

In Access give the spacing alias in select query

SQL aliases are used to temporarily rename a table or a column heading. I want to give alias in select query but that not work ex: select ID,name_shop as **Shop Name**,contact_name as **Contact_Name**,contact_no as Contact_No,address as…
Hiren Raiyani
  • 754
  • 2
  • 12
  • 28
1
vote
1 answer

How to use Replicate in MS Access Database?

In Sql Server for replication i use the following query select replicate('0',5) it gives result as 00000 what is the equivalent for this in MS Access
Anjali
  • 1,680
  • 4
  • 26
  • 48
1
vote
1 answer

Microsoft Access running out of temp space (Error 3183)

I inherited this Frankenstein application at work that utilizes an Access 2007 DB frontend with linked tables to an Oracle 10g DB. Users have started reporting that a lot of the queries are failing with an error 3183 out of temporary space. These…
Steve Thorne
  • 11
  • 1
  • 1
  • 3
1
vote
1 answer

Query with 2 filters in Access

I'm doing work experience where I've created a database of past students in Microsoft Access 2007. I have problem with creating a query to filter students who have done Introduction Course but nothing else. I guess I need 2 filters. I have Two…
user2858791
  • 11
  • 2
1
vote
1 answer

Combining two columns in a select won't work

I need to combine values from 2 columns in a simple select statement using Access 2007 and ColdFusion 8. When I ran my query in Access I got the result without a problem, but when I put the query below in ColdFusion it won't run:
user1557856
  • 163
  • 2
  • 12
1
vote
1 answer

Best method to allow an event to work on a form

in VBA I have a subform which I use on many forms; however I have a bit of code where I only want this code to work on 'one form'; so if I have the subform with a textbox in form 1, form 2 and form 3, I want the after update event to only work for…
user2836518
1
vote
1 answer

insertion of records automatically in database using scheduler

how is it possible to insert records automatically in database when due date expired using timer ? i want insert records in MS Access database using VB.NET.... actually i want insertion of records of hostelers in due Charges table who did not paid…
Rahul Sharma
  • 63
  • 3
  • 13
1
vote
1 answer

ODBC Connectivity with java application

I am creating a login dextop application in JAVA. For DATABASE I am using MICROSOFT ACCESS 2007. So I need to use ODBC connectivity to use database in my application. Here are the steps I am following to make connection :- 1.Click Start, and then…
anjali
  • 77
  • 1
  • 9
1
vote
2 answers

Need to sort access report by date

I've got a report that I'm trying to sort but really have no idea how. I've tried a number of things but nothing is working. Here's my query: SELECT [FirstName] & " " & [LastName] AS Contributor, PledgeAmountRecd, tblPledgesLead.PhoneNumber,…
epilimic
  • 27
  • 7
1
vote
2 answers

Name column not matching in query

I have following table: w2001 Code Name 1 abc 2 xyz 3 pqr 7 OPW and a second table: w2011 Code Name 4 abc 2 xyz 5 pqr 6 MNS I would like the following result: Code2001 Code2011 Name 1 4 abc 2 …
C Sharper
  • 8,284
  • 26
  • 88
  • 151
1
vote
2 answers

How can I update any field value through VBA code in ms access?

How can I update any field value through VBA code in ms access? When I enter values in combobox, some of the fields in the relevant tables are updated as I enter the data. Whereas others do not. What should I do to solve this problem? In a combobox…
Rizwan Safdar
  • 125
  • 2
  • 2
  • 11
1
vote
3 answers

Filtering A Lookup Field Based On Another Field

I have a lookup field in my table based on another table. I'm having trouble filtering those values based on another field that is entered prior to the field. Is it possible to filter a lookup field based on another field? EDIT Let me try and…
Muhnamana
  • 1,014
  • 13
  • 34
  • 57
1 2 3
…
99
100