Search results

I'm trying to add an unbound combobox to locate records on my form. I am trying to use the DoCmd.Searchforrecord but I can't seem to figure out the correct syntax to use for a search on two fields. I have two primary keys, CaseNo and FIPS, since a case number can have multiple FIPS assigned to...

I could use some suggestions on how to set up part of my database. I have a table with about 21 fields to captures dates that activities were completed for each project. The dates are entered via a form. So for example: Field1 = Receive Date Field2 = Review Date Field3 = Returned results of...

I think this question (or something similar) has been answered before so if I'm repeating I apologize. I am trying to run a make-table query from the switchboard. The goal is for the query to pull data from about 6 different tables, make a new table and then for that table to be used in a Word...

I am trying to write the code for a command button to find a record in a table based on a selection in an unbound combo box and if the record is not found to add a record to the table. I've found code to do each action using separate buttons but I'd like to combine both actions with one button...

I am trying to build a database for my department to track our projects. Each project has a number. Each project will involve several different cities and each city can be affected by multiple projects. Each city has an ID number. So I have 3 tables so far: 01 _tbProjects – lists the...