Try using http://groups.google.com/

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails, please!)

"Stewart Berman" wrote in message
news:n6i806lb44qc2t2qqu4s9ab3em5rlq5n3k@4ax.com...

I have an Access 2003 MDB front end that I need to keep up to date. When it
was a lot smaller it was not that big a deal to just put in the login script
a line to copy down the current rev every day, but now that it is bigger I
need a better way of keeping the file up to date and only copying the new
MDB down when the one on the network share is newer.

I know I can have the startup code check a CurrentRev variable in the MDB
vs. a value in the backend table and identify that a new rev is available to
be copied, but don't know if it is possible to have the MDB copy over
itself. Is this possible?

On Thu, 28 Jan 2010 10:49:08 -0500, "Sha S" live.com> wrote:

The reason I suggested the Registry is that it is mostly independent
of file location. What if I installed Windows on the D-drive, and
Program Files is also on the D-drive?

-Tom.
Microsoft Access MVP

This code Works for 2007

'***************************
Public Sub CompactExtClosedDB()
'***************************
Dim strDbNameOld As String
Dim strDBNameNew As String

strDbNameOld = "C:\Documents and Settings\rcri007\My
Documents\A_Pricing_Combine\CompactDB1.accdb"
strDBNameNew = "C:\Documents and Settings\rcri007\My
Documents\A_Pricing_Combine\Ross.accdb"

DBEngine.CompactDatabase strDbNameOld, strDBNameNew
Kill strDbNameOld
Name strDBNameNew As strDbNameOld

End Sub

"Douglas J. Steele" wrote:

Hi;

Using A2K Runtime on XP Pro PC. Have all of the updates for XP and Access
Runtime including SP-3 for both.

The app opens to frmLogin correctly. On that form there are 2 cmd buttons.
Continue & Exit.

Can log in as USER or sa, (System Administrator) but when clicking either
cmd button get Access Runtime Crash.

"Execution of this application has stopped due to a run-time error."
"The application can't continue and will be shut down."
Only has OK button.

The cmdExit OnClick Event is:
Private Sub cmdExit_Click()
DoCmd.Quit
End Sub

Don't understand why would get a run-time error on DoCmd.Quit.

The MDB does work correctly on the machine that created it. Even opening it
as the User in Runtime Version emulation.

Hello -

Could someone tell me if this is possible...

I have created an update for my front end. As part of the new deployment, I
need to create a new system DSN on the end user's machine. I have a macro
on a form that will create the DSN if the user doesn't have it, but I'd like
to have it created automatically, i.e. like in an Autoexec macro. But...I
don't want to run it everytime they launch it, only the first time.

Any help would be appreciated.

Jeff G

I have a Shell command in a VB Function, but everytime it is called, I get an
"error #5", "Invalid procedure call or argument".

I have tried:
Shell Filename$,1
RetVal = Shell(Filename$, 1)
Call Shell(FileName$, 1)

FileName$ is read from a form field when a button is pressed, and then a
Macro is called that then runCode the VB Function. FileName$ is a string
like "C:\users\Ted\File.txt" This appears to work because, as a test, I can
read the FileName$ string in a MsgBox just before the Shell function.

This Access 2003. This seems like a trival issue, but I can't seem to find
the problem.

Thanks
Ted

Hi All

Every time I use an Option Group I like to write some code to bold the
label of the selected Option in the group - I used to put this code in
the Event now I create a sub so that I can reuse the code within the
form. The problem is every time I use an Option Group I have to re-
write this code - I want to know if there is a way to do this better
- I am thinking of something like a class module or a function but I
am not sure where to begin

I was hoping to create something where I would be able to go
FontBold(OptionGroupSelectedNumber, Label1name, Label2name,
Label3name, Label4name) -

Any thoughts on how to get me started on this - or even if what I am
asking is doable?

Thanks in advance for your assistance with this

Jeff

My code that I am using currently looks something like this:

Hi all,

my task is to create a report as pdf that is automatically mailed
every day to several people.
So the following steps are necessary:

1) Create a scheduled task in the control panel that calls... --->
OK

2) a .bat file with a line like this: "C:\Program Files\Microsoft
Office\Office12\msaccess.exe" mydb.mdb /X SendDailyReport --->
OK

3) The macro SendDailyReport calls with the Action RunCode a Sub in a
form that is opened on startup ---> failed, because I am not so
familiar with VBA. How does the syntax look like to call a sub from a
specific form?

4) Running some queries and code. ---> partly failed
Problems with this code:
timeAndDay = timeTo + dayReport