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 Westi 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. mtnclark

    Excel Lookup or If statement?

    Hi, Could anyone help me with this problem I have in Excel I have 3 columns Headed like so: A B C PostNo Instances BB1 BB1 5 10 BB2 6 BB1 5 and so on What I want to do is to sum the number of instances in column B...
  2. mtnclark

    Perl crypt

    I have a customised version of the useful work package tracking tool named Bugzilla which uses Perl crypt, This is an implementation of UNIX C-standard DES crypt(3) function . What is needed is a Windows implementation of crypt(3) (ie 'crypt.dll') that can then be called by MS Access to...
  3. mtnclark

    Perl crypt, This is tough.

    This is tough, but what I am looking for is advice on password decription as follows. I have been using a program customised Bugzilla ( established bug tracking tool)which uses Perl crypt, which is an implementation of UNIX C-standard DES crypt(3) function which is . I wish to use Microsoft...
  4. mtnclark

    Today's Date to be increased to tommorrows date if found..

    Pgk, Thanks heaps mate. It worked a charm. I had originally tried this code but had forgotten the update at the end. I had: rstDueToday.Edit Dim FirstDate As Date ' Declare variables. Dim IntervalType As String Dim Number As Integer IntervalType = "d" FirstDate =...
  5. mtnclark

    Today's Date to be increased to tommorrows date if found..

    Hi, I have a function which is used to ascertain whether an item on loan is due back today. This is done by searching through a column aptly named LoanEndDate. On discovering this date and comparing it with the current date a message is displayed on the screen. I would then like to set the...
  6. mtnclark

    Confirming User of database without password entry

    Franck, Would it be possible if you could explain a little how this code offering works. Thnx marty.
  7. mtnclark

    Confirming User of database without password entry

    Thanks all, It worked a treat.. I used ur code Franck, I work under an antiquated win95 env so was glad to see compatibility -------- Marty..
  8. mtnclark

    Confirming User of database without password entry

    Hello, I am not sure if this is possible but what I am trying to do is to confirm the users identity without them having to enter a password. The access database I am working with is networked and each user has a specific profile i.e. C:\WINDOWS\Profiles\UserId. Is there a way of...
  9. mtnclark

    Newbie-Mailmerge from Report from Form difficulty.

    Its ok, I've managed to do it..Thanks for the innovative responses.
  10. mtnclark

    Passing of Argument difficulty

    Hi Thanks to everyone who responded, I have used the following for my function structure and body. Function dbWrite(tbl As String, frm As String) Dim db As Database Dim rst As Recordset Set db = CurrentDb Set rst = db.OpenRecordset("SELECT * FROM " & tbl)...
  11. mtnclark

    Passing of Argument difficulty

    I have multiple forms and I wish to write to multiple tables from within each form. The code I use is currently: Dim db As Database Dim rst As Recordset Set db = CurrentDb Set rst = db.OpenRecordset("SELECT * FROM Assets") rst.AddNew rst!EmployeeID =...
  12. mtnclark

    Newbie-Mailmerge from Report from Form difficulty.

    I have a form called "frmEnterNewCust" which takes in details of new Customers to be added to a table called "tblCust".The record is saved after every entry into the form. There is a key field called CustID which holds a unique numeric identity value for each customer to base...

Part and Inventory Search

Back
Top