Recent content by dalebeitz

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...

Thanks, Stussy! I was having the same problem as SyberWolf, and your solution works like a champ. Thanks for the post!

That did the trick! Thanks! Dale

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)...