|
Sidestepping the Security Warning Dialog Box in Access/Outlook 2003
All,
As a kind of introduction to my problem......
I got the following lines of text from the Microsoft "What's New in
Microsoft Office Outlook 2003 for Developers?" website.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_ol2003_ta/html/odc_OLWhatsNew2k3.asp
A Practical Security Example
In order for your calls to blocked object model properties and meth...
|
4 |
25.08.2006 17:03:41 |
|
|
Open Application
Hello All,
How do I programatically tell if another application is open from Access?
Any help or pointers would be apreciated.
Brian...
|
4 |
24.08.2006 16:14:02 |
|
|
Database Map
Anyone ever heard of a Database Map?
I need to create a "Database Map" for the custom database I just finished.
I don't even know where to begin! It's a little puzzling. I think the end
result should look like a flow-chart. But the map should also list all the
database objects, and how they are linked/joined with other objects (ie
queries).
Has anyone done anything like this be...
|
6 |
23.08.2006 12:52:12 |
|
|
Default File Name
I would like to write some code that will use the function found in:
File | Get External Data | Import ...
but I would like the first stage of the wizzard to point to a certain file
path on a server and also make the default file type to Excel.
I guess the first part of the code would like this:
DoCmd.DoMenuItem acFormBar, acFile, 2, acImport, acMenuVer70
The bit I am having diffi...
|
3 |
22.08.2006 12:46:02 |
|
|
How do I programmatically reference and manipulate the properties of "CurrentProject" from another database?
How do I programmatically reference and manipulate the properties of
"CurrentProject" from another database?
The below example references "CurrentProject" within the current database,
but I want to connect to another database and use the "CurrentProject"
feature of THAT database
I added line 3 "dim accApp As Access.Application", as I'm pretty sure this
line is neccessary, but the r...
|
2 |
20.08.2006 10:39:03 |
|
|
Field Description in code
Hi all;
If I'm adding a field through code, is there a way to give it a description
that will then show up in the status bar of forms that reference the field?
TIA;
Amy
...
|
3 |
18.08.2006 19:56:19 |
|
|
Capturing OnNoData error with ConvertReportToPDF
Hello All
I have lot of statements similar to the following:
rptname = "rpt monthly summary letter"
flname = mth & "-Payroll-Covering letter"
blret = ConvertReportToPDF(rptname, vbNullString, drname & flname &
".pdf", False)
Each statement uses a different report.
For each report I have the 'OnNoData' event set to Cancel = True, but I want
to prevent the error message fro...
|
3 |
18.08.2006 17:08:02 |
|
|
How to Reference an External Database
Access 2003. I would like to know how to do the following. By "external"
database I mean an Access database other than the one in which a module
resides.
1. How to set a database variable to an external database.
2. How to determine if an external database is open.
3. How to open an external database.
4. How to query an external database.
5. How to create a record in a table in a...
|
5 |
18.08.2006 15:53:25 |
|
|
Setting Default Value in Backend table.
I am trying to allow a user to change default values for a field in a backend
table. The following code produces no error but does not change the default
value in the backend table. Can what I want to do be done? Thanks for any
help.
strDeclarant = Me!DefaultDeclarant
DBName = CurrentProject.Path & "\Datadb.mdb"
Set wrkDefault = DBEngine.Workspaces(0)
Set dbsUpdate = wrkDefault.Open...
|
4 |
18.08.2006 11:58:33 |
|
|
Setting Default Value in Backend Table
I am trying to allow a user to change default values for a field in a
backend table. The following code runs without an error, but does not
set the default field value. I must be missing something. Thanks for any
help.
DBName = CurrentProject.Path & "\Datadb.mdb"
Set wrkDefault = DBEngine.Workspaces(0)
Set dbsUpdate = wrkDefault.OpenDatabase(DBName, True)
Set tdfUpdate = dbsUpdate.Tabl...
|
1 |
17.08.2006 18:10:59 |
|
|
Avoiding repeated conditions?
Hello All
I have inherited a db with a fairly complex module that I am trying to
simplify. Essentally there are a lot (35) of reports in the db that are
generated for a given [practice]. The reports are uploaded to a website and
then sent as emails, and/or printed and posted, to the Practice. The report
is generated for a [practice] if the value of a corresponding yes/no field
(there are 3...
|
7 |
17.08.2006 12:30:51 |
|
|
Renaming a file
What command/syntax do I use to programmatically rename a file?
I want to use:
Application.CompactRepair myDB_Name, myDB_Name2
.... and the delete (kill) the first file, and rename the second file
(myDB_Name2) to the name of the first file.
I cant find a "rename" or similiar command in the FileSystem list.
Please Help, Thanks.
Kan D.
...
|
4 |
17.08.2006 05:35:05 |
|
|
Where is the DateModified Property?
In Access 2003, when I programmatically refer to an objects "LastUpdated"
property, it returns the same value for "DateCreated".
THIS IS INCORRECT
And when I try this...
====
dim accObj as AccessObject
dim myDate as string
for each accObj in CurrentProject.AllForms
mydate = accObj.DateModified
next accObj
====
.... It returns the date I'm looking for.... The MODIFIED ...
|
3 |
16.08.2006 06:58:25 |
|
|
Description, Modified & Created Properties - show on a Report
Is there any way to show the "Description, Modified date & Created Date"
fields from the properties of a report on the header or footer of the Report?
I tried the following code, but I just noticed a strange anomoly. The field
"DateUpdated" in MSysObjects is not the same as the "Modified" date shown
under report objects. Also I can not find the 'Description' field.
The Datecreated is ...
|
6 |
15.08.2006 16:20:02 |
|
|
Multiple enabled error handlers?
I have a project that contains some code to relink tables based on the code
at Dev Ashish's site, which essentially works by looking in one of the
tables and relinking in response to the error that occurs if the back end is
not where it is expected. The database now must perform new functions not
originally specified, so I want to have my front end automatically add the
new tables & fie...
|
14 |
14.08.2006 23:57:43 |
|
|
Referencing Fields in a Recordset
Access 2003. I have a record set called rst. I want to be able to reference
fields in this recordset using a variable. For instance, I have a variable
call FNAM that might have the value of "GEN 1" or "GEN 2" (or a dozen other
values) which are field names in the record set. I would like to be able to
reference those fileds in the recordset based on the value of FNAM. I have
tried:
...
|
4 |
14.08.2006 21:17:02 |
|
|
ApplyFormFilter - Please Help!
Hello All,
The below code works, so why am I here??? Well, the Select Case
cboFieldName cause a repainting which I would prefer to avoid. I would like
it sort by whichever field you choose without the repaint, if that is at all
possible.
Thanks in advance,
Gina Whipp
Private Sub ApplyFormFilter(strFieldName As String)
Dim strFilter As String
Dim strDefaultFilter As String
Dim ...
|
5 |
11.08.2006 21:30:11 |
|
|
Numeric/Non Numeric values in a Module
Scenario: I am using the following module to be able to move all items
from one listbox to another , and vice versa.-
Sub MoveAllItems(strSourceControl As String, strTargetControl As String)
Dim strItems As String
Dim intColumnCount As String
Dim lngRowCount As Long
For lngRowCount = 0 To Me.Controls(strSourceControl).ListCount - 1
For intColumnCount = 0 To
...
|
2 |
11.08.2006 11:55:10 |
|
|
Access modules and Winzip
Hello all,
Are there any programming capabilities available for use in Access with
regard to Winzip or any other zipping type software.
For instance, is there a way to open a winzip file and extract the data
files to disk? Automation?
Can someone possibly point me to a link or give me a few tips?
Thanx for in advance.
Regards
Dale
...
|
6 |
11.08.2006 09:05:04 |
|
|
FileSystemObject files collection question
Access 2000
Hi All,
Can the following be relied on to loop through the files in any particular
order (I want it to loop in alphabetical order of the ucase(fl.name))
For Each fl In fs.GetFolder(strPath).Files
DoEvents
Next
Cheers
GPO
GPO...
|
2 |
11.08.2006 00:24:50 |
|
|
Terminating a DOS Window Programmatically
Access 2003. As part of a module I use the Shell command to run Kermit (and
old asynchronous communication/file transfer program). This Shell command
brings up a "DOS" window in which Kermit runs. How can I programmatically
terminate (close) this DOS window from VBA. I know when I am ready to
terminate the window as I monitor the files Kermit is creating. I just need
to be able to g...
|
2 |
10.08.2006 15:39:05 |
|
|
Help with SQL String Concatenation
I've been trying to concatenate together a string to insert data into an
access table. Below is what I have which does NOT work.
strSQL = "INSERT INTO EFiles (INCOMING_FILENAME, UNPACKED_NEW_FILENAME, WO,
TRANSFER, REP, CLIENT, IS)"
strSQL = strSQL & " VALUES ('" & .Item(iCtr).FileName & "'"
strSQL = strSQL & ",'" & ConcatenatedFilename & "'"
strSQL = strSQL & ",'" & oMessage.Subject & ...
|
3 |
10.08.2006 01:12:34 |
|
|
Can I Programmatically assign event and event content?
Can an event AND event content be assigned prorammatically to a control?
See below example's ".OnClick" line...
Dim c_imgStatus As Image
With c_imgStatus
.Name = "imgStatus" & i
.Picture = "\\path\path\Status Button.jpg"
.HyperlinkSubAddress = "Form FormName"
.OnClick = "MyVariable = " my_OtherVariable & Chr(13) & _
"msgBox MyVariable"
End With
So when I click...
|
2 |
09.08.2006 23:21:55 |
|
|
Using Windows Calculator Programmatically
I'm working on a project in which certain data is received in a decimal
format, however I need to convert it to hexdecimal. The numbers are
typically 13-15 characters in length, which is too large for the standard VB
Hex() function. The solution I've found so far is to send the number to a
shelled version of the Windows Calculator, convert it there, and bring it
back. Unfortuantely, a...
|
5 |
09.08.2006 20:40:22 |
|
|
Can an Event and Event content be assigned programmatically?
Can an event AND event content be assigned prorammatically to a control?
See below example's ".OnClick" line...
Dim c_imgStatus As Image
With c_imgStatus
.Name = "imgStatus" & i
.Picture = "\\path\path\Status Button.jpg"
.HyperlinkSubAddress = "Form FormName"
.OnClick = "MyVariable = " my_OtherVariable & Chr(13) & _
"msgBox MyVariable"
End With
So when I click...
|
2 |
09.08.2006 19:37:02 |