Search results

You can efect the combo box Visible Property or you could use one combo box and have specific options available depending on the age of the user. At the point where the record is selected, you would test the age and efect the Form Control (combo box) accordingly. Because there are so many...

Yes, Sadly we mostly call our Sport Football but there are many versions and it appears Football has been claimed, for some time, to be the sport we, in NZ, call Soccer. Football, when I was young, was known as Rugby (All Blacks:)) Now we have: Rugby Union Rugby League (AFL in Australia)...

A list box instead of hard coded buttons is a smarter way although I still question the normal work flow issue in what you are doing. You don't append queries. You mean append a Record to a Table ? Test your query as a Select Query before changing it to an Append Query. If you are adding a...

Your Form TimeOffSummary1 is attempting to perform a not Normal task. The main part of the form is ok but the 3 buttons will always be suspect as to what they they can do. Think about how a Database should work and why you would even use one. If there were only 3 employees then why spend...

Sadly, articles are no longer worth what they once were. Especially the headlines! My wife was alerted to a TV News headline about health risks with backyard Hens. (we have 7) When she paid attention to the story it boiled down to "if you don't wash your hands...." As if back yard hens were the...

In NZ we have the same argument regarding same sex Marriage except in the US you have the added issue of State / Federal authority to decide which is really a different Can of Worms to the base argument. Our one Govt in NZ does have advantages but of course, we would fit into a suburb of New...

Sounds like some joke spreading around or did Donald Trump start this when he ran out of steam asking for birth certificates ? Of all the constitutional arguments raised in the USA how could a (non dangerous) sport be banned ? Surely the sport of shooting up the public every few weeks would be...

I know Marriage is a little off topic but I thought the word Marriage should be reserved for heterosexual relationships until I watched a documentary where it showed churches only adopted the word Marriage in the last few hundred years. Also, Marriage is used for many other Unions such as two...

If only Zero or above are options then you could add a Calculated Field to your Query that Sums the three fields. Only Select records where the calculated field is >0

Your description of the Form does not sound normal. If One Employee is at the top of the Form, how can you then check other Employees on the same Form ? I can imagine a Main Form where you can enter details of pending leave and a Sub Form (continuous) where you can check any employees that...

Can you expand on this ? Form attached to a Table ??

Maybe start from the beginning. Do you have a Continuous Form with a check box on each Record ? If so, then actioning the check box would normally change the bound table. The Append Query would select records from the Table where the field is Yes/-1 You may need to build in a Requery as...

You should be able to add and or edit code behind the button. The Wizard may not have been answered correctly. Try it again and it may work. Study each question the Wizard asks. Treat the code as each segment/line to be an action ie step by step and it may make more sense. The point is that...

What ever you have on the Form does not restrict you towhat your Append Query can add to a table. It is quite common for the query and or code to gather or create data for the record in question.

Are you wanting to "click" against employees taking leave and append all those records where a control has been checked ? If so, your append query would look for the flag on the table updated by the form control you checked. Use a Continuous Form.

Do you only want results where no more then One Field has Zero ? I would tend to use a custom Function where you can use SQL/Query and Code to get your result.

Welcome Wayne :) Lots of good support on this Forum.

If you use the Wizard to create the Print Report Button then it should work. If not you need code in the On Click Event of the button to open the Report. A better name for your report could be ClientPrintout ie avoid a Space. Depending on what data is required for your Report you may need to...

When a product is made Illegal, we create a new income stream for criminals. Prohibition caused more problems then it was supposed to resolve. Now, rather then Tax Payers pay to run around after Boot Legers, Tax is collected by the Govt on alcohol usage. Education is the only sustainable way...

Congratulations Bob. Thanks for may of your 30,000 that was directed to my problems and trust the count continues with your great assistance!!:)