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 strongm 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. 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...
  16. dleiba

    Automatic Logon

    Greetings! Can the Environ(&quot;Username&quot;) syntax be used to automatically log a user into a secured database? Ideally I would like to disable the Logon Dialog Box that Access automatically displays when you secure a database and use the Environ(&quot;Username&quot;) to log the user into...
  17. dleiba

    VBA code to automatically logout database users

    Svet, Thanks for responding. I was beginning to wonder whether I had asked a silly question. One thing to point out is that my database is not split into a Front End and a Back End. Would an automatic logoff still be possible? Also, I am still clueless with regards to how the OnTimer Event...
  18. dleiba

    VBA code to automatically logout database users

    Hey guys, I was browsing through previous threads and found one regarding automatically logging off database users before maintenance. The thread is as follows: Create a field [LogOutStatus] in a system table of the backend that holds the values 1, 2 or 3 Create a form in the frontend that...
  19. dleiba

    Using Customized Toolbars on Popup Forms

    Hey guys, I have noticed that forms that open up as a popup do not display the custom toolbars which have been defined for them. Is there a fix or work around to this? Please let me know. Thanks in advance! Dominic
  20. dleiba

    VBA code to kick off logged users before maintenance

    Excellent job!! Thanks ALOT guys! Dominic

Part and Inventory Search

Back
Top