General

Automotive database template.
The Sample database for service call management includes sales tax on both parts and labor. Need help on designing sales tax on ONLY parts when creating an invoice and workorder, there is not supposed to be sales tax on labor. ... 2 Apr 2010 03:53

Convert Text "00:00:00:00" to time format in Access 2007
I have an application that uses a stopwatch to capture time on various events. The stopwatch time is stored as a text file, which I would like to convert to a time format. The text value is "00:00:00:00" which needs to be converted to "dd:hh:nn:ss." I've tried just about every method I can find with no luck ... 2 Apr 2010 03:53

why is it saying program has expired when i just downloaded
I just downloaded free trial micrsoft access 2007 .. then when i opened the file .. it says This program wiill expire on 31 Oct 2002 .. we are in 2010 ?? It wont let me open file as it says its expired.. same thing happened yday!! Please help.. need urgently for coursework Thankyou ... 2 Apr 2010 03:53

Multiple TransferText to the same File - Need to Append not Overwrite
On Access 2003: I have a multiple tables that need to export its data on a text (fixed width) file. I tried the transfertext macro and the following VB but they overwrite each other's export. DoCmd.TransferText (acExportMerge), "MASTER_DELIVERY", "0001_MASTER_DELIVERY", "C:\Data\testouput.txt", No DoCmd... 2 Apr 2010 03:53

forwording email with only my email address
when forwording email-how can I send it with my email address only, when I get one that was forworded to me? ... 2 Apr 2010 02:49

Remove Single Quote
I have a listbox on a AC2003 form. I want to perform the following DLookup based on one of the columns/row in the single select listbox. I works great until the target table column contains a single quote. How do I resolve this situation? DLookup("Contents", "OutlookInbox", "Subject = '" & Me.List28.Column... 2 Apr 2010 02:49

copy and paste command
Does anyone have any ideas why all of a sudden when selecting copy or ctrl+C and then trying to right mouse click or ctrl-X to a field in access that the paste feature doesn't work? We use Access 2003 and 2007 and have the same issue on both programs. Thanks for any direction you can provide. ... 2 Apr 2010 02:49

A Question for Mr. Jerry Whittle
That worked perfectly! Thank you for honoring me by responding. "Jerry Whittle" wrote: I'm honored! SELECT Tasha.lngzSKU, Min(Tasha.blnFish) AS MinOfblnFish, Min(Tasha.blnMilk) AS MinOfblnMilk, Min(Tasha.[blnShelled(raw)]) AS [MinOfblnShelled(raw)], Min(Tasha.blnWheat) AS Min... 31 Mar 2010 12:08

Russian chart titles
Hi all I have a strange issue with one of our Access databases. We have a report which has Russian text on it, on all machines in Germany, UK, France etc this works ok. But a new employee who is Russian has just joined our company and on his Russian laptop, any reports with Chart Titles display the text as a... 2 Apr 2010 02:49

Open & Close Access Database Using Script
Using Access 2003: Is there a way to open and close access database using a script or a batch file? Please advise. Thank you. Brig ... 2 Apr 2010 02:49