Search results

the ControlSource has a command function (=[SearchResults].[column](17)) not bound to text or number...

i tried it also John, i tried also Auto but still it wont appear. i refresh everything, i saved, i compact and repair.

Hello everyone, I have a problem regarding the thousand (number) separator or the "comma" in my Form. I already tried Standard, Currency, Fixed but still the number in thousand looks like this - 12345.67 , i want it to be 12,346 (round off). I even tried replacing Standard in the Property...

whats the opposite of speedsolving anyway? because i cant solve rubiks cube in 1 day, LOL... welcome aboard penfold!

welcome aboard Bill! your life is truly amazing! youre not alone with your work. people here are amazing, they will surely help you. good luck Bill and enjoy your stay! :)

welcome Steve! we're on the same boat - new to Access, but surely we are on the right place. :D

wow thats great. another person here is willing to help others. welcome aboard sundance!

for sure you will. im also new to Access and this forum helped me do my job with ease. moderators here are friendly, as well as the members who are willing to help. welcome aboard! :D

thank you so much John. will try to apply this in my DB.

i have a database that requires money conversion. for example, everything is in USD, then there is a button for GBP then every calculation or input will be converted into GBP rate. default right now is USD. is this possible? if yes, how? Thanks. :)

yes thats my problem. i read in an article about Access on how to speed up its processess, it says there that instead of having the calculation in the Table put it in the Query, so I tested it. but i guess the speed is the same. thats my problem now. whenever i press a key or a letter while...

maybe because of the calculation? not sure though. your database sample has no calculation (i guess) - its mainly for searching only but though it doesnt have it even appears the CALCULATING... i made some testing and came up a conclusion that the LIKE (in query) make it slower. thanks for...

John, again, im having a problem with your database :o ... i posted a problem about database lagging or slowing down in searching an item ( http://www.access-programmers.co.uk/forums/showthread.php?p=1197259#post1197259 ) but no one replied yet. whenever i search for an item using your database...

congrats Bob though we havent had the chance to interact with each other about Access since im new to Access and to this forum but to think all the posts, the people who thanked you, the contribution you made is really an achievement that no one can take it away from you and something youll be...

i transfered the calculations in the query instead in the table because i thought the calculations in the table is the problem, and placing the calculation in the query will end up the blinking while searching BUT I WAS WRONG. calculation whether in Table or Query still the blinking is...

John, YOU are the BEST. i dont know how to thank you. :cool:

i am using this database sample by John Big Booty : http://www.access-programmers.co.uk/forums/showthread.php?t=188663 i need help on how to create report/s in this sample. i created a report template already (with a command button) but whenever i click the report/print button everything...

thanks Dave and Gemma (your dog, wink)... i cant still figure this out but will try to make this run. sorry if i cant share or interact ideas about programming or even MS-Access because im just new with this stuff.

thanks John. i tried your sample several times and i believe you are right, it really needs a new approach... sigh *** :(

thanks a lot John. its my pleasure to follow you here because i could get some ideas from you. i hope ill get this suggestion of yours in a month, haha... wish me luck dude!