Search results for query: *

I created a database for data entry. I have selected three fields as primary keys to avoid duplicates. These fields are [Month], [Lease], and [Amount]. For every month I enter an amount for a lease with a data entry form, which opens in add mode. I have a text box for the month and I select...

I have a query that groups records on a table by the location field. How can I create multiple charts from this query in one report. This the example of the queries result. Location Date MPY A-16 5/1/2003 5 A-16 3/1/2003 2 A-16 4/1/2003 5 A-13 6/1/2003...

I am using the following code to select a record from a combo box, but when I select a record with text that ends or contains quotes I get a syntax error. DetailTB.Open "Update Detail set [added]='1' Where LineName = """ & Me!LineName & """" Example: #19 B-6-11 Lateral 8" causes the following...

A form is populated with fields of a selected record from another table. I would like to mark the record by changing the font color to keep track of which records have been selected and which ones have not. I select the records through a combo box. My form has 6 controls. All of them are...