Search results

I want to built a loop like this For i=1 to N subTotal=FORMi.aControl.value next i The FORMi is what I can't implement, this is what I mean by saying reffering to a signle form. I know that there's the statement Me, which reffers to the current form (record), I want by some way to reffer to...

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

Hm, that is the reason I guess. But why is that? The stupid thing is that the error msg says that it must contain CREATE, SELECT, UPDATE etc But if u use the same statement (select quey) in a module it works fine. Strange things happen...

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?

Thnx it worked!

Thnx abt the reply but I have to apologize for making a serious mistake :( The Lessons are in a different table, connected with Students with a one-to-many relations (1stud many lessons). So setting up like the way u suggest is impossible. Any ideas now?

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

Eventually I didn't avoid this solution. Just fir the record I created a new helpField in Table just to bound the cb. Now it works fine. I can surely consider this as a bug, and it should be fixed in next release of Access

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 wrote "multiple", I was meaning continuous

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

Sorry abt the incovinient place. A moderator to move this post here http://www.access-programmers.co.uk/forums/forumdisplay.php?f=27

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

thnx a lot but my problem is how to assign the "x" on each occurence of the desired info

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