Search results

Hi guys, Thanks for the help. I finally managed to get it right using DoCmd.SearchForRecord acActiveDataObject, , acFirst, "[CaseNo] = '" & Me.FindCase.Column(0) & "' AND [FIPS] = '" & Me.FindCase.Column(1) & "'" I forgot to mention that there are two columns in the combobox, after I added...

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

Thanks for responding. I don't think a regular table with messages will work because the fields are all dates that get filled in as the project progresses so it won't really be possible to link the two tables explicitly through a query. A lookup table might work, I've never used them before so...

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

So the new form would be used to set the criteria in the query and save the query as well so that when I close the database and open the word document the correct data will show up. I guess that would work but I've never used a form to update query criteria, are there any tricks to it?

Well I currently have it set up for the mail merge to pull data from a select query. But this means the person doing the mail merge has to open the query in design view and type in the case number under the criteria to get the correct dataset for the mail merge. I would like to get away from...

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 managed to get the cascading unbound combo boxes to work correctly so someone can look up the city's ID. Now I would like to be able to click a command button to take the value from the last combo box (city ID#) and insert it into the subform that shows what city ID#s are linked to the project...

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