Search results

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.

Thanks Pat I knew you'd have the answer. Is there any way of linking the count query back to the CourseAttended Table to return the Course Titles and Dates attended. If not I could just put the selection criteria ie course titles at the top of the report. Thanks again Snoko :)

No sorry it's on a seperate system. All I want to do is return everyone that has completed a set of courses. Not including staff who have only done some of the courses.

I have a small problem with a query. Example, I have three tables, tblStaff, tblCourse and the joining table tblCourseAttend. I can return records showing which staff have done either course 1 OR course 2 OR course 3 etc but I can't seem to return which staff have done course 1 AND course 2 AND...

What happens if you've got two copies of the same book. They'll both have the same ISBN number, therefore which one do you loan out ? You have to make each copy of each book unique. tblBookCopy intID - autonumber PK ISBN - FK to tblBook Copy - number tblLoan intID - autonumber(PK)...

Serak, Have you only got one copy of each book? If not you'll need to create another table for this (tblBookCopy) and link that to the loan table. It's an individual copy of a book that get's loaned not the book title. Once you get this right it should be a bit easier.