Search results

try this thread http://www.access-programmers.co.uk/forums/showthread.php?t=125954

hello using this thread http://www.access-programmers.co.uk/forums/showthread.php?t=125954 i can send an address from access to open google maps and go to the location specified in one of my access fields BUT does anyone know how to do it using 'Live Search' located at http://local.live.com/...

thanks boblarson i'm familar with this method. i just thought if i could put it in a module i would only need to call it once. cheers anyway

I avoid modules like the plaque but now i need to use one. what i need to do is to force the cursor to the begining of each text field in my forms whether i enter the field using the tab or mouse control [i tried the options in the menu but its not what i need - its possible to enter the text...

thank you guys I was nearly there cheers

hi guys i think its a simple problem and i'm pretty sure it involes the MID, LEN, INSTR functions - but can I figure it out?? NO. my brain is turning to jelly. basically i have thousands of photographs {linked not embedded} in the format c:\Cemeteries\Cemetery Pictures\New Quay Cemetery...

problem solved (to my satifaction anyway) all i do is use the original VB link criteria which was associated with an onclick event on the secondary form and when i goto the linked record[s] on the main form, check that everything is OK on this form and then remove the filter with a command...

thanks ruralguy - i think i just needed pointing in the right direction. will give those two methods a go to see if i can do what i want.

hi not sure if this can be done? i have no problem linking 2 tables via forms so that if i pick a record in one form and close it i automatically go to the corrosponding record in another form. the problem i have is that when i run the link criteria event in one form it filters out all the...

thanks for making that clear Boblarson

found the answer but i'm not sure if I should feel stupid or not. basically upon entering text in the combo box i need to move into another field before i run the QBF. To this end i have changed the keypress event to setfocus on another field first then run the query. simple - but i have never...

one other problem I have noticed is that if I type another search criteria in my search form such as 'surname' then again the keypress event will not bring up the correct results. I am also running the QBF [Query by Form] event from another command using VB which prints the results. This is...

good reply but no thats not the answer thanks anyway!

Hi I have a search form which runs a query [QBF] where the results are displayed in another form. no problem However i am using a keypress down event to run the search. I need to search by the two fields 'grave number' and 'section'. 'grave number' is a text field and 'section' is a drop down...

thanks for the reply simon i shall try the code later

hi i've been using access for some time but i am in many respects still a begginner and this problem has me stumped. anyway the problem i have is this; i am trying the evaulation version of DBpix but i want to reference the image using an unbound test box [i think]. i only want to load the image...

i'm no expert but this is how mine works. on the last combo/text box on your main form page [before you want to go to the tabbs page] place a text box under this combo/text box [hidden] and set the 'on_got_focus' event property to set focus on the first combo/text box on the tabbs page. make...

wow fast reply ruralguy basically the short date field in access is dd/mm/yyyy BUT in the oracle datebase its been formated to dd/mm/yyyy tt:tt:tt [where t is the actual time]. i'm no expert in this but we cannot sort out the records that have date time that is 10 characters long and those...

hi short history; we are trying to migrate date from an oracle database via access but are having problems manipulating the data - we cannot copy it, paste it, make tables from queries [and if we do, we have an ODBC failure mid way through creating a table from a query]. obviously the back end...

hi the problem i have is that i cannot export a report which is more then 50mb big. this problem occurs when i try to save the report as either of the above. i can export the report and all records up to 50mb then the images and one subform which is within the report refuse to appear on the...