Recent content by Davros

hi guys again a simple problem but it has me stumped (been doing GIS for some months now - perhaps some cobwebs in the head). i have to make my applications simple as the people who use them are not very IT. i have a hyperlink field. on a form this field is a combo box. the problem is from the...

problem solved. i needed to use the grouplevel command. the code above now becomes Me.GroupLevel(0).ControlSource = Forms!frm_query_all_inspections_combined!comorder1 Me.GroupLevel(0).SortOrder = False which is sort in ascending order based on the value in comorder1 another sort field in the...

actually it's still not working i've cut the code down to its basic component and its still not working. the code i'm using in the on load event of the report is Me.OrderBy = Forms!frm_query_all_inspections_combined.comorder1 Me.OrderByOn = True i can't see anything wrong with this yet the...

thank Bob Larson you're a star!!

hi sounds simple enough but i can't get it to work. the reference is spot on - i use the expression builder actaully in the sort area of the report to build the expression. it i actually select the field name in the sort area it works - but i want the report order to be dynamic and sent from a...

the person i'm doing it for does like the form i designed and as he's on a higher pay grade. have you tried explaining access to someone who does not understand it yet wants their own way? oh well - he will just have to scroll through it

each record has 10 fields associated with it in a horizontal design. these 10 fields in report view will not fit on the screen hence the scrolling. in print preview you have a zoom option so i can fit the whole record onto my screen and still read it. this is what i'm going on about. you cannot...

what a pain. i have an A3 report which you have to scroll through, both up-down and across, just to view the whole record. yet in print preview you can see the whole record?? seems a strange design problem. is there anyway i can put and active a command button on a report that opens up in a...

hi firstly is it me or has the search facility on this fantastic website been changed? everytime i do a search i now almost always get 500 records which is far to many records to sort through to find a solution for a specific problem. anyway my simple problem is this: one of my reports shows in...

cheers guys - i'll try the above. the monkeys i build simple databases' for do like their buttons.

yes tha's what i was thinking - there is no record to delete as none has been saved. as to why i'm doing it - i'm testing a database and i have to consider that someone will create duplicate records. they will then have to delete them simply ie by clicking a button. basically because they will...

hi simple problem but i'm looking for a simple solution but can't seem to find it. part of my tables data is copied over to another table - sometimes this data is a duplication. when i try to save the record i get the standard access duplicate message. all this is fine. however when i try to...

thanks for that site i've already done some of the stuff like removing the ribbon name from the options - it still shows up on my database though

no but i have deselected the full ribbon view in the access options

hi strange problem i have split up my database and want to hide/disable the quick access toolbar. i can't find a command to do this ( i've ran the code DoCmd.ShowToolbar "Ribbon", acToolbarNo but the QAT still shows). the problem i have with this toolbar showing is that people have access to the...