Search results for query: *

I removed the primary keys. I know this sounds complicated but what I basically need is to check if a record exists if it does have the option to go to record and edit if it doesn't create new record.

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 really need help. I am creating a query for every location, then I create a chart for every query. I would like to skip the query part, and be able to chart my table grouped by location. I read somewhere that it is possible to have multiple charts in one chart space. Please help! I need...

The location would basically be the title of the chart. The date X axis and MPY y axis. I need a line or bar graph for each location. Thanks for your help.

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

It worked, thank you so much! I triend Where LineName = '" & Me!LineName & "'

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

It worked! I figured out the code. My form now adds a checkmark to my yes/no field with the onchange event of my text box. Thank you guys for helping.

You guys are on the right track. I just think I am asking for something impossible. I did however come up with another idea. I am afraid I will need your help. I don't do much programming. Here it goes. I decided to add a new field on my detail table and make it a (yes/no) field. Now...

That is what I am trying to do. I want the record flagged or font color changed to distinguish an added record from one that has not been added.

I have two tables. Detail table and treatment table. The form is a data entry form for the treatment table. The detail table is basically a template so-to-speak. I have one combo box which row source is from a field on the detail table. When I select a record from the combo box drop down...

What I am basically trying to do is to flag the records on the detail table to keep track of which ones I have changed. I hope this helps.

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