Recent content by snoko

This doesn't seem to work in Access 2003 when you select the 'Compact and Repair Database...' option. Any ideas why ?

Rosx, Try this, insert this into a module and then call this from your form where you require the calculation Function Work_Days(BegDate As Variant, EndDate As Variant) As Integer Rem Extracted from TechNet ref.Q210562 ' Note that this function does not account for holidays. Dim WholeWeeks As...

Create a shortcut to the data and insert the path to the Access 2000 exe followed by the path to the db. This will then only open with Access 2000. Like this: "C:\Program Files\Microsoft Office\Office2000\MsAccess.exe" "C:\db\MyDb.mdb"

Try this... Sub ChangeEmail() Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim place As Integer Set dbs = CurrentDb Set rst = dbs.OpenRecordset("tblEmail") Do Until rst.EOF place = InStr(1, rst!stremail, ".") + 1 'Find and include dot rst.Edit rst!stremail = Mid(rst!stremail, place...

You don't need a Chkbox for both Male and female. It's the same thing, if they're not male then they must be female !

You will basically need 3 tables tblUser ------- intID - Autonumber (PK) strName etc etc tblGroup -------- intID - Autonumber (PK) strName etc etc tblUserGroup ------------ intID - Autonumber (PK) intUserID - Long Integer (FK) intGroupID - Long Integer (FK) Hope this helps

If anyone is interested, here is the code to alow you to change a files 'Last Modified date' in windows using vba. Option Compare Database Option Explicit Private Type FILETIME dwLowDate As Long dwHighDate As Long End Type Private Type SYSTEMTIME wYear As Integer...

Yes, I want to change the 'Last Modified Date' using vba.

Hi, Does anyone know how to change a files 'Last Modified Date' with vba? I wish to change all the files in a particular directory to todays date. Many thanks.

Use the combo box's bound column as your criteria.

Have you tried using the "Search" facility on this forum?

Don't pass the date (Now) from the asp just set the default value in the Access table to Now().

Steeler Fan, Every user should have their own copy of the fe on their machines linked to the be on the server. You should create a third db called start.mdb and pass out a shortcut to this start.mdb to every user. The start.mdb should contain one module that copies the fe from the server to the...

Cheers Pat, I've got it all the logic sorted now - excellent. BTW, I've got a Start date and a Finish date. The finish date also being the completed flag. Should now be able to create variables to assign the course codes and pass them into a SQL string to return all the courses attended...

Or create a unique index containing all three fields.