autocorrect is going crazy!

  • Thread starter Thread starter Ladi
  • Start date Start date
L

Ladi

I am facing this trouble becouse the template on MS-Access named "Services
Call Management" has a bug.
They have not prevent the caos when a customer returns and you add the same
customer on Customers table each time he returns and the same customer gets
different IDs.
I need to make a bill for every time the customer picks up the PCs repaired.

To prevent all this I thought it would be good to generate a code unifying
[CustomerID] & "-" & [DateReceived] in a form with results and it returns
something like this
24-3/11/4
while when I search the combo is populated with these values
24-03/11/04
what can I do in order to avoid this trouble?

HELP!

Ladi
 
At best, AutoCorrect is tedious. Most developers I know turn it off because
of all the problems it can cause.

To avoid adding so many duplicates, force a lookup of the existing customer
first by not using the new record items in the menu and making a new record
button on the form, which first opens a search form and forces the user to
look for the existing customer. A sample search form is at:

http://www.datastrat.com/Download/Search2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top