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

How to split MS Access form into multiple pages?

I am new to MS Access and I'd like to split a lengthy form into multiple pages. It'd be better if I can use 'next' and 'previous' buttons to navigate within the same form through multiple pages. I'm using MS Office 2010.
JRU
  • 327
  • 2
  • 9
  • 18
1
vote
2 answers

Dynamic WHERE clause in MS Access

I am trying to get the following result in a query. SELECT * FROM rosterTbl WHERE (IIF( ISNULL([Forms]![ReportsGUI]![cmbCounsellor]), rosterTbl.CounsellorID<>null,rosterTbl.CounsellorID=[Forms]![ReportsGUI]![cmbCounsellor] I know the above query is…
Umair Ansari
  • 418
  • 3
  • 15
1
vote
1 answer

Access VBA outputto pdf "output to" prompt

I am getting a weird problem in Access 2007 SP3. When I export a report to pdf I get the "Output To" prompt which I don't want, is there anything in my code I am doing wrong? OverViewFile = DLookup("ExportPath", "dbo_Defaults") & "PC" &…
user2294977
  • 111
  • 1
  • 3
  • 10
1
vote
1 answer

custom Function in Access is returning #Error within a query

I'm joining two tables together. I want to pick one column when their is no data in the other column. One of the feilds is "SumOfHourlykWh" from qdRevenueConsolidatedByHE and the other is "SumOfAverage" from adSCADAConsolidatedByHE. The function in…
James Crosbie
  • 13
  • 2
  • 8
1
vote
1 answer

SELECT FROM a subquery table consisting of a TRANSFORM ... PIVOT table

I have the following functioning query to create a crosstab/pivot table in Access TRANSFORM Sum(y.TNAV) AS TNAV SELECT y.RecDate FROM BNYDaily AS y WHERE (((y.AccName) In ("A","B")) AND y.RecDate >= DateValue("1/1/2013")) GROUP BY y.RecDate PIVOT…
dedalus_rex
  • 459
  • 1
  • 7
  • 16
1
vote
1 answer

Query to compute the difference between a SUM and previous SUM, GROUP BY discontinuous dates

I have the following query that gives the daily total value of a portfolio. SELECT RecDate, Sum(Mval) as TotalVal FROM DailyVal WHERE RecDate >= DateValue("1/1/2013") GROUP BY RecDate; It works great and gives result as the following: RecDate…
dedalus_rex
  • 459
  • 1
  • 7
  • 16
1
vote
1 answer

Emailing multiple query results using VBA Access 2007

Hello everyone I am new to programming in VBA and have been at it for a week. I am trying to learn to write my own code but I have come up with a issue. My end result is that I send one email to all my vendors with their names in the BCC field. My…
user2903155
  • 11
  • 2
1
vote
3 answers

SQL Access Select NOT IN from two tables

Hello i am quite new to using SQL statements and my SQL statement does not return the proper result. I have two tables Room (contains Room details) and Booking(contains ID of Room booked). The RoomID of Booking should be retrieved which is NOT IN…
Ishildur Baggins
  • 147
  • 1
  • 2
  • 10
1
vote
1 answer

Microsoft access DoCmd.GoToRecord

I'be been given a MA DB and I had to connect that to a MySQL server using ODBC. That was fine. Then I added a subform in the main form that shows all the "attachfiles" related to the main form. That looks fine too. I even created a button to add a…
Cesc
  • 648
  • 1
  • 11
  • 22
1
vote
2 answers

How to make VB.NET application work as Multi-user?

I am developing a VB.Net application. That application might be working on a LAN. MS Access as a back end will be used. I have developed many single user applications, but don't know of multi user , LAN, manage DB etc. How do I make the program as…
Rahul Sharma
  • 63
  • 3
  • 13
1
vote
1 answer

Ajax call not being returned

The issue is that either the PHP file isn't sending the data back or the JS file isn't catching the data. The exact issue is that the data isn't display on the index.php page inside the
. I included code in the getDetails.php file to record…
user1621308
  • 172
  • 3
  • 15
1
vote
1 answer

update field to null value when there is no match in related table(s)

I have 2 tables as shown below. I need to update the [incomming letter contractor] field of table [ASBUILT_LIST] with value of [TRANSMITTAL] of table [tblTransmittalls] I have used the following update query UPDATE ASBUILT_LIST INNER JOIN…
masoud
  • 855
  • 4
  • 12
  • 34
1
vote
1 answer

How to Make a List Box a Drop-Down Like a Combo Box in Access

in access 2007 How to Make a List Box a Drop-Down Like a Combo Box without changing it to combo box type because it has multi select property and i need to save some space on my form is that possible ??
user1921704
  • 179
  • 3
  • 4
  • 15
1
vote
1 answer

how to update text field using listbox

i have access 2007 and i want to update a text field [eng] using a list box [List191] which contains 3 values value1,value2,value3 i want when i click on this list and select one or two values i get this values as text separated with (,) in that…
user1921704
  • 179
  • 3
  • 4
  • 15
1
vote
1 answer

Pivot on multiple fields and export from Access

I have built an access application for a manufacturing plant and have provided them with a report that lists different data points along a process. I have a way to generate a report that looks like the following. Batch Zone Value1 Value…
riley3131
  • 288
  • 3
  • 21
1 2 3
…
99
100