Compact & Repair BE from FE? (Access 2007)
Tue, 4 Mar 2008 16:18:51 -0500
Is it possible to code a Compact and Repair Database to the linked (Backend)
tables from the Front-end?
I have a multiuser front-end but I keep track of sessions and know when the
database is idle. I have an Administrator switchboard and can close all
tables and run a compact & repair but I don't want to go ...
|
Use Pop-Up to find record on tab control
Sun, 2 Mar 2008 11:13:49 -0500
All,
I have searched, played with the code and still have no solution so I am
hoping someone has an answer. (Yep, I searched the newsgroups and still no
joy!) Here's my problem/issue.
I have a pop-up that opens from a form that has several tab pages. What I
want to happen is I open the main form, sele ...
|
Module open in single window
Sun, 2 Mar 2008 12:22:11 -0000
Hi there,
I haven't used VBA for a while and I can't figure out how to go into the
module window and show it in a single window rather than a seperate window
for each module when I click Alt F11.
Can some one please remind me.
I've been working in Delphi for a while and it is possible that I am
confus ...
|
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 ...
|
