Recent content by willem

The project participants are students, each time they switch from one project to another the other has to be ended. In one month there is a possibility that they participated in 10 projects, but they will never be in more then 1 project at a time. I need to select those people that have...

I have a table containing starting dates and projects, each time one enters a new starting date and project, i need to set an ending date in the previous record. Should i use a query or module? How would i do that? Many thanks Willem

use this DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 willem

i have this form. It is an attendancy form per project per month. For each student i have a row of textboxes for every workday in the month. As students change projects their textboxes for the time not in the project should be disabled. They can change 2,3, 4 times a month. There are several...

I am trying to create a query that selects all last dates before a certain date . One person can have many dates. When i use the max function it just gives me the dates that are under the certain date. I expect more from a max function

There is a difference between null and 0. Null is an unknown value or unavailable input. Five +null = null. Null propagates. The statistical functions in SQL exclude the null values.

You can get an addin here Tsi soon it is called. http://www.trigeminal.com/utility.asp?1043 Willem

I have two related tables. One with student id, name, .... The other with projects and startdates. A student can only participate one project at a time. It is to keep track of students and their projects. Now i need to select the students for one month and one project. It is possible for a...

How do i trigger the current event on a form. Not just by going to the next record and then the previous. How do i click a button without clicking it? Last but not least, I have a form that contains a subform based on a query. When i click a button to open a new form i want the subform to...

What is the difference between formopan and form load event

Try for case 1 dim blncomp as boolean blncomp=true docmd.close and for case 2: Private Sub Form_Close() if blncomp=true then DoCmd.SetWarnings False 'turn off warning dialogs SendKeys "%TDR", False 'repair current database SendKeys "%TDC", False 'compact current database end if End Sub I...

Maybe the on current event will help

Can i call the .bat file in access and how. Actually i don't know what a bat file is. It is a single user db. I read somewhere that compactdatabase method could be used to make a copy of a db but I can't find much on that.

I have a form containing several records. It is a wage form , but sometimes one is payed to many or to much. In th oncurrent event of the form i have made an if then else structure and all works fine . Textboxes appear and disappear whether the wage was calculated right or wrong. But when i...

Use the following set recordset= currentdb().openrecordset("name recordset") do while not recordset.eof recordset.movenext loop if recordset.recordcount <> 0 then docmd.openform "frmname" else exit sub end if [This message has been edited by willem (edited 08-03-2001).]