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

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

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

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

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

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

hi i have a report with a number of fields in the detail section. i would like the back colour of one field to change based on the value of another field. i am using conditional formating with the code below which basically says if the field 'operational risk' is 'low' then turn the text box of...

Hi everyone and yes i have looked through the audit trail threads but can't seem to find the answer. most probably simple answer but i can't find it and i'm using the module 'audittrail' which works firnd if i enter all the information or make changes through the form interface i have a command...

hi this is not so much a question as i know the answer. what i don't understand is why the reference i use to reference a recordsource in a subform from another form is not listed here: http://www.mvps.org/access/forms/frm0031.htm my code copies text from one form to another and this is the...

Hi I'm using subdatasheets at the moment. problem is i have other subdatasheets with similar named fields which makes it hard for me sometimes to figure out what table i'm looking at. is their a way when you open up the subdatasheet of getting access to include the actual table name in the title...

hi I am learning about enabling user level security using the wizard in access 2003. anyway after 2 days i've finally figured out how it works and yes i have read the recommended documentation. one problem (among many) i've found is that i cannot create groups because when i assign users to the...

hi basically i am trying to combine a hyperlink with individual X and Y grid coordinates so i can open a web page and go to a location. this has been working and now for some reason it is not. no one has done anything to the database and yet this query has stopped working and i have no idea...

hi guys i'm banging my head here trying to do this. i will not go into too much detail but i have a hyperlink which needs to open internet explorer which works Application.FollowHyperlink "http://cardinet.ceredigion.gov.uk/" this works. however when the hyplerink is activated i want IE to...

strange request but i'm working on intergrated mapping at the moment. i can get the map to show in a form via using VBA to 'talk' to mapbasic. i have a lot of problems but i'm getting through them one by one. my main 2 are these the map window in my form will not show UNTIL i click the record...

Hi I've been concentrating on GIS for the past 18 months so my database skills, simple as they are, have lapsed. i am trying to do a filter search. one box is number [ccc_ref_number] the other box is text [extra_ref]. it's simple really - i want to double click the record in the open form and i...

Hello everyone i don't post much these days as I'm doing a lot of GIS work. however i still keep an access database. i have a lot of linked tables and would like to import the tables locally all in one go. i know i can do it one at a time but this is tedious and time consuming. anyone how would...

hi guys i've copied and altered the code below to populate a combo box with table names. all works fine except when i click a table name in the combo box to select it i get the message microsoft access cannot find the macro "." Private Sub Form_Load() 'ValueList variable will store a...

Hi Guys can't quite seem to find what I want so I thought it would be quicker to post. how would i go about sending a Map Reference from access to mapinfo? we have a new secratary and I would like for her to find a location in the database table, press a button on a form which then opens...

I'll try to be to the concise and to the point because this problem is doing my head in. I'm using - access 2003, network printer, screen resolution of 1280 x 1024 secratery is using - access 2000, different network printer, screen resolution of 1024 x 768 I have created a database on my C...