Showing a form without a form

  • Thread starter Thread starter Scott Simonson
  • Start date Start date
S

Scott Simonson

Huh? I've asked this question before and all I got was people saying why not
use a form. I touch many different databases and I always want to add my
code to them to do things. However, in order to provide a status message I
have to create a generic form that I must remove after I am done. Is there a
way to throw up a status form without first having one? This should be a no
brainer in my opinion, but that doesn't hold much water, I guess.

Any ideas to provide this function? Any version of Access? 2000 or XP? Only
XP?

Scott
 
Scott said:
Huh? I've asked this question before and all I got was people saying why not
use a form. I touch many different databases and I always want to add my
code to them to do things. However, in order to provide a status message I
have to create a generic form that I must remove after I am done. Is there a
way to throw up a status form without first having one? This should be a no
brainer in my opinion, but that doesn't hold much water, I guess.

Any ideas to provide this function? Any version of Access? 2000 or XP? Only
XP?

Scott
Click to expand...
Have you looked at SysCmd?

Ron
 
No what is it?


Ronald W. Roberts said:
Have you looked at SysCmd?

Ron

--
Ronald W. Roberts
Roberts Communication
(e-mail address removed)
To reply remove "_at_robcom_dot_com"
Click to expand...
 
Scott said:
Huh? I've asked this question before and all I got was people saying why not
use a form. I touch many different databases and I always want to add my
code to them to do things. However, in order to provide a status message I
have to create a generic form that I must remove after I am done. Is there a
way to throw up a status form without first having one? This should be a no
brainer in my opinion, but that doesn't hold much water, I guess.

Any ideas to provide this function? Any version of Access? 2000 or XP? Only
XP?
Click to expand...


Does MsgBox (check Help) do what you want?
 
Thanks for the reply Marshall. No a msgbox requires interaction from a user.
I want to display a form(that is created on a fly) that list the current
status of a process that my routine is in.

So a form would have a list box that contains for example:

Step 1 completed...
Step 2 completed...
Step 3 completed...

But I do not want to have a generic form already created in the database.

Thanks again...
 
Other than the standard progress bar meter (SysCmd
function), I don't know of any way to display that kind of
thing without already having created a form in the database.
 
So can you have a generic form, with an empty listbox ? Then populate the
listbox from a string built 'on the fly' as the process completes.

Its otherwise quite difficult to create a form 'on the fly' from scratch,
although you could use the undocumented LoadFromText method. But you still
need the basic design of the form stored somewhere, so you might just as
well pre-create the form and just show it when needed.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
Scott Simonson said:
Thanks for the reply Marshall. No a msgbox requires interaction from a user.
I want to display a form(that is created on a fly) that list the current
status of a process that my routine is in.

So a form would have a list box that contains for example:

Step 1 completed...
Step 2 completed...
Step 3 completed...

But I do not want to have a generic form already created in the database.

Thanks again...


why
not
Click to expand...
message
I
Click to expand...
a
Click to expand...
 
Back
Top