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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dleiba

  1. dleiba

    Routing External mail to an Internal Address

    Greetings, How would I, using Exchange Server 2000, route an external email message sent to company@companyname.com to an internal address? Our previous email package, MDaemon, allowed a routing rule to be implemented where all incoming email messages are examined for certain criteria. Upon...
  2. dleiba

    Chnaging the Windows 2000 Password programmatically

    Greetings! I currently use the code below to allow the users of my application to change their Windows 2000 password. However, it does not seem to work on a consistent basis. Could someone possibly provide me with either an explanation for this or an alternative method? Thanks in advance...
  3. dleiba

    Updating the Value List Rowsource of a Field in a Table

    Greetings, I am using the following code to update the rowsource for a value list field on a FORM. <Field>.RowSource = <Field>.OldValue & &quot;;&quot; & <Field> However, I would like to update the underlying TABLE field's rowsource with BOTH values (Old & New) from the FORM. Possible? Let...
  4. dleiba

    Setting User Permissions via VBA

    Greetings, Is it possible to set the permissions for a user programmatically? If so, how? Thanks in advance, Dominic >(::O> dleiba@hotmail.com
  5. dleiba

    What is the VB code to compact a database?

    Place the following code on the On_Click Event Procedure of a button. SendKeys &quot;%W1&quot; SendKeys &quot;%TDC&quot; It's been working quite well for me. Let me know how it goes. Dominic >(::O>
  6. dleiba

    Comparing text field to System Password

    Greetings, Is there any way to compare the value entered in a text field to the System password for a specific user? Please let me know. Thanks in advance! Dominic >(::O> dsleiba@capital-credit.com
  7. dleiba

    Generating a FORMATTED text file from a report

    Greetings, Presently, I have a report that functions as a receipt for customers. On activate the report is exported to a text file. (for speed purposes) Is there ANY way to format this text file programmatically to make it a bit more presentable?? Essentially, what I'd like is to format the...
  8. dleiba

    Using Search Functionality to select a specific record in a Listbox

    Greetings, Here is my dilemma. I have a form with a listbox on it. The listbox is unbound and has a Query set as its data source. Presently the number of records being displayed is not large. However, I know that as the database grows so too will the records being displayed. I have therefore...
  9. dleiba

    Trapping Mouse Events

    Thanks Nick! I'll give it a try
  10. dleiba

    Trapping Mouse Events

    I currently have multiple forms setup with their Form Property set to &quot;Current Record only&quot;. Why is it then, that users who have a &quot;Wheel&quot; mouse are able to use it to scroll through ALL of my records? How can this be prevented? Thanks Dominic >(::O>
  11. dleiba

    Automatic Logon

    Much thanks Sean!
  12. dleiba

    Automatic Logon

    Ok, Wasn't sure about what you meant. Now that you've explained it to me, I've already done this with one exception. I have disabled the rights for the default Admins and User groups in Access and created 2 new groups. That way anyone wishing to access the database will have to use the .MDW...
  13. dleiba

    Automatic Logon

    Yep, I'm using a .MDW security file. I'm curious how to attach the .MDW file to my specific .MDB file. Also I'd really really appreciate you showing me how to get their Netware login to show up in the logon box. Thanks alot Dominic >(::O>
  14. dleiba

    Automatic Logon

    If you're referring to setting a Database password, then NO I don't want to password protect it. I plan to setup my network users in Access security with the SAME username and password they use to access the Network in general. Ideally, I want the database to: 1. Obtain or &quot;Read&quot; my...
  15. dleiba

    Compacting an Open Database using VBA

    Hey guys, I am using Office XP to open an Access 2000 database (it opens in Access 2000 format by default). I searched through previous threads and found the following command to compact my database when it is open. SendKeys (&quot;%(W1)&quot;) SendKeys (&quot;%(TDC)&quot;) I put this code...

Part and Inventory Search

Back
Top