Search results for query: *

I can't seem to get MouseWheelOFF to work. I have copied MouseHook.DLL into the folder where my MDB sits and the modMouseHook module into my MDB. I tried calling 'Turn the MouseWheel Off Dim blRet As Boolean blRet = MouseWheelOFF from a CommandButton as well as in the OnLoad Form...

Thanks, Stella for the explanation.

Hi Stella Gee.. It worked ! Where can I find the explanations of the functions CStr(), CDbl() etc? So, if I want my results in 2 decimals, I will have to divide the result by 100 instead of 1000. I don't quite get the logic. Thanks !

Hi Stella The formula gives me wierd answers which is consistent with the function that I tried to write myself : A B A-B Required Your formula Actual result result 36.4 36.45 -0.05 -0.050 -5.000 36.37 36.4 -0.03 -0.030...

Hi Jo That's precisely my problem, using the format property which rounds up my numbers which do not tally with my group total. As appears in my report e.g. Detail line 1 0.010 Detail line 2 0.000 Group total 0.011 because the actual calculated field results are 0.01042 0.00048...

I am trying to use a combination of str() and left() functions to display results of calculations in my reports without the system rounding the results but I get funny results. My problem is I may have for example 0.01042 and 0.00048 as detail lines. They total up as 0.01090 but I want to...

Dear PeachMelba We didn't go with Access' replication and sycronization coz we share the same opinion as yourself. Thank-you for your idea but it won't work for us as the branches are at small towns where broadband is not available. The servers at all the locations run on Linux. Will keep...

Dear Dan Have you tried using an SQL statement to do that ? DELETE * from TemporaryTable Dhanus

Hi Folks I have my application deployed at headquarters and 5 different branches. I need to send changes in data i.e. edited/new records back to headquarters. If anyone has a similar project, can you please share your methodology? At the moment, my plan is to disallow editing of records and...

Dear Folio12, Flyover789 & Jeff Thank-you all for your replies.

Does anyone know where the Export/Import Specification File is stored ? Can it be copied? My application is deployed at 5 different locations and I need to copy the file to all locations. Can I do this without having to go through the manual process at each location?

Thanks a mil, Bob ! I took the short-cut of turning AutoCorrect off and it worked !

THANK-YOU, p27br. It is certainly very helpful info.

Thanks, rjurgens It did speed things up :))

Hi Folks I have a split MDB, my tables are on the server and the application on the users' hard drive. On machines that are Pentium IIIs, it takes about one minute to load a form. Once opened however, the speed of data entry is ok. Pentium IVs take about 1/2 a minute. Is there a way to speed...

Hi Experts I have a problem with the Page Setup setting of my reports. Even though I set the Page orientation to Landscape and save it under Report Design, it will change to Portrait when the user prints it. Thank-you.

Thank-you, lupins-46. It worked !

Hi Experts I am exporting data from a query to a text file. My code is like this : vFileName = "filename_" & Format(Date, "ddmmyy") & Format(Time, "hhnnss") & ".asc DoCmd.TransferText acExportDelim, , "ExportDataToSAP", vFileName My output file looks like this : "PD",9/1/2004...

Dear Jeremy I used your method, changing it to use 2 different SELECT statements and it works ! Thank-you sooo much for teaching me a new trick !

THANK-YOU, Jeremy. I'm afraid, I can't join the two tables as they are rather different in structure. Can I use your function to select different tables then? I will have a go at it.