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...

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...

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...

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?

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.

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...

Hi Folks Is there a way to have a Combo Box select data from two different tables depending on the status of a check box? I have two tables - Company Drivers and Contract Drivers. If the check box is clicked, I would like the Combo Box to select data from Contract Drivers and vice versa. At...

How do I refresh data in my form after a delete action ? I have tried using REQUERY after delete but it does not work. The records are not visible in the form unless I exit the form. My code is as follows : ElseIf addTransactionYesNo = 7 Then 'If NO...

I have a form with 3 sub-forms from which the user selects informatin to be inserted to the main form. My problem is that everytime, focus is transferred to any of the sub-forms, data is automatically saved to the table (this is a bound form). I only want the data to be saved when the user...

In the code below, how do I identify the name of the current control in the loop ? There are a couple of fields in the form that can be left blank. I would like to check if the blank controls are these fields before popping the message. For Each ctl In frm.Controls...