Search results

acAnywhere did it :D the pointer points to the record, looking to move to the top

thanks, but it still doesnt work but now the text box thats based on strResult = [Title] Like '*hat*' hat being what i searched i have a title called 'enigma of the hat' so it should have pointed to that

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

2003 me thinks

so no one wants to help me? :( more or less got it running with a .FindFirst, but need to refine for like matches

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

thanks! made the changes and now it works a treat! cheers :D

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

thats a very good point thanks i'll tidy my code up :)

ok then FINALLY w00t done it If DCount("[Date] & [Period]", "tblRIC1Bookings", "[Date] = #" & [Date] & "# AND [Period] = " & [Period] & " ") = 0 Then MsgBox ("This booking is acceptable") DoCmd.GoToRecord , , acNewRec ElseIf DCount("[Date] & [Period]", "tblRIC1Bookings", "[Date] = #" &...

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!

thats odd cos it did the number of weekdays for me no problem

hey thanks everyone for your replies i was just coming back here to ask something else it was funnish to see the person above suggest DCount, cos thats what im lookin at right now it looks the best way really, normalisation, tho i dont really understand it is pretty important and its all one...

you make up your own key so that only you can get onto the network ;) mines pretty simple but memorable lol basically its not needed, but otherwise people can get onto your network, if you had a key theyd need to enter it to be able to get onto your network and they wouldnt know what it was but...

think this is meant to be about access but if you go into the properties of your wireless network you can change security settings etc think WPA most secure, but if you want to go on DS wifi (you may not) you'll have to use WEP, which is less secure ;)

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

ok thanks will think about how to do that ;) cheers

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

i know this is gonna be a bit of a bump and may annoy some people, sorry but i have to say this just helped me so much on something id spent a ridiculous amount of time trying to do and so Thanks :D

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