Search results

Hi all, Probably simple question, but Im stuck! I have a subform on a main form wich is basically a list of parts taken from table "parts", there are 15 text boxes called "parts1","parts2", etc with link to the data in the table. I want to set a for..next to examine these, if they are blank...

Hi, Thanks for the help, only it doesnt quite work :( not sure where Im going wrong, I get an error on this line Set rst = Forms![parts_main]![parts_sub].Form.RecordsetClone My main form is parts_main and the subfom is parts_sub (original!!) I get an error saying it cant find the field...

Thanks for the reply, I know how to access PARTS of a subform, i.e.forms![form name]![field] etc, but I cant get it to do anything else, i.e. count the number of records, im sure its something simple but theres that many commands lol.

Hi all, Have a main form with a subform, basically the suer selects parts used on the main form, these are then transferred to the subform whos value is stored in table "parts_used", however as the "accept" button is clicked on the main form, I need to count the parts_used and enter the total...

Thanks, I'll give that a go tomorrow- just about to leave for a party!! CALV

Hi all, Im stuck again :( The part im stuck on is this- I need a list of parts (from a table) displayed in a list so the user can select the parts used, what I want is to dbl click on the part from the listbox and then transfer this part to another list box (or whatever) so I can store this in...

Thanks for the reply, unfotunately the reasons you mentioned dont apply :( I tried making a new db with like one form and a command button, same thing, as soo as I type, it "takes over", puts spaces, takes spaces out, for eg if I type "dim db as " then as soon as I type say "d" for database, it...

Hi all Doing some work on a database both from home and work, at home, I start typing, for eg "docmd." and then a list pops on, and stays there allowing you to select from the list and press tab to accept it, however at work, the list sort of flashes on then disapears! also at work, it tends to...

HI all, GOt a subform on a main form in continuous form view, all working fine (almost!!) but the subform is in order of ID (autonumber) I would like this in REVERSE order, is there a way to do this ? TIA CALV

Hi all, Working on a dbase just now, main form has a subform that logs job numbers, this works fine except I need to update my main form in order to update the suborm, for eg. if I add a new record on the subform, either by the record selectors (which will be going) or my "new" button which...

Thanks a lot, it was the break on all errors that was causing it.

Thanks for the replies, unfortunately Im off sick now so cant test it- it works fine here so the code is fine, I'll check for the tick on monday.

Hi all, Access2000 For some reason, on error goto doesnt work, it just breaks with an error rather then carrying out the GOTO, does anyone have any suggestions? I can stop it TOTALLY by removing the tick in startup/use special keys but I dont what that !! has anyone any suggestions?

Hi all, Im hoping someone can help me out here, Im quite a novice so please bear with me, Ive created a database to log phone calls taken- who (from drop down list) took the call, and the reason for the call (a few other similar details too), I have created a report that I print out every...