Search results

I am using Access 2007 and have an issue I’m hoping you can help with. I have a form (frmSearchMain) with a combo box (cboSearchType) from which you choose a search type and a text box (txtSearchString) where you enter the search string and a button (btnSearch) that runs a query and opens a...

I have two tables “tblCategories” and “tblParts” that I am using with a series of forms as listed below. 1. “frmSelectCategory” – This form has a combo box with a list of part types, and a command button. A part category is chosen from the combo box and when the command button is clicked it...

Help with Incrementing a Custom Formatted Unique Number I have a database with a table "tblCAPARMain" in which there are numerous fields some of which are: BaseNum FormatNum CAPAR# CAPARDate I also have a form "frmCAPARMain" in which I want to create a unique number for each record to be...

Hello, I am working on updating an Access 2003 database using Access 2007 and have a question about auto creating new records from a form. The current form (frmMainForm) includes the following fields and creates records in the table (tblMainTable) Inspection Date...