Search results for query: *

Greetings! I have a table where names are stored in mixed case. I also have a lookup form where the user can type in a name for which to search, this in turn drives a query that populates a result form. In order to eliminate case from the equation, I'd like to convert everything to uppercase...

Greetings! I have a form based on a table (CallDetails) which includes a column called Area. This column is bound to a text box on the form for display purposes. The text box is visible but not enabled since it is not a user enterable field. The form has a combo box (CustSelect) on it that...

Greetings! Apologies in advance for the long post, but it's a complex problem. I'm writing a collection management module. It makes use of the following tables: tblCallMstr CollectID, CustomerID, Comments, Status tblCallDetl CollectID, CallID, CallDate, Comments, NextCallDate...

Greetings! I'm working on a salemsan activity tracking database. The users want to group all activity they enter during a single editing session into a batch. To do that, I added code to my form's ON-OPEN event that looks up the largest existing batch number and adds one to it, as follows...

Greetings! I'm working on an all-Access 2002 application (no SQL Server or anything like that). Occasionally I'll get the following error when Access tries to save my data: "The Microsoft jet database engine stopped the process because you and another user are attempting to change the...

Greetings! I have a database that tracks salesman daily activities, ie, calling on customers. tblMaster holds information about one salesman and day tblDetail holds information about each customer call that ocurred on a given day. tblSalesman holds salesman information tblCustomer holds...

Greetings! I currently have a table for salesman call tracking as follows: tblMaster MasterID autonumber (unique ID) SalemanID longint (FK to salesman table) CallDate date (the date the call was made) <other info fields> I have a no-duplicates index on MasterID, I have duplicates-ok...

Greetings! I have a database that logs salesman activity by date. tblActMaster holds one record for each salesman / date combination, including the salesman name and the date. tblActDetail holds one record for each customer call for a given salesman and date. For this report we only need...