Search results

Thats great cheers guys. Allan, can you have more than those two statements inside the brackets though? For example on the door choice check box I will need 6 statements in total.

Would you set it up like this where I just create separate If statements for each criteria or is there a more efficient way? If Me.chkDoorChoice = True And Me.cboFrontDoorType = "N/A" then DoCmd.RunMacro "mcrPleaseNote" End if If Me.chkDoorChoice = True And Me.cboFrontDoorColour =...

Hello, Is there a way of changing VB code so that ONLYif a statement is true then the command runs. This is what I currently have: If Me.chkDoorChoice = True And Me.cboFrontDoorType = "N/A" Or Me.cboFrontDoorColour = "N/A" Or Me.cboRearDoorType = "N/A" Or Me.cboRearDoorColour = "N/A" Or...

Thanks for your help!

I have a main form with customer information on it. Id, Name, Address etc and 4 buttons to take me to other forms such as Works Needed, Therapist Info etc. What I want is the four extra forms information to link to the ID on the main form so when I change record on the main form all the other...

My form has just started to add new records when I use the mouse scroller. Before when I used the scroller it would stop at my last inputted record. Any ideas what I've done to it or how it can be stopped?

Morning folks, Todays problem is as follows!... Is there away to set the values in a combo box depending on what option button you have selected. What I would like is to select an option button in an option group then that would trigger certain vaules in a combo box. And if I selected another...

Col, thats is brilliant thanks. Legend

Hi people of the Access world. Wondered if you could help me once again. I have set up a form to calculate a number of combo boxes where the option is selected to "Y". There is a bit of code where it is not working properly. I will post the code where I think the problem lies but if you need...

Forget the above post. Found it under the StartUp option in the Tools toolbar

Think I've seen this posted on here recently but cant find it. Is there a way to hide the database window so that only a form is visible? Then if you need to view the database window you can press F11 to make it appear?

Thanks for your replies Colin. I understand what you mean but not sure how to go about doing it. How do you set up the field vertically?

not sure what you mean sorry Colin. Any chance of explaining it how you do that?

19 fields (Q1, Q2, Q3 etc)

Hi there guys, I have set up a form that is going to be used as a survey. I have 19 questions that need to be answered and have set up an option group for each question containing 5 option buttons in each. Is there away to calculate a total score? for example if all questions were answered...

Thanks Colin that worked a dream!

Is it possible to do something along the line of:- if [combo box(1)] = "Y" and if [combo box(2)] = "Y" and if [combo box(3)] = "Y" then [Total] = "100" Not sure if you can do it this way but im sure you guys will know a way round it!

Cheers thats great

Hi people, I have a report that is linked to a data entry form. Is there a way to not show certain labels and text boxes if a text box on the form has the value "N/A"? Something like: Private Sub Report_Open(Cancel As Integer) If txtFireType = "N/A" Then txtFireType.Visable = False End If End...

Thats brilliant. Just what I needed. A true gent!