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!

  • Congratulations biv343 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. roles40

    Password Entry displayed as "******"

    Is there any way to mask a msgbox entry as *****'s to hide a password?
  2. roles40

    Passing Username and Password during drive mapping

    I am a relative newbie @ VBS. I am in need of some help finding a function that gathers the password much like the username is gathered from the machine. Here is the code that I am using so far. Set WSHNetwork = CreateObject("WScript.Network") Set...
  3. roles40

    SQL - Eleminate null fields from a report

    mwolf, Thanks for the quick response, but I think that we got some wires crossed. The table consists of 4 text fields, and about 96 Y/N fields, that would be a very long command. Any way to shorten that up? Thanks again!! JR
  4. roles40

    SQL - Eleminate null fields from a report

    Using MS Access 2k, Query builder, SQL View. I have a table that has about 100 fields, all but four of these are boolean(Yes/No) data types. I am attempting to generate a report that will only display the fields that are set to YES. Here is what I have tried to no avail. SELECT * FROM MyTbl...
  5. roles40

    If then stament in VBA

    Bill, thanks for the code, works great. u da man Thanks!!!! Jamie
  6. roles40

    If then stament in VBA

    Sorry for the horrid question, but I can't seem to figure this out. I have a combo box that has two values in it, pending and completed. I want a text box to update to the current day when the value in the combo box is changed to completed. This is all on a form by the way. I tried to use...
  7. roles40

    Opinions on Apache for Win XP

    Ace, I feel you on the Linux, I too am an aspiring Linux nerd, but I can't get anyone else in the office to even attempt using it, there scared. We already have Win 2k server for mail and ftp. Just need something to dedicate to a web-server. I actually found out today that we are going to...
  8. roles40

    Opinions on Apache for Win XP

    Thinking of using Apache for a new web-based DB(access) at work. Any input good or bad on Apache? Thanks! Jamie
  9. roles40

    Updating a record through a DAP?

    I have two DAPs and one database. One of the DAPs is a form requesting assistance. The second DAP brings back the data entered from the first DAP, by reading it from the table. There are two drop combo boxes, one date being read in, and one text box that I need to read into the table from...
  10. roles40

    Using a Module in a DAP

    Thanks again! You hit it on the head. Two Stars!!!
  11. roles40

    Using a Module in a DAP

    FancyPrairie, Hey, thanks for the help with the code. I put the code in verbatum from your sample. I am getting an error at runtime. It is as follows: ActiveX component can't create object: 'Outlook.Application' This only happens when I am using VBScript, not in VB like the code I posted...
  12. roles40

    Using a Module in a DAP

    I am a relatively new Access user in need of some assistance. I have created a module that I need to implement in a DAP. This module emails a notice to me when a command button is clicked. The problem that I am having is that the current code for the command button is in javascript and the...
  13. roles40

    OnMouseClick?

    Leigh, Works perfectly...you get a star. Thanks so much for your help, Jamie
  14. roles40

    OnMouseClick?

    OK, I might have been a little premature in thinking that this problem was resolved. I am using access 2k and am trying to send an email to my email account whenever someone adds a record to the database. I have this code: <SCRIPT language=javascript event=onclick for=Command2>...
  15. roles40

    OnMouseClick?

    Thanks Leigh! I was wrong, the OnMouseClick command is Java. My mistake. Jamie
  16. roles40

    OnMouseClick?

    I am in need of help finding or developing code for OnMouseClick. I am pretty sure that there was a macro included in Access 97, but I am now using 2k. If anyone knows where it is, or has code for it, you would be greatly appreciated. I am actually trying to use the OnMouseClick to send an...
  17. roles40

    Changing Domains to get to a database

    Here's the situation: We have two buildings with two different domains. We have a database for employees to report any issues they are having with their computer. The employees have a DAP(employee) and the admin have our own DAP(admin). These are all liked to a database on a shared network...
  18. roles40

    DAP displaying previous record in DB

    You all are great, that would have taken me forever. Thanks Jamie
  19. roles40

    DAP displaying previous record in DB

    Thanks again. Do I have to do that in a text editor to the HTML file, or can i just do that through Access?
  20. roles40

    DAP displaying previous record in DB

    Thanks for the help on question 2. Let me restate question 1: This particular DAP is set up to allow the viewer to enter data into 8 feilds, which are entered into the DB. Every time I open the DAP it displays the last record added to the DB, not just by me, but by any user. I have even...

Part and Inventory Search

Back
Top