Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rjurgens

    Warning message when sending email via MS Access

    Thanks for the link. Helped alot.
  2. rjurgens

    Warning message when sending email via MS Access

    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...
  3. rjurgens

    Create a script to email from a passed value

    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...
  4. rjurgens

    Create a script to email from a passed value

    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...
  5. rjurgens

    'Enter' character in Memo field

    Yes, unfortuneately that did not work.
  6. rjurgens

    'Enter' character in Memo field

    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...
  7. rjurgens

    remove spaces of Report to .txt file

    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...
  8. rjurgens

    remove spaces of Report to .txt file

    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...
  9. rjurgens

    Emails with sound?

    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.
  10. rjurgens

    Not In List event

    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.
  11. rjurgens

    Open form from listbox using right-click

    PHV It works great!! Thanks
  12. rjurgens

    Open form from listbox using right-click

    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?
  13. rjurgens

    Scroll to bottom of Memo box

    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
  14. rjurgens

    Access Subdatasheets

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

    Showing Date/Time from different servers

    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...
  16. rjurgens

    Reference is greyed out under tools in MS Access

    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.
  17. rjurgens

    MS Access References

    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.
  18. rjurgens

    MS Access

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

    Advanced Sort - Not Alphabetical

    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...
  20. rjurgens

    Sending email from access - address in text field on form

    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.

Part and Inventory Search

Back
Top