Search results

hi, im making a search, got exact to work using this tried to do one using like, like this but it doesnt work, set up the text box crit, just to see what result was coming out as and it says false does anyone know whats going wrong or how you can use the like operator with the findrecord...

ive spent hours looking into searches and searching here for stuff and found some useful stuff, but still in a bit of a mess like well, i have a search form (well 4, but theyre identical basically ;)) and it searches the table the form is based on for stuff, the user selects the field they want...

im not sure what exactly is the problem here its based on a school library system So the form group are in various forms e.g 7HP, 12HP, 7HP/HY, 12HP/HY well those 4 forms are what the Len is doing is extracting the year group of the student then the year goes into the next if statement when...

hey everyone working on a DCount and having probs on the criteria this is what i have atm, it's the criteria thats the problem, i just dont really get what it's meant to be i need to check whether the date and period entered have already been entered cheers this ones killing me!

hopefully this'll be a really easy thing that will be a bit embarrassing, bit quick anyway i have a button (on a form) and using the wizard have got it to add a new record and have a seperate update query for something and thought itd be handy if the button could run that query as well, so...

triple bookings *DCount question* im making a system and part of that system is the booking of the library 2 classes can be in the library at once i want a way where if a 3rd teacher tries to book a slot then theyll be told its not available if only one class was allowed itd be easy, by using...

so ive got a form that has a sub form (think thats it) and its linked to another table im trying to do an If statement (in vb) and i want to involve a field in the table that subform is on, but dont know how basically what the thing is is if the field in that child table = 2 Then MsgBox("Do not...

hey there i need help :) ok, so i have to work out week by week percentage uses i have a query that already finds the bookings in the week already, that works fine, but then i need to find the % use for that week, which is the count of the number of bookings in the week / 21 ive tried doing...

i have a table and im working on two fields one is the session part of day where you can only enter "Morning", "Afternoon" or "Evening" Then i have a cost field Morning and Afternoon both cost £12 Evening costs £15 when someone types in the part of day i want the price to come up automatically...

hello all this thing is really bugging me im trying to come up with a post code validation and i have tried dozens, which should have worked really, but just havent so wondering if you guys knew any examples of postcodes would be BN3 8JH BN41 8JH theyre the only two types that are bound to be...

well where to begin i'll start by saying i dont know much about queries, i know the basic stuff, but thats all ok, well i have 3 tables, one a booking table, one a customer table and one a table with costs there are 5 seperate prices and 2 months data and i need to total up for each month it...