Search results

  1. H

    Insert a default auto-number field

    I've got a call tracking system. I've got one table, Calls, that has a field Quote Number. In a separate table, Notes, I've got the field Quote Number and the field Notes. It's in a separate table because each Quote Number can have more than one Notes. The problem is that every entry in Calls...
  2. H

    Insert from form into two tables

    I've got two databases. The main one has a field, QuoteNum. The child one has a field, QuoteNum and a field, Notes. There can be more than one Notes for each QuoteNum which is why I split it into another table. I have a form from which the user enters the data. Is there a way to get the form...
  3. H

    Transfer data from one table to another?

    I've got a database with two fields on it - quote number and notes - that I want to split into its own table. Is there any way to move the data over so I don't have to copy/paste a hundred times? Many thanks.
  4. H

    Access Books?

    Hi. I'm trying to teach myself Access from a systems development-type point of view. Can anybody recommend any books I might start with? I've pretty much exhausted the online tutorials and they really aren't going into the depth that I have in mind. Thanks in advance! Holly
  5. H

    Record Count of Variable Input

    I don't know what I'm doing yet and maybe I'm going about this the wrong way. I'm trying to come up with a count of records meeting variable criteria. My code is: Sub TestGetInput() DoCmd.OpenForm "InquireWithin", acNormal Dim TrackingDB As Object Dim TrackingFields As Object...
  6. H

    Entering data into table based on list

    First: I'm trying to teach myself Access so I don't yet know what I'm doing. I have a table which is a log of telephone calls. (CallLogTable.) One of the fields is CallType. I want the field CallType to be populated from a list of possible call types and I've made a separate table of the...
  7. H

    Adding new record from form

    I am extremely new and trying to teach myself Access. I've created a form called New Call with several fields and added a button that says, "New Record." I thought I could just do a macro to get the form to blank out and accept input when the user hit the button but there's no method on the list...
  8. H

    Hi from Austin, Texas

    I'm really new to Access and I need a lot of help!
Back
Top Bottom