Converting Macros to Modules
Fri, 29 Feb 2008 08:58:01 -0800
I have a 2003 Access database (three actually) that are Macro intensive. I
recently read an article that said, "Code is cool, Macros are for Weenies".
Okay, I have become real good at macros, but totally suck at code. So I
want to convert some macros to modules and then use them instead of the
macro.
...
|
Dynamic array junk
Fri, 22 Feb 2008 17:02:32 -0800 (PST)
I'm working on a large Access database. Access XP SP3, Windows XP
SP2. I'm a little stumped; I've spent a day debugging this, and
although I now have a clear idea of how this is going wrong and why I
was getting invalid values, I've no idea what's going on under the
hood to make this go awry. If anyone has an ...
|
Catastrophic Error
Fri, 22 Feb 2008 07:55:00 -0800
Within an Access 2003 application I have a check box that alters a payment
amount for VAT according to the status of said check box. It does this by
accessing code in a utility module, containing generic code which is
re-usable in other applications.
Problem is that when I take the check box off, it acces ...
|
Retrieve Current Local UserName
Fri, 22 Feb 2008 09:07:47 -0000
Hi,
How would I retrieve the Name of the Local Logged on User from Vista and use
this in a text box Called "CurrentUser" within an Access 2007 form?
Regards
John
...
|
Calling a custom DLL function
Mon, 18 Feb 2008 09:47:36 -0000
A distributed application uses the MapiSendMail function in Outlook Express
and references the dll with the folllowing Declaration Statement:
Declare Function MAPISendMail _
Lib "C:\Program Files\Outlook Express\msoe.dll" .........
etc, etc
Can this be re-written to cater for those cases where msoe.d ...
|
Combine Fields ( Need to Adjust Code )
Sun, 17 Feb 2008 19:42:02 -0800
Public Function getTradeMarks(varProdName As Variant) As String
Dim rs As DAO.Recordset
Dim intRecords As Integer
Dim strTradeMarks As String
Dim strSql As String
'strSql = "Select distinct [trademark] from tblTrademarks where
[productName] = " & varProdName
strSql = "Select distinct [trademar ...
|
Running Excel VBA in Access Sub
Mon, 18 Feb 2008 13:43:48 +1100
Hi there.
I'm trying to make this code work in an Access sub, it falls over in the
first line quoted. It works when run manually in excel of course.
For Each s In objActiveWksh.Range("B2", Range("B65536").End(xlUp))
If s.HasFormula = False Then
s.Value = s.Text
End If
Nex ...
|
|
|
Object Model for Lotus Notes
Fri, 15 Feb 2008 19:08:30 -0500
Using the Microsoft Object Model for Outlook, it's possible to have an
Access module directly read Outlook email and extract attachments.
Does anyone know of a similar object model for Lotus Notes. I have a
situation in which people will be emailing attachments that need to be
imported into an Access appli ...
|
How to avoid the ' at the start of each string when using TransferSpreadsheet?
Fri, 15 Feb 2008 13:44:24 +1100
Hi,
I create a spreadsheet using the TransferSpreadsheet method:
If RptType = ".xls" Then
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, RptQry,
BookName
etc
My problem is that I need to output a number as a 6 character text string
without the " ' " at the start of the string. I want a s ...
|
If file not exists, copy it
Thu, 14 Feb 2008 09:21:13 -0800
My form is based on tblmyLabel linked to C: drive cisCdrive.mdb. If file
does not exists, I copy from S: drive.
My code below gave error message: File not found c:\Program
Files\elac\cis\cisCdrive.mdb
What did I do wrong?
Private Sub Form_Open(CANCEL As Integer)
If Len(Dir("C:\Program Files\elac\ci ...
|
