ms-access-2007 Questions
3
Solved
What declarations I have to make in order to be able to use Excel objects and constants from my Access 2007 VBA script?
Dim wb As Workbook
or
Set objExcelApp = New Excel.Application
or
.Borders(x...
Akmolinsk asked 20/4, 2011 at 10:59
1
Solved
I seem to be clueless on this subject. I can attach an ADO recordset to a form, but I am not sure how to handle updates. I don't want to only UpdateBatch, I want to be able to detect what was chang...
Abram asked 12/4, 2011 at 21:18
1
Solved
I'm using a technique similar to that in Remou's answer to this question to manipulate the propeties of the controls on a subform. Works great as long as the parent form's recordset has at least on...
Cohbert asked 16/2, 2011 at 23:52
1
Solved
How to get fieldnames or columnname of a table in msaccess using query?
Can someone help me to overcome this issue?
Like if i have table called "employee" i need to fetch the fieldn...
Yacov asked 4/2, 2011 at 4:32
2
Solved
There was a problem with DAO 3.6 in that it didn't support row-level locking. For details, see this Knowledge Base article.
I learned from the Access team's blog:
In Office Access 2007, new obj...
Terry asked 13/7, 2009 at 8:8
7
Solved
When creating a new database in Access 2007, should ADO (ActiveX Data Objects) or DAO (Data Access Objects) be used?
Edit: Part of this database will be importing data from Excel 2007 spreadsheets...
Multifaceted asked 24/6, 2009 at 15:48
1
Solved
I'm trying to call an event when the user returns focus to the Access application when a specific form is open. The following event doesn't seem to fire up at all.
Private Sub Form_GotFocus()
Cal...
Attlee asked 11/1, 2011 at 15:45
1
Solved
A database created with one of the new sort orders will not open in Access 2007 even with Service Pack 2 (SP2) installed.
Spectacle asked 3/1, 2011 at 12:14
4
Solved
I have a .NET application which uses an accdb file (MS Access 2007 format) as its database. To install this app on another machine I need to install the Access engine on that machine. Microsoft has...
Aril asked 18/12, 2008 at 15:51
2
Solved
Such a simple question, but I cannot find the answer (Google, MS help, SO):
How can I check by VBA whether an unbound checkbox on an Access form is checked by the user or not? Can't find the right ...
Tactician asked 28/9, 2010 at 14:25
2
Solved
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 cont...
That asked 27/7, 2010 at 14:28
3
Solved
I'm reading over this query, and I came upon a line where I don't understand heres the line
[FETT List]![FETT Search]
FETT List is a table
FETT Search is a column in FETT List
Can someone exp...
Nereus asked 18/5, 2010 at 17:24
3
Solved
Is it possible to create a directory folder for individual records in Access 2007. For example
tblUser
ID
firstName
surName
When adding a record, would create a folder C:\userdatabase\Surname,fi...
Kerin asked 6/4, 2010 at 16:19
2
Solved
I have 3 Tables: NotHeard,analyzed,analyzed2. In each of these tables I have two columns named UnitID and Address.
What I'm trying to do right now is to select all of the records for the columns U...
Vetiver asked 1/4, 2010 at 21:4
2
Solved
I don't even know if I am doing this query the right way.
There is a Sandwiches table that has some 7 fields and 2 of them are comboboxes (Type and Bread).
So I made a query that combines all of t...
Telecast asked 11/1, 2010 at 18:15
5
Solved
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
...
Tillery asked 5/1, 2010 at 16:53
8
Solved
Bear in mind here, I am not an Access guru. I am proficient with SQL Server and .Net framework. Here is my situation:
A very large MS Access 2007 application was built for my company by a contract...
Slicer asked 18/2, 2009 at 0:47
1
Solved
I need help navigating Microsoft Access Reports. I am in the Report Designer, and I need to know the which menu selection will enable me to view the Query that was used in the report.
I have never ...
Derwon asked 16/9, 2009 at 18:45
3
We're using MS Access 2007 as our DB and should support users with limited access (power users):
The DB should be common to all users (hence cannot be located on user's private folder)
We are not...
Andyane asked 12/7, 2009 at 5:44
5
Solved
I would like to send email from Microsoft Access unattended using VBA. I understand that the built-in method “SendObject” uses MAPI meaning security prompts and something like Outlook configured. S...
Cr asked 20/4, 2009 at 19:26
2
Solved
I have a spreadsheet that I am converting to an Access DB. I have a column of typed out customer names that I want to replace with the appropriate customer number from our accounting system.
I hav...
Efface asked 5/5, 2009 at 15:33
1
Solved
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,...
Corr asked 21/4, 2009 at 9:48
© 2022 - 2024 — McMap. All rights reserved.