473,378 Members | 1,383 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

SysCmd

Hi Folk

I have the following nifty little function that I can call to put messages
on the status bar. However, I don't know how to clear it and show the
normal messages (e.g. in a control on a form Statusbartxt)

Public Function SysMs(S As String)
On Error GoTo er
'-
Dim V As Variant
'-
S = S & " "
If S = " " Then
''clear all - this is what I do not know...
Else
V = SysCmd(acSysCmdSetStatus, S)
End If
xt:
Exit Function
er:
Resume xt
End Function

TIA

nicolaas
Nov 13 '05 #1
3 5857
Call SysCmd(acSysCmdRemoveMeter)

By the way, rather then using
V = SysCmd(acSysCmdSetStatus, S)

Try:

Call SysCmd(acSysCmdSetStatus, S)

If you're not going to do anything with the V variable, there's not a
good done in calling and using it. (No harm either, but.... What's
the point of having it?)

Nov 13 '05 #2
Br
Chuck Grimsby <c.*******@worldnet.att.net> wrote:
Call SysCmd(acSysCmdRemoveMeter)

By the way, rather then using
V = SysCmd(acSysCmdSetStatus, S)

Try:

Call SysCmd(acSysCmdSetStatus, S)

If you're not going to do anything with the V variable, there's not a
good done in calling and using it. (No harm either, but.... What's
the point of having it?)


or

SysCmd acSysCmdSetStatus, S

?

:)
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response
Nov 13 '05 #3
Br@dley wrote:
Chuck Grimsby <c.*******@worldnet.att.net> wrote:
Call SysCmd(acSysCmdRemoveMeter)

By the way, rather then using
V = SysCmd(acSysCmdSetStatus, S)

Try:

Call SysCmd(acSysCmdSetStatus, S)

If you're not going to do anything with the V variable, there's not a
good done in calling and using it. (No harm either, but.... What's
the point of having it?)


or

SysCmd acSysCmdSetStatus, S

all of that worked rather well. thank you.
Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: Andrew | last post by:
I use conditional compiler constants, set through the VBA IDE in Tools, <projectname> Properties, that I refer to throughout my code to control which code is used during development, and which...
13
by: Mike MacSween | last post by:
I'm doing this: strAccessPath = SysCmd(acSysCmdAccessDir) & "msaccess.exe" in a vb executable to do what it looks like. If I remove the reference to the access object library this seems to...
1
by: MLH | last post by:
Here's what I copied from A97 Help... Call the SysCmd function with the acSysCmdGetObjectState action argument and the objecttype and objectname arguments to return the state of a specified...
3
by: paii, Ron | last post by:
I use SysCmd to show progress of functions ' Show the progress meter s = SysCmd(acSysCmdInitMeter, "Process Run " & Count & " Step", Count) For i = 0 To Count - 1 ' Do something ' Update...
8
by: BillCo | last post by:
I'm updating a legacy app with table naming that makes baby jesus cry. It's a bit of a spider web though... no telling when and where the tables will be called by name. So I wrote this for renaming...
30
by: Mikael | last post by:
I am using Access 2003. I would like to use BLOB to display an image on a form. I have referred to the kb article: http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q103257& But the code...
5
by: bobh | last post by:
Hi All, This should be simple enough but I'm not getting it working for some reason so, what's the code and in what events In AccessXP on a form when a user clicks on a button(btnGetData) I...
0
ADezii
by: ADezii | last post by:
In Tip #12, we showed how to display a Progress Meter within Access by using the SysCmd() Function. By using this same Function, with different Action Arguments, we will now demonstrate how you can...
2
by: Dedalus | last post by:
If I want to retrieve a full version information for an ms access databases, I use (from vb6 code) the "Access.Application" object and SysCmd method. Whit the number returned by the method I can...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.