Search results

  1. K

    search all field in a record

    The database contains many resumes. The way it's been set up is that for every possible section of a resume there has been a field created. There's probably about 80 fields. A skill like AutoCAD could be under one of the experience fields, schooling fields, classes taken fields, or notes...
  2. K

    search all field in a record

    I'm trying to set up a query to search every field in a record. There are many field! Can I write a module that does this? I don't really know any VB, but I would think somehting like: Dim F as Field; RS and RecordSet Dim Str as String For Each F in RS find Str in F End For Exit Does...
  3. K

    autofill entries in sub form from previous record

    I'm creating a form to ease the data entry process. I have three main fields: project engineer, and equipment. For every project there are many engineers and for every engineer there are many pieces of equipment. Each engineer in the project will have very similar experience in equipmnet...
  4. K

    How do i get the report header to show up on every page?

    I'm still new at this, but I think the report header is designed to only show up at the beginning of the report. The page header is for info you want on every page. You should copy what is in the report header and paste it into the page header. It should then show up on every page. Kenneth
  5. K

    combo box selection to update second box

    That worked great! Thank you very much! I want the form to do one more thing. As you chose an item in the combobox and the second combobox requeries, I also want the form to go to the first record that matches that info in the field. Can I do this during the same AfterUpdate event? Kenneth...
  6. K

    combo box selection to update second box

    I've read some topics similar to this, but still can't figure it out. I have two combo boxes. The first is general and the second is more specific and based on the first. I would like to be able to choose an item on the first combo box and it limit the selection choses on the second box. I...
  7. K

    Manipulating Table Fields in a Form?

    Rip, if you don't mind a little advice from a junior member I have a suggestion that would ease and quicken your data entry. I would set up the database as Kevin suggested with the three tables. This allows for even more growth and more powerful updating and querying. I think the secret then...
  8. K

    button to delete records

    That's what I needed to know. Thank you!
  9. K

    button to delete records

    I've created a form for updating a list of engineers. (This list is used on another form so that spelling of engineers names are always consistent.) On the form there are two buttons. One for adding a new engineer and the other for deleting one. However, when the user deletes an engineer from...
  10. K

    Need automatic entry into certain field of form.

    I figured it out. Thanks for your help!!
  11. K

    Need automatic entry into certain field of form.

    This article was exactly what I needed. It fills in all the fields except those that are combo boxes. Do you know why this might be? Thank you so much for your help.
  12. K

    Need automatic entry into certain field of form.

    I'm an intern who is very new to access and even newer to VB. I have created a form to enter main project information and then created a form to imput specific engineers information for the project. For one project there will be many engineers with similar information, but not the same. I...
Back
Top Bottom