Search results

  1. I

    Update Query based on a separate Table

    Hi all, This is quite a basic question and I'm sure that it has been posted here some time ago, although I couldn't find it on using the search. I want to update a field in one table "FieldA" using an update query. I want the update to be based on matching Field B in the updated table, and...
  2. I

    Programmitically altering Graph Properties

    Hi Pat, I'm not sure whether you'll be able to help me out with this problem, but given your seniority on this forum, not to mention your expertise with most things Access, you're as good a person to hassle as any. I was wondering wherther you're familiar with MS Graphs and programmatically...
  3. I

    Variable X axis on a Chart

    Hello, Would anyone know whether it's possible to create a Chart for a form in ACCESS whose X-axes varies depending on the value selected in a Combo Box. The Combo Box shall contain entries that represent fields in the query that serves as the RowSource for that Graph. So for example, suppose...
  4. I

    Automating common tasks on access

    Actually, this has nothing to do with automating tasks, I just posted the subject because I notice certain topics like "Dlookup" aren't getting many views. There may be a good reason for this, as there are a lot of posts on this function. Still, can some of you browse over my earlier Sub that...
  5. I

    DLookup in VB Conditional Statements.

    Greetings, I am working with a data-entry form for my database. On this form, I would like to search a table in my DB with the current number entered in a textbox named txtEmpID. If the number is not found in the table, then the event will display a message telling the user to enter a valid...
  6. I

    Filtering Duplicate records on a main form

    I will try and be as concise as possible. I'm not sure how trivial a problem this is, but I haven't been able to find a solution on the internet regarding this issue. The problem: I have a main form and sub form placed on two separate tabs. The form displays information about a particular...
  7. I

    Follow-Up to previous post...

    Greetings, I am just posting a follow-up on my previous post on designing functional forms. Telling by the lack of replies, my original question may have been long winded and tedious. Let me try to narrow my question and make it more concise. In two tables connected by a one-one field...
  8. I

    Difficulties in designing functional forms and tables...

    Hi, I am a newbie at Access and am basically designing my first database. This database is for a short term project and is designed to track the attendance of employees at acompany. Here is a brief description of the tables and forms in question. EmployeeInformation - this table stores...
Back
Top Bottom