Search results

Hi Peeps, Really hoping someone can help. I'm trying to create a simple search page. I have many fields and have coded it like this.... In a text box you type what you want to search for. This then populates a global variable.. ie.. searchtext = "big" I then have a public function like...

I am trying to format a text box so when it contains either "HH" , "HA" or "HP" it turns blue. I assume I use the expression is box... I've tried Like "H*" but that doesn't work.. can anyone offer some advice ? Many thanks Steve

I'm having trouble with a query when trying to list everything in my table. I have placed a function which passes a global variable into the query builder. The variable is selected by a combo box. This all works great when I want to only list part of the table but I am unsure how to pass a...

I am creating a holiday planner and want to show all the employee's on a continuous form (month view). Is there anyway to force a record to appear even if it fails the sql statement ? The reason being is that I want to show all the employee's even if they are not having any time off in that...

My head just can't suss out whats going on.. PLEASE help me before it fall's off. I'm coding up a holiday vacation planner for work here. After lots of messing about this is how I've done my table... tblHoliday Fields are.. employee holidaymonth day01 day02 day03 day04 etc.. the day## is the...

Hi, I'm trying to create a staff holiday planner as we currently use whosoff.com which has now decided to charge. I have made a start on the database and have set it out like this so far... 4 Tables.. tblDepartment (containing department names) ie. 1 Shop floor 2 Director 3 Staff etc...