Search results

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?

Any ideas, anyone? Thanks.

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

Sweet, thanks.

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

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

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?

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

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

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 :-)

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

Thanks guys.

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

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?

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

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.

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