Search results

Eventually I manage to separate the two event by adding a module-variable which "tells" the onChange (or AfterUpdate) event if the event fired by a new record addition or if the user changed an existing one. I can provide you with more details if you are interesting in.

In the Access World Forums > Microsoft Access Discussion > Forms subboard I can see that the last post was from you (RuralGuy) but when I open the topic I can't find it. What's wrong?

You are right, in fact the they are subforms on a main form. I am not very familiar with the afterUpdate event but could it solve my problem? I mean, as far as I know, afterUpdate fires after a record is updated or added. So it will also conflict with the procedure called by afterInsert event.

You are right, in fact the they are subforms on a main form. I am not very familiar with the afterUpdate event but could it solve my problem? I mean, as far as I know, afterUpdate fires after a record is updated or added. So it will also conflict with the procedure called by afterInsert event.

Well the afterInsert adds a new record in formB while the onChange event updates the relative record in formB. Both event-procedures are implemented with VBA.

Probably you didn't understand that in my form the new Record is added automatically (the form is in datasheet view) when the user types anything in the textbox. That's why both events are tiggered.

I use the events afterInsert of a Form frmA and the onChange of a field in the same form in order to make some changes to another Form frmB. Everything goes as expected when the field (with the onChange event assigned) of an existing record changes. The problem starts when I add a new record...

I've tried but it's not properly for my case cos as u can imagine in every hour of day several classes might are at the same time. So I need sth like Monday...Tuesday...Thursday 11:00 L/P/C......L/P/C...... L/P/C 12:00 L1/P1/C1...L/P/C.....L/P/C 12:00 L3/P3/C3 13:00 13:00 13:00 14:00 etc

Ok let me elaborate.. I design a DB for a school. I store the infos of the Schedule to a join table and more specifically each record keeps Day/Time/ClassID(from tblClass)/ProfessorID(same)/LessonID(same). At the report I don't want to present Schedule like Monday 11:00 Less1 Prof4 Class3...

Is it possible to "convert" a recordset to a query sth? What I want is to open a report with some data which come from a rst. But passing rst as an input argument for a report is impossible (?). So I'm trying to convert it to a query. Any suggestions? Thnx

A new problem arises. I want to use the value of a field of this single record as a criteria in a query. This query is based in more than one tables. As it is obvious I get an error message saying that no unique value could be specified, I suppose because this table (InitialConditions) is not...

I want to lock a table to disallow further records. I want to have only one record (I would have created this rec by myself) to store initial conditions and infos such Username/company etc. Any ideas? I'm also interesting in other solutions than locking a table if sucj a thing is not possible...

I have a subform inside a Form. When I'm trying to upadate the subfrom from an event triggered by a control in Form I get the error message that subform is not opened.Why is that? I've tried commands MoveTo or Select (subform) before update command in order to force update command to understand...

It's only numeric values. Thnx

How can I fix this problem? I don't want to write them down as 01,02...10,11 it not aesthatically nice

How do I change the color of the fields at first line (titles) of a form in datasheet view? Is it changeable after all?

I want to have a box with yes/no choices defining the Lessons a Student chooses. Sth like this Because the Lessons are quite plenty and they change from time to time, I don't want to have them predefined in the Sudent table, but to have a related table containg the Lessons providing more...

could u plz provide a little bit more details on this? I didn't find this newpage property. And how do I create a Class header? Thnx in advance

I have a report which presents the Students grouped by Class. I want every Class to be presented in a new page. How can I achieve this? Placing the Class control in the header doesn't wotk

Thnx but this just sums all the above records. I want to sum some specific records, meaning every control will have the sum of the previous ones.