Recent content by Dairy Farmer

What extension are you using for your backend? It should be ACCDB. If it is something else, change the code to reflect that. fs.CopyFile source & "*.accdb", str Also the file to backup must be in a folder DATA in the project folder: source = CurrentProject.Path & "\Data\"

Why not use median rather than average. It is more representative of the "average" as it tends to "ignore" those numbers that are way out. Now why Microsoft chose to not include this function that is used in Excel is a mystery. I think you could write a book on the functions in Excel that did...

How are you getting [SumElapsedTime] ? If the input fields are in Date/Time format why not use DateDiff("h",[SatrtDateTime],[EndDateTime])

You can get the computers time zone (GMT offset bias) from the registry Goto HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\TimeZoneInformation\Bias Use a simple read registry function to get the offset for that computer and use that to add or subtract the bias from the local time.

MoveSize - either via a Macro or via VBA. Look in the Help files it is fully explained.

This may not work for your application, but others searching this forum looking for a simple search function may find it usefull. A very simple way to do searches is to use combo boxes. These have "seach as you type". Type "D" and you go down the list to the start of the "D's". Next type "A"...

Something like Excel's networkdays? See http://www.access-programmers.co.uk/forums/showthread.php?t=37245

Not directly. First save the .mdb as accdb Once its an accdb you can make it an accde Package Solution (Developer) will make the accde an accdr if you want it to and bundle it up in an .msi installer file along with Runtime (if you want it to). Or there is an option for the person downloading...

You mentioned in your OP that you are running the app with Runtime07. Why keep going back to 03? Just keep developing in 07 and distributing the app as accdr or accde. The Package Solution Wizard can bundle up Runtime07 with the accdr, in the installer, for easy distribution.

I thought that Normalization meant dividing large tables into smaller tables and defining a relationship between them. Well if you take this example: Everything related to the invoice is in one table (InvNo, Date, Salesman...) Everything related to testing is in another table (InvNo, Tester...

Looking at the pic I would definatly split using something like the Invoice (something common but unique): Table1 Invoice No Date Table2 Invoice No Tester Table3 Invoice No Code for part number And so on

Here is something to get you started

Maybe the easiest way would be have a main form with a tab control. In the tab control are all the sections (forms) of the audit. The main form needs 2 fields: date and farm. Use linked fields between main for and tabed forms. The date field in the tabed forms are either not visible or are...

Updated: 30 Day Trial with Registration I just did a bit more work on the file: Fixed some of the comments in the code Fixed the imput masks that were not quite right Split the single Module into 4 modules. Easier to work out the code. Version needs to be between 0.0.1 and 9.9.9 (where version...

I use the Excel method only on testing or once off cases. I didn't mean that normilising the database should not be done. Sorry if my responce came off the wrong way.