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

Error Occurring Trying to Close Workbook Exported with Access VBA

I'm trying to write code to have Access close a spreadsheet in Excel that Access just exported. However, I keep throwing an error that tells me my table does not exist even though I'm STARING STRAIGHT AT IT! Very frustrating. All help is greatly…
ackdaddy
  • 131
  • 3
  • 5
  • 16
1
vote
2 answers

Show only last duplicates in access query

I have a database in access where I log maps which I loan out. So I have a table called MapsOut, with fields, MapNum(The map ID), MapName (Name of the Map), CheckOut (Date the Maps were loaned out), CheckIn (Date the Maps were returned). MapNum…
theWolf
  • 37
  • 2
  • 10
1
vote
2 answers

SQL query that choose all values when no input

I've write this query in an access 2007 database: SELECT Ordini.ID, Ordini.Data, Clienti.Cognome, Clienti.Nome, DettagliOrdine.IDProdotto, Prodotti.Descrizione, Prodotti.Prezzo, DettagliOrdine.Quantità, ([Prezzo]*[Quantità])…
Domenico
  • 292
  • 2
  • 10
  • 26
1
vote
2 answers

SQL working days query

I am trying to write a query to calculate the number of working days between 2 dates. I first tried this in VBA, which worked, but this is not very efficient. I have 2 queries, the first works out the date difference between a valueDate and…
sticks
  • 85
  • 1
  • 10
1
vote
5 answers

From SQL Server to MS Access 2007

Could you recommend a good resource on learning MS Access from the perspective of a developer with a good background in SQL Server. Also some best practice tips would be welcome, in areas such as multi-user access support security; both the…
kristof
  • 52,923
  • 24
  • 87
  • 110
1
vote
1 answer

-3087 error in Access 2007

I have the following code: SELECT Count(personnel.Position) AS countofposition, personnel.Position, Year(DateAdd("m",-6,[Personnel.End_Date])) & "-" & Year(DateAdd("m",6,[Personnel.End_Date])) FROM personnel GROUP BY…
user2954166
  • 23
  • 3
1
vote
1 answer

MS Access Order by X unless Y < 0 then order by Z

I've got a bit of an issue in Access whereby I need to order by one column containing time remaining (ORDER BY Round([Days].[DRem],2) but if the number falls below 0 , I need to order by a different column containing text. The current query is…
nixxrite
  • 133
  • 1
  • 1
  • 8
1
vote
2 answers

no read permission on 'MSysObjects'

I want to use MS Access in my project. I try to integrate with this code. rs = st.executeQuery("SELECT name FROM MSysObjects where database <> ''"); By using this I try to get all the table names from MSysObjects. But I get an…
user2990782
  • 873
  • 1
  • 7
  • 8
1
vote
1 answer

Get Most Recent Record

The question speaks for itself, for the most part. I have 2 fields in a table, Date and Value. By the most recent date, I would like to use the dollar value. I would like to get these values by means of VBA code. Is this possible with a DLookup or…
Mark C.
  • 6,332
  • 4
  • 35
  • 71
1
vote
1 answer

Convert SQL Server Query to MS Access

Here is my SQL Server Query that needs to be converted to MS Access - declare @StartDateTime datetime, @EndDateTime datetime set @StartDateTime = '8/17/2013 19:00:00' set @EndDateTime = '8/18/2013 23:00:00' WHILE @StartDateTime <>…
HappyLee
  • 435
  • 4
  • 11
1
vote
1 answer

De-Replicate an Access Database

I have an Access database that I need to reverse engineer into a website (app & data). I just tried opening it with Outlook 2013 but I get an error that the database has replication enabled and it created with an earlier version of Access (something…
Sean
  • 14,359
  • 13
  • 74
  • 124
1
vote
1 answer

13Type Mismatch Access 2007

I'm attempting to fix some botched up VBA from someone whom I inherited this Access database from. Aside from the hardly-useful notes left in VBA, there is no documentation, so I am trying to figure out what everything does, and if it is correct. I…
Mark C.
  • 6,332
  • 4
  • 35
  • 71
1
vote
1 answer

What is wrong with my run code using Inno-setup?

I have written code with Inno-Setup to install a 2007 desktop MSAccess split data base and am including Access Runtime 2007. I have tried several variations of "running" the "AccessRuntime.exe" with the database but still get errors. Here are some…
user2957565
  • 11
  • 1
  • 3
1
vote
1 answer

Import One Worksheet from Multiple Excel Files into Multiple Access tables

I have about 200 Excel files that I would like to import into a single Access database and have a table for each file. Each Excel file has multiple worksheets, but the one that I would like to import is consistently named. I have found some code for…
logicForPresident
  • 311
  • 6
  • 20
1
vote
1 answer

MS Access Multiple language support for forms only

Is there any way to apply another language to Access forms. I have an issue while creating forms, as the DB values are stored in English and I have to generate two identical forms from same Table in different languages. Everything goes well till I…
JRU
  • 327
  • 2
  • 9
  • 18
1 2 3
…
99 100