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...
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...
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...
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 =...
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...
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...
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)...
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 =...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.