Search results

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

i didn't compile the code in notepad - i wrote it in notepad, exported it to VBA, copiled it - no problem. problem occured when i ran it. I have now deleted the database after exporting all my objects to a new database. i was working on a database started by someone else but i have done 80% of...

no none of the above. however i did compile the code in notepad to start with and then copied it across to VBA. the quotations marks were slightly different - this is the only difference i could see. i also exported everything to another database without any luck. strange thing is is that i can...

did that still does not run

hi really strange problem i just can't get my head around. i have a query called "que_02_delete" to run this from VBA i have typed DoCmd.OpenQuery "que_02_delete" the code will not run! i just get an error message telling me that the object cannot be found i just don't understand it? any ideas...

Hi strange problem which is driving me nuts again. i have this code running in the 'on print event' of a report which basically checks to see what the biggest text box border is and then makes all the text boxes on the report the same size and draws borders around them Private Sub...