Search results

thank you!!! For some reason I thought it was going to be a lot more complicated than that. Although I didn't know about the adding / subtracting in days so that was very useful. Its working like a charm :-) Thanks again!

Hello If anyone can point me in the right direction it would be much appreciated... I have a database with Clients and Contract Renewal Dates; I am trying to create a query (in order to create a report) that will show the user which clients are approaching their 'Contract Renewal Date'. I have...

Hi All, thanks to anyone who looked at this post but I've figured it out now :-)

Hi folks I have a continuous form with 8 text fields on (all in a row). I am trying to get it so that if one of the fields contains the word 'Visit', then the whole row turns a different colour... but only that one row that includes that word. I am guessing I will just have to change the...

Thanks for everyone's response on this one... I have now fixed the problem. It was in the part of the code where I was calling a procedure to open the main form... I was not setting the company ref until after I had opened the form, meaning that the only way the subforms got the information for...

Please see below the code I have on the subform... this was written with the help of my techy friend who helps to teach me from time to time. Without you looking at the database then I will try and explain as best as I can what I am trying to achieve.... I would like three lists of documents...

as I said, I have tried the code in several places, none of which appear to be working - only if the command button on the subform is pressed does it work. I need the sub form to be 'stand alone' in a sense, therefore it is not directly linked (parent and child) with the main form... could this...

Hello, I am hoping someone can help me... I am wanting a sub form (SubSent) to requery so that the txtDocDates text boxes alter depending on which company a user is looking at (the sub form is based on a query) I have tried to put a re query on several events, including events on the sub form...

Thanks to anyone who took the time to view this post. I have now fixed the problem. I have changed the text box on the sub form to an unbound field and then used the same OpenArgs as I already had but rather than trying to get the company ref and then link via that I am now simply checking the...

Hello Hoping someone may have time to look at the following... I have a subform (SubFrm_Warnings) which I need to appear according to which company record is open on the form... I have used OpenArgs on the DoCmd.OpenForm to set the companyref / ID number - this is working OK. I have now...

Good Morning I wondered if someone could spare some time to look at the following, I cannot understand why this is not working... Quick Background: I have a main form, comprising of several sub forms. On the bottom of the main form I have a Cancel Button. I have the following code on the Main...

Thanks for the advice, sorry it's taken a while to reply, I've not had much time on the database this week. I have tried the code above with a slight variation as below (I have set focus to just the one control, rather than your suggestion of 'previous' control - I wasn't sure with this...

Hello I hope someone can help... I have attached my database and pasted the code below... for some reason I keep getting the following error message: 'Run time error '2046' - The command or action 'spelling' isn't available now' Here is the code: Private Sub CmdSpellChecker_Click()...

Hello, I'm hoping someone can answer the following, I have searched the net and cant seem to get the answer .... Background: I have a text field called 'hypWebsite' - this is a hyperlink. The idea being that a user can double click the field and open up a customers website to view. It is...

Thanks, I will bear that in mind for any future things but it would not have worked in this case as it is only some of the controls on the tab control page, not all of them. Thanks though for your reply.

Thank you - that's perfect! And could come in very useful for other things in the future. All very good learning! I did have to alter the code a little though as the variable was called 'Public Function SetStatusOfControls(FormName As String, Status As Boolean)' but later on it was 'On Error...

Thanks vbaInet; I perhaps should have mentioned, the controls are already on a page of a tab control.... Thanks

I have tried 'grouping the controls' together (in an object frame or option group) but I don't know how to put the controls in the option group or frame in order to get them into one section? Failing that I will as you say create a loop for the controls with an array, was just trying to avoid...

Hello Hoping this is a nice quick one... is there anyway to make ALL controls visible on a form at the push of a button... I have quite a few controls all grouped together that start off when the form is opened as visible = False but on click of a button I want them to be visible... I am trying...

Thanks, I will amend my code accordingly. Can you explain however, as it is confusing me, why this code is working when changing industries (i.e. on Companies / records that already exist) but not working when adding new companies (if you would like to see what I mean then have a look at...