Search results

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...

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

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...

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...

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

How can I reffer to a specific form on a subform in continouous form view?

I firstly posted in Forms, but I guess it's more of a module discussion subject so I direct it here. http://access-programmers.co.uk/forums/showthread.php?t=95323 ANy ideas?

I have a form in continuous forms mode and fields with amounts. I want to have a field belonging to the Detail, where will be presented the sum of all above recs until current one. E.g. Name MyValues Sum fwe 10 10 gfgerg 2 12 gegrere 4 16 and so on. Any...

I want to build a function which finds some recs with SELECT WHERE statement and then convert some (specified by me) fileds of these recs into string and concatenating them to a signle string and putting to a memo field of a report. Sounds complicated but it isn't. My only problem is to the...

If I copy paste the SQL from a query (View->SQL) to a macro it doesn't work. Why? I've tried removing quotes,Caps, adding quotes, parenthesis nothing worked. Any ideas?

Is there a (easy) way to present records in a single row? Like continuous forms, but in this case to be sth like continuous columns ;) For example I want sth like this Student1 LessonA LessonB LessonC Student2 LessonX LessonB LessonZ and so on. The records are in a table the structure of...

I have a continuous form based on a query. I''ve added a combo box unbound, and the problem is that any data I enter in any cb are repeated in every record. Any ideas how to avoid that?

I've created a Form based on a Query. The Form is in table mode (multiple forms). I've added a new text box. Each time I enter anth in the text box of a record, all the other relative text boxes in all records of form fill with the same. Why? I want to enter different data. Plz help. Tomorrow...

I want to find records upon some criteria and update or add according to the number of the records found. I'm not asking how to build an add/update query, my main question is how to find the recs and take decision what to do upon their number. I can't find any count upon criteria method Tnx...

http://www.access-programmers.co.uk/forums/showthread.php?t=93342

I've a database for a private school. Datas for the schedule are entered like this. Student1 Lesson1 ClassA Student1 Lesson2 ClassA Student1 Lesson6 ClassA Student2 Lesson2 ClassA Student2 Lesson4 ClassA and so on.. I want to view these data in a report with the following way...