This could be the result of your Outlook settings. Open Outlook help, select the Index tab, and search for "meeting" (no quotes when you type). Scan through the list to find "troubleshoot meetings", and you'll see the following entry that when expanded provides the following...
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...
Another thing you could do is in your on exit event include the following code:
Me.Filter = ""
Me.FilterOn = False
It wouldn't fix the problem necessarily, but whenever the form was closed it would clear the filter so you shouldn't have to go into design mode to clear it. In...
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...
Sorry for not replying sooner, I've been working on other projects for the last month and haven't kept up with the forum.
To answer your question, the fields on the pop-up search criteria form should be unbound fields. They're not being used for data entry, they're just to specify your search...
If I understand correctly, you've got another form that's actually allowing insertion and editing of your customer data. You either want to enhance this form to support lookups, or create an entirely new form that does lookups.
Let's assume you want to enhance your entry form. The following...
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...
I know that a combo box will allow you to type values that do not exist in the pre-defined list from your NAMES table if you have the LimitToList property set to no, but I don't know of any way to have those new names written back to the table. A way may exist, but I've never done it that way...
Thanks for the reply!
I thought each user would have their own instance of the DSMBatch variable, but maybe I'm wrong. Here's the situation. The database lives on a network file server, there's only one copy of the MDB file. Each user has a copy of Access installed on their PC, and they use...
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...
That's a very good idea - I should have thought of it! The team that's responsible for the business app has a test version set up for training, etc. What I could do is set up a time with them when I can have exclusive access to the test data, then link to the test version of the customer...
It would be possible to make a local copy of the customer master, but not practical. My app is a salesman activity tracking database. The salesman are constantly calling on new customers, and the new customers are all added to the customer master through the business management app. If I were...
Thanks for the ideas!
I'm not sure about the users, but I know in my testing I never have more than one form open at a time, and each table only has one form that allows editing. So I'm sure I'm not locking with myself that way.
According to help/about, I'm using Access 2002 (10.4302.4219)...
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...
Rudy:
Thanks for the tip! I'm not sure where I would enter the CREATE INDEX code you suggested. Is that something I would have to put in an event trigger as the application loads? I don't see anywhere on the table design page that would allow me to enter it.
Anyway, your tip gave me an idea...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.