Search results for query: *

Thanks for the link. Helped alot.

I am using Outlook 2000, but get a message stating "A program is trying to automatically send e-mail on yor behalf. Do you allow this?" The program is MS Access 2000. Since I am doing a scan, this could happen every 5 minutes. Is there an option in Outlook to turn this message off and allow...

Sorry, it would be more helpful. This is all in Test Director 8.0. I have no VBScript knowledge whatsoever, but when a test script is set to Passed (I believe the field name is TC_STATUS), I want an email to be sent automatically to a user, whose userid name is in field TC_USER_01. Of course...

I trying to write a script that will allow an email to be send to a person once the test script has completed and passed. I created a new field in the Test Lab area call 'Passed To', and wish to have the code take the value (person's user name) and email him letting him know that the particular...

Yes, unfortuneately that did not work.

I am linking to an Oracle table, and one of the fields is a memo field. The data is set up for one line, such a a name or address, then it is supposed to go to the next line. But when I display in Access, the 'enter' key (displayed as a thick vertical line in Access) does not drop down to the...

Hi Ken I create the report from a query. Then I run a macro, which is the "OutputTo" macro. Created the out as MSDOS-Text. On the report itself, there are no lines inbetween the fields. No headers or footers. All fields are long enough for any of the data. I tried creating it as RTF and it...

I have a few reports that I have to create .txt files, which have to be in a certain format. The problem is that on the report, there are no spaces, but when it is converted, it puts spaces in places. The spaces are not consistant (as in not in the same place throughout the report). I made...

Another way is to create a htm file that plays the sound file. Then insert the file as 'Insert to Text'. You outlook messages must be set to HTML. I use Outlook 2000 and use this method and it works great.

You can try using the SetWarning to NO in your Macro. If that does not work, then convert your macro to VB, and in the error section, run your macro in there.

PHV It works great!! Thanks

I have a listbox (using Access 2000) and it opens up a popup form by double-clicking. Is it possible to have it open up the popup by clicking the right-click instead?

I have a display box in my form which takes is a Memo field. Since this can be quite big, when the user opens up the form, I want the Memo field to be scrolled to the bottom automatically. Any help would be appreciated. Thanks

Joanne Go into Tools > Relationships. Add your three tables. Then drop/drag the fields that you want to create a relationship to.

I have a Access 2000 form that requires the user to see the date and time of different servers, depending on what environment they are working in. Is there a way to show the date and time of 4 different servers (selected by option or list box)? The date and time change in order to simulate...

The only time mine is greyed out is when the code is still running. Click on the stop button to see if that enables the reference option.

In VB Editor, click Tools > References. Look for the Checked ones that say MISSING: Should be easy to spot. Compare what is check for the workstation that works and to the one that does not work.

Check the references. I had the same problem and found that I was missing a .dll that was needed for the code.

One way is to create a table and specify which order you want to sort in, such as L = 1, B = 2, V = 3, etc. Then link that in a query where you sort on the number, but do not show the number, only the letter. This also allows you to change the order around easily by just changing the numbers...

John, Another easy way is just create a macro (SendObject) and have that open when you click on it. For your "To" field, just use "=[TextFieldName]". I found it alot quicker than typing in the code. And it works great for my app.