Search results

thanks for the extra info guys but it does seem strange in that if conditional formatting is activated then surely the back style should change automatically from transparent to normal?

rookie mistake my back style property was set to Transparent instead of normal (which i thought was default?) code works fine now thanks anyway

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

tried that but did not work. i also have the audittrail module running in the beforeupdate event of the form where i trigger the update - this does not work either. still thanks for the suggestion. any more ideas??

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

finally I've been of some help :D

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

thanks i was thinking of have a field with the table name but i just thought it would be a good idea to have the subdatasheet display its source name that it must have been built into an associated property by the developers. obviously not then. thankfully i have a pen and some paper thanks anyway

thanks for not answering the question! it's not a user interface for anyone else - it's for me. i would like the subdatasheets name displayed somehow so I don't get confused during MY develpoment of the database.

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

what would you recommend? setting user permisssions via folders and files? the reason why i'm looking in to this in the first place is that the file permissions i set via windows keep disappearing after about 1 week. i know it's an IT problem but they do not know what's causing it so i'm...

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

answer found if anyones interested for some unknown reason the 'hyperlink' field which was a text field had over 300 charaters of text in it (?? how this happend i do not know - default is 255). i only found this out by increasing the width of the of the field horizontally and i found 3 lines...

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

one other point perhaps i should note is that this code opens up IE to a maximized window Call Shell("c:\Program Files\Internet Explorer\iexplore.exe ", vbMaximizedFocus) however this code does not Application.FollowHyperlink "http://cardinet.ceredigion.gov.uk/", vbMaximizedFocus i don't see...

thanks but i've tried that and it did not work. the code runs without any errors EXCEPT it does not maximise the IE window. this could be down to the fact that i am opening a second tab within IE itself. that is the hyperlink first opens IE because it needs to be open before i can execute the...

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

anyone? seems such a simple action and yet i'm stuck for an answer as to how to impliment it. thanks in advance

hi i'm not trying to stop the program and it's mapinfo. i can get the map to show within Access on a form (i'm not showing the code as it's a mess at the moment and i'm trying to sort it out) but i have to click the 'record selector' on the form to see the map window. the code executes on...

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