Search results

you still here Boblarson imparting your wisdom? what a hero! just what i wanted. i don't think i'll ever get those bloody quotes right! thank you very much

Hi I've been concentrating on GIS for the past 18 months so my database skills, simple as they are, have lapsed. i am trying to do a filter search. one box is number [ccc_ref_number] the other box is text [extra_ref]. it's simple really - i want to double click the record in the open form and i...

a bit rough i know but the code below ensures that on a live search in the txt search box i can type using spaces Private Sub txtSearch_Change() On Error GoTo Error_Trap Dim vSearchString As String vSearchString = Me.txtSearch.Text Me.txtSearch.Value = vSearchString ' the above 3 lines of...

can't seem to get the code you posted to work John Big Booty so i did a reverse solution. i inserted a _ for all the spaces in my text field. this did not work either for some reason. as soon as i typed a _ in the search box the live search field went blank. should the search filed work with a...

Thanks for that at least i know where to start to fix it.

hi i am using the live search example created here http://www.access-programmers.co.uk/...d.php?t=169417 the only problem i have is when i search in the form frmcustomer in the txtsearch field (criteria) i am unable to insert any spaces. so if i want to search for 'bob roberts' i can only...

thanks boblarson sorry i've been so long in replying. perhaps i'm lazy and we also have a lot of network problems at work. i've now done two macros which delete the linked tables then import them onto my local drive. it just saves me mucking about looking in different location for the actual...

Hello everyone i don't post much these days as I'm doing a lot of GIS work. however i still keep an access database. i have a lot of linked tables and would like to import the tables locally all in one go. i know i can do it one at a time but this is tedious and time consuming. anyone how would...

hi guys I had this problem once and had this solution posted to me. basically you have a form with 2 unbound boxes - 1 called 'addressline1' and the other called 'postcode' . this code you then stick behind a command button on the 'onclick' event: Private Sub cmdgetdirections_Click() 'Edit the...

one quick question what event button in access are you putting this code behind? thanks

outstanding I'll give that code a try soon! thanks

Hi I don't do much with access these days but I am doing a lot with mapinfo. see the link below to your problem. i'd be interested to see your solution. http://www.access-programmers.co.uk/forums/showthread.php?t=152225&highlight=call+shell

thanks KenHigg i deleted the combo box, re did it and it worked. the only thing i can think of is that orignally it was a text box that i converted to a combo box. i have now done it from the start as a combo box. thanks for all your help

check out this site. you might see something i did not http://support.microsoft.com/kb/209582 also http://www.access-programmers.co.uk/forums/showthread.php?t=107416 as far as i could figure out none of these fixes worked. perhaps i missed something?

i've cut the size and tables down but you can see how its supposed to work and i still get the same message which i click on a table name in the combo box thanks for looking

i've checked everthing i can think off but i have no "." in the events tab thanks anyway

as far as i can see the code does what i want it to do. when the form loads the combo box has a list of current table names within my database. this is what i want it to do. however when i click on one of the table names within the combo box i get the message microsoft access cannot find the...

i've found a few possible solutions 1] change the file type association in the folder type options - does'nt work 2] remove the spaces from the event procedure name - does'nt work i have no events typed into the combo box proprties. the code is tied to the on load event of the form itself...

hi guys i've copied and altered the code below to populate a combo box with table names. all works fine except when i click a table name in the combo box to select it i get the message microsoft access cannot find the macro "." Private Sub Form_Load() 'ValueList variable will store a...

this code will not work for my problem pat. I have similar code in one of my access database' and it passes on your criteria, [address, road name, town etc etc] to google maps or livemap and then opens them. the software i'm using is a standalone GIS MapInfo and a lot more complicated. it is not...