Search results

  1. L

    "Find" command button in subform error

    I've found that it does work when the record in the main form has more than one related records in the subform, but it's unable to search past the record currently open in the main form. How do I find the code for just that button rather than the whole form?
  2. L

    "Find" command button in subform error

    Any ideas, anyone? Thanks.
  3. L

    "Find" command button in subform error

    Option Compare Database Private Sub Delete_Record_Contact_Click() On Error GoTo Err_Delete_Record_Contact_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 Exit_Delete_Record_Contact_Click: Exit Sub...
  4. L

    Filtering one field OR another field

    Sweet, thanks.
  5. L

    Filtering one field OR another field

    I've created a query which filters based on data in only one field, a checkbox, so the criteria is set to "Yes". How do I filter for data from the same field OR another field? I don't want the query to show only records where the checkbox for both fields is checked, but rather where one or the...
  6. L

    "Find" command button in subform error

    I've created a form which contains a subform, with a "Find" command button (among others) in both the "main" form and subform. It works fine in the main form but does not work in the subform - it simply doesn't find anything. The other command buttons in the subform, Save, Delete and Add, work...
  7. L

    Records that contain a certain word in a field (among other words)

    Thanks both. Yes, realizing putting the whole address in one field it was unwise... Tried Like " NY ", ", NY " and other variants but it finds nothing, strangely. Maybe it just doesn't recognize spaces?
  8. L

    Records that contain a certain word in a field (among other words)

    I have a database that includes an Address field, containing full addresses - street, number, city, state and country. I'm trying to create a query that will include only records that have a certain state in the Address field ie. NY. What's the syntax to filter for a full word among other text...
  9. L

    Combo Box hell

    Thanks. I think I'm unsure if there's a relationship between the other tables. Maybe this helps to explain the situation: In the Excel file which I imported to Access, I originally had a column for: Company Name Industry Focus Area 1 eg. Investments Focus Area 2 eg. Insurance Geography...
  10. L

    Combo Box hell

    Thanks. What about the relationships - do I need to establish relationships between the four "other" tables, or is it OK to have them all linking separately to the Companies table? Which will now have an AutoNumber as Primary Key :-)
  11. L

    Combo Box hell

    OK. Read up on normalization so I've made some changes. Instead of two tables, I now have 5: Companies Employees (ie. name, email address) Industry (which I want to be a Combo Box or List Box) Geography (which I want to be a Combo Box or List Box)) Focus (about 10 fields in this, all "X"s or...
  12. L

    Combo Box hell

    Thanks guys.
  13. L

    Combo Box hell

    Thanks. What's the benefit of having an AutoNumber as PrimaryKey rather than the CompanyName field? I have established a one-to-many relationship between the Companies Table and Employees Table - each record on the Employees Table must match a Company Name on the Companies Table. I don't have...
  14. L

    Combo Box hell

    I think I just figured out how to add Combo Boxes - using the Toolbox - but my fear is that I will have to enter the appropriate Industry entry each record manually, rather than just import directly from Excel. Is that right?
  15. L

    Combo Box hell

    I'm new to Access. I have a database with two tables - Companies, and Employees - by importing data from Excel. I've created a form including all the fields from both tables (Company Name is the primary key and I have established a one-to-many relationship). I'm trying to create a combo box...
  16. L

    2 tables better than 1?

    Thanks very much. In this case I'm sure there won't be any duplicate company names - in that case can I use the company name as the primary key? Obviously there are more than one employee per company, in the employee table.
  17. L

    2 tables better than 1?

    Bear with me, I'm new to Access... I'm creating a database of companies and 1 or 2 key contacts at those companies - started the process in Excel and ready to import into Access. Since I have multiple contacts for certain companies, the formatting of certain fields isn't good - what looks OK...
Back
Top Bottom