Search results

im beginning to realise that tables are the pond and forms are the fishing rods and queries are the bait

ok i had it working but im gettin a small error Run-time '3211': now and ive tried changing the locks of the form but it is still there.. im sure its something very minor.. can you see why this is happening??

yeah its working.. thank you bob

you legend.. let me give it a go..

Seasons Greetings to all.. I hope you didnt put on too much weight. The fog at Heathrow ensured I had a very stressful Christmas.. but thankfully it has gone for now. i have a question regarding choosing a report to open based on a combo list.. i have a field called jobtype.. this field will...

cheers.. that did sort it

hi.. just a quick question... i want my script to run if the value of txtjobdate is not empty.. im using this at the moment If Me.txtjobdate.Value <> "" Then it works when the textbox is not null.. but when it is null.. rather than ignore the script it tells me Run time error 94, invalid use...

thank you very much it worked like a charm

yes.. that did it.. the only thing now is the th and st and rd are missing.. is there any way to combine the above snippet i used in my previous post with this one so that it can add the appropriate rd' or nd.. to the day number?

ok... so are you saying that i will need an actual snippet of code on my form that alters the format of the date..?? if this is the case.. i am unable to write such a script..

there are many many posts on this.. but i cant seem to find one that converts the date to the format i want it.. i changed the format of the textbox to long date and it displays as follows.. 23 December 2006 also on one of my previous posts.. there was some formating i was given to add the...

i was told that i didnt need to store the string value day.. eg.. monday.. tuesday.. because access can retreive the day based on the date.. so... i have a textbox on my form that displays the date as follows.. 23/12/2006 i am basically creating a html email and at the moment i use the...

can i just say i actually know a lot about database design.. dependancies.. normalization... the conceptual and logical design stages.. decomposition, subtypes.. i studied advanced database module for 3 years.. not once did i use access.. its just the vb i need to get to grips with.

lol... oh ant.. where would you be without these forums.. tut tut tut.. i should stick to websites..

Dim stLinkCriteria As String stLinkCriteria = "[jobref]=" & "'" & Me![QuickSearch].Column(0) & "'" DoCmd.OpenForm "all", , , stLinkCriteria this worked..i thought about using the linkcriteria... i really did.. thank you for pouring that bucket of cold water around my face..

ok.. well i have never been too sure about the commas and the syntax of this statement so i might aswell ask now... do i have to lay this sentence out differently if the value is a text? DoCmd.OpenForm "showform", , , "[jobref] = " & Me![QuickSearch].Column(0)

a simple sample of my problem

the user searches records and they are filtered.. http://www.londonheathrowcars.com/searchform.jpg http://www.londonheathrowcars.com/searchquery.jpg and when they double click i want the record to open in this form.. http://www.londonheathrowcars.com/showform.jpg...

the website picture is working i mean.. the actual problem still persists.. can anybody give me some useful advice regarding filter form default values?

i think its working now