Search results

Hello Just a quick question; I have a field in my Contacts table for 'Website'. I have set this field in the table as a hyperlink field. When the user enters the website address on the form this then appears as a hyperlink and will take them to the appropriate website when clicked - all...

Thanks, have done as suggested and it is working like a dream - just need to amend one of my other queries slightly now and I should be good to go. :-) Thank you for your time, very much appreciated!

Thank you if you took the time to read this post - I believe I have figured it out - my text boxes were set to BackStyle: Transparent. Now I have changed it to backstyle: Normal the formatting is working :-)

Just in case any of the following will affect what's going on... some of the form properties are as follows; Recordset Type: Snapshot DataEntry: No Allow Edits: No Cycle: Current Records The form's control source is a query Thanks

Hello, I'm having a problem with conditional formatting - wondered whether anyone else had experienced this... I am trying to change the back colour of multiple text boxes on a continuous sub form to highlight particular records if they meet a certain criteria. I know the rule I have written...

Good Morning and Happy Friday :D I am hoping someone may be able to point me in the right direction with the following - I hope I explain it clearly enough but if anyone needs any further information please let me know... I am working on a diary system at the moment in which users set...

ok, think it may have been my field called completion date - it doesn't have a space, should have been 'completiondate' - seems to be stepping through OK now... will update if I still need help. Thanks if you have read this post :-) xx

Morning all, I am hoping someone may be able to shed some light on the following, I am still quite new to writing these and cannot figure out where I have gone wrong... on execute I am getting a syntax error in the INSERT INTO statement... please help :o Here is the code I have written...

I had not put that as a string... I needed an extra pair of '' YEY! It works! Thanks for your time :-)

Ok, I think my first issue was that my table fields were called 'Date' and 'Time', access didnt like this - I have now changed these to 'DateofCorr' and 'TimeofCorr'. I am still getting a syntax error but this time much more specific - it now says; 'Syntax error (missing operator) in query...

Thanks, I have put the hash signs around the Now(), I also put the hashes around the date and time as on reflection I had them as strings and in the table they are date/time fields - not sure if that makes a difference... I have pasted a debug.print into a blank query (great tip). I am however...

Good Morning I am hoping someone can help me locate where this error may be... I am getting a syntax error when I try to execute... it has not given me an error when writing the code and it steps through both lines fine with all values OK when viewing in the immediate window. Then when it...

Thanks for the response; I have gone with a zoombox for the time being... we will see what the boss has to say, hopefully it will suffice... Thanks again for taking the time to reply :-)

Good Morning all, happy Friday! :) Can anyone help with this one... I have a memo field on a continuous form for users to type 'notes' in. These notes can vary hugely in size, e.g. one entry may only be 1 line long whereas others may be 10 lines or more. At the moment I have a fixed size memo...

Nevermind... I have chosen to refer to .controlsource instead... that suits me fine. It just prevents the user from having to see 'txtfees' for example (now it just says 'fees', or 'cboprovider', now it just says 'provider' :-)

Not sure if you will be able to help with this one... just an after thought, while this appears to be working the control name doesnt mean much to the user - instead of ctrl.Name is there anyway of inserting the controls caption instead? Thanks

Appears to be working now, HUGE thank you - you wouldn't believe how long I've looked at it and how many times I've tried... and now, it's just clicked :-)

Hi All :) I have the following code on one of my forms which will help me to keep track of any changes that a user makes... this is working perfectly at the moment - a huge thanks to this forum where the code came from (have tweaked to fit my db). The only thing is, I do not want it to look at...

Also, when I change it so that the array is within the main function as follows; For Each ctrl In AuditCtrls AuditCtrls = Array(Me.txtCompany, Me.txtFees, Me.txtAddress1, Me.txtAddress2, Me.txtAddress3, Me.txtAddress4, _ Me.txtPostcode, Me.OptCompany, Me.hypWebsite...

Hello I am hoping someone can shed some light on the following for me as I am getting confused... My array is not working so the For Each Loop will not work, I am hoping someone may be able to point me in the right direction of why it is not working? I am getting the following error: error...