Search results

just thought I would post how I managed it in the end.. I dropped into VBA and did the mysql statement in there... Dim strSQL As String 'build sql up strSQL = "SELECT Contracts.[Contract Number]..... If GetEst() <> "" Then strSQL = strSQL & " A.... If GetCounty() <> "" Then...

Hi fella, Yep I'm already quite confident with vb coding the mysql line, just it's alot easier using the query box. Did alot ages ago with php and mysql.. very similar :-) Will give it a go and see what happens cheers Steve

Wouldn't this then show up all NULL values even when there is a value in the function ? I only want NULL values to show when nothing is in the search box.. Proper stumped :-! Thanks for all the help mind :-)

yep spot on m8.. I did try putting something like this in the Criteria but it didn't work... IIf(SearchFun()="*",Is Null,Like SearchFun()) Thanks Steve

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...

Thanks guys.. Ii ended up using [textbox] Like "H*" but is a bit of a pain as I have 31 boxes to do. Steve

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

That got it :-) fantastic !!! top man George.. thank you very much :-)

its coming out like... thanks

hmm must be doing something wrong.. I'm I using the function correctly ? I've tried using "*" and "'*'" and " LIKE '*'" but still it doesnt list anything.. but if it use's something like "Staff" it then lists all employee's who are in the department called 'Staff' thanks again for the help...

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...

Your a clever man :-) tis working now.. thank you so much ! onward and forward now !.. lol

ahh.. so recordcount holds the position of the record its currently on ? not the total number of records... sounds like a plan :-) going to see THANK YOU..

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...

ok.. getting there.. lol maybe ! As you can see its a continuous form but its only running the function once that I wrote that populates the boxes. These are unbound boxes. Any one got a fix for this ?

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...