Search:

Hi,
strName already has a value applied to it from the form, in this case a company name.

Thanks,
Mark

Thanks!

Hi Hans,
Thanks!

Mark

Hi Wendell,
VBA, but now I see that Hans has said I cannot use wildcards in a select method.

Thanks,
Mark

Hi Andrew and Pat,
What I am looking for is to filter based on a name using wildcards. The name might be something like Acme North, Acme South, Acme West, etc. I tried using:

case "*Acme*" but it...

Hi All,
I have a "Select Case" method in my DB and I want to look for anything containing a name. I am trying to do this:

Select Case strName
Case "*anyname*"
me.command123.visible = true
Case...

I am using redemption mail to send emails from Access. I have the basic functionality working fine but now would like to send the mails from a common group mailbox. Does anyone have any idea how to...

Hi Hans,
Thanks again!

I couldn't get the "nomatch" thing to work but the rest is working. I will play around with it later...

Thanks,
Mark


You can use code like this. I've assumed that...

Hi All,
I have a subform that has a number of records on it. I want to move to a specific record based on an input I have already collected. What is the command syntax I would use to set the focus...

I was able to do this a while back but can't remember how to now!

I want to call another forms "on current" routine. The form in question is loaded at the time I am calling for it. What is the...

Hi Andrew,
That looks good. I will give it a try.

Thanks,
Mark


Have you tried something like this which was found here - http://www.experts-exchange.com/Web_Develo...Q_11973538.html
dim...

Hi Hans,
OK, no problem. I will keep trying things and if I come across something that works, I will post back.


Take care,
Mark



I meant the Window.setTimeOut mentioned near the end -...

Hi Hans,
I can try this but "Sleep" is also not in the keyword list. I am now wondering if some sort of "Timer" DO/LOOP would work.


Thanks,
Mark


Does VBScript - sleep command help? (See...

That sounds like it may work. Any idea how you would monitor the clock?

Thanks,
Mark


Perhaps you can write a Do loop that simply burns up time doing something useless and monitoring the...

Hi,
WScript will not work with VBS 5.5. Do you have any ideas of another way to waste a second or two?

Thanks,
Mark


I can use WScript.Sleep in a .vbs file without problems - see attached...

Hi Hans,
I will try but I am not seeing that in the VBS 5.5 command reference.

Thanks,
Mark


I can use WScript.Sleep in a .vbs file without problems - see attached sample.

Hi,
The equipment is a machine that acts like a printer with programmable input. There is an option to run VBScript 5.5 compliant commands with the job file when it runs. Looking at the VBS 5.5 help...

Hi All,
I am working with some VB script (5.5) on a piece of equipment and would like to pause, or delay, execution of the script for a couple of seconds. Does anyone know if this is possible? I am...

Hi Hans,
Since this is something we do quite a bit with the DB and it is inefficient in it's current state, I think I will dive in....

Thanks,
Mark



You can use Automation to control...

You can try using the

Me.AllowEdits = True (or false)

based on conditions for the form. I use this all the time and it works great. You would need to go to the code window for specific event on...

Hi Hans,
No idea at this point. It is hard enough to try to isolate the corrupt record after the text is pasted in and I wouldn't have any clue how to find out as we usually just delete the faulty...

Hi All,
In my DB front end, the user can paste in notes from various places. Is there some code that will turn it into pure text before stamping it into the table? Sometimes on paste operations, the...

Set the Allow Edits property to Yes and the Recordset property to Snapshot. This will disallow editing, adding new records and deleting existing records, but leave unbound controls enabled.
...

Hi All,
I have a form which for the most part contains read-only information. Along with that, I have the allow edits property set to no on the form. There is a new option group I added to the form...

Hi Hans,
Same issue I had a while back. The problem was actually in how I was doing the movenext / movefirst commands.

Thanks for jogging my memory!

Mark