Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dalebeitz

    Issue with meeting requests

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

    Trouble adding computers to domain...

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

    Case Sensitive Query

    That did the trick! Thanks! Dale
  4. dalebeitz

    Case Sensitive 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...
  5. dalebeitz

    Filter on form (Access 97)

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

    Text Box not being refreshed

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

    How can I link a query with a form

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

    How can I link a query with a form

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

    Forms with both input values and queried data

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

    Updating Values in Combo Boxes

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

    Mysterious variable value reset

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

    Mysterious variable value reset

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

    Error 3197: record lock errors

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

    Error 3197: record lock errors

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

    Error 3197: record lock errors

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

    Error 3197: record lock errors

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

    "set" operators other than UNION

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

    Composite indexes

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

    Composite indexes

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

    Grouping with Dates

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

Part and Inventory Search

Back
Top