Search results for query: *

Found an easy/dirty way to avoid this: Don't use the cursor! one of the joys(?) of pl/sql is that there's many ways to do the same thing. I relaised I could use a select into instead of a cursor fetch, and the error vanished. Still no idea why it appeared in the first place though. ho hum.

Hi, In a rather large form, I'm trying to make a new procedure. All is well until I add the cursor, and then it won't compile. The cursor works fine in SQLPlus, but forms won't compile it - I get Error 0 at line 0(!). The cursor is something like this: Cursor c1 is SELECT ta.trans_id...

Hi, I need to create a button which will print a variety of word documents. Bascically, this is for a user who needs to print out an 'application pack' for potential new employees. This would include 3 documents, one of them being printed twice (ie. so the receiver can keep a copy for...

When making your tables, you can use the lookup wizard as a field for Gender. When creating the field, go to Data type, select Lookup Wizard and away you go. When you create forms or whatever, based on the table, it will automatically make a combo box fro you whcih has "M" and...

I have tried the grouping and sorting thing. No joy, I'm afraid. The report is still printing more than one tutor and thier students per page.

I have a report based on a query. It is used to bill private tutors for work the agency has found them. Obviously one tutor tutors many students. The report should be formatted so that there is a page break at the end of each tutor's record. It works fine, but I can not get the report to...

I have a query made in access which lists students taught by private tutors. Obviously most tutors teach more than one student. I need to merge this with a form that bills each tutor for an admin fee for the setting up of this tuition.Thus, each instance of the form should list one tutor, and...

when you use the wizards to create a combo box to do something useful such as look up records based on the value of the combo, don't change the name of the combo to something 'useful' such as cboFindOrder after having used the wiz to create it. you will find that Access has created code for...

Access help talks of a Counter control in its help files (see under Page Break ). But where is this mysterious Counter control? It's not to be found in the help files by typing in 'Counter', and does not appear to be available as a control in the toolbox, or under 'More controls'. The thot...

Thanks Aivars! the wizard creates code similar to that you suggested. After further exploration I think the problem was that I had been changing the name given to the combo box by the wizard ... it's the only problem I can think of. It seems to be working (for now, but I won't trust it for a...

It should take less than 10 seconds to create a combo box that does this (just use the wizard!), however ... the combo boxes I have created worked intermitently and now not at all. Is this some bug in Access that only I have? This kind of thing is a basic necesity for a user, eg select the...