thank you

I have sql statement in access database to find records -3 fields ID, name, and Date. i use

SELECT ID,COUNT(name)AS CNT
FROM Table1
WHERE (((Table1.Date)=[Enter Date]
GROUP BY ID
HAVING COUNT(name)>1

now I want to find records < 1 - not sure of how to start to find these-any ideas- There are supposed to be 30 records each week added - sometimes people add too many records ( the statement above helps- but if they did not add record- do not know how to figure that) Thank you,

thank you

I have a C# form users use to enter hours worked, sick time , vacation. It is connected to access 2003 database. The form does not have a login- each person just selects last name from combo box and any secure data is not visible on form. is there a way I can display a current number of vacation hours, sick time left each week on form for each person. I recieved an excel sheet with total number of vacation hours and sick hours each user has for this year at present. When someone uses time it has to calculated and updated. I am uncertain of how of even how to start on this task. any ideas. I also have to have vacation time and sick time only available to user. no one else can view. thank you,

namespace Passing_Data
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

    private void button1\_Click(object sender, EventArgs e)
    {
        Form2 frm = new Form2(textBox1.Text);
        frm.Show();

    }

    private void Form1\_Load(object sender, EventArgs e)
    {

    }
}

}
FORM 2:
namespace Passing_Data
{
public partial class Form2 : Form
{
public Form2(String strTextBox)
{
InitializeComponent();
label1.Text = strTextBox;
}

    private void Form2\_Load(object sender, EventArgs e)
    {

    }

    private void comboBox1\_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
}

}

this code allows me to enter data in textbox on first form and hit button and see it displayed on second form in label. is there a way to enter data in textbos on first form and hit button and see data entered into combobox on second form? thank you

thank you

namespace example { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { } private void addEmployeeNumberToolStripMenuItem_Click(object sender, EventArgs e) { //this.comboBox1.Items.Add(textBox1.Text); } private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { } } Hello, I have a form with one combobox on it- and menu item: addEmployeeNumber. is there a way to click employeeNumber toolstrip menu and have a text box display and then once filled with data -it can be added to combobox- or another way- my code this.comboBox1. items. add ( textbox1.text); is not working the right way.

thank you

I have C#.net form bound to microsoft access database. form has two textboxes. database has one table with two fields. I want user to be able to open form and enter data into textboxes - click a button and have it entered in database. Is this possible- I know there is an insert command - but not sure how to implement. can you give me info or point me to any examples thank you

thank you- you are probaly right- thanks for help

Hello, I want to use the errorprovider control with checkboxes I have on a form. I know with a textbox: you can use something like if (textbox.text = <=0) errorprovider.seterror(textbox,"you must enter data"); but with a checkbox am unsure of how to use thank you

thank you it works

unfortunately this did not solve problem I have partNumber Date and Status I have tried Select partNumber,Date IIF(partNumber= 1011 and Date = #01/01/2006#,"OFF,ON) From table1 but still gettng errors-your sql statement is missing partNumber thank you

modified on Sunday, June 7, 2009 7:34 AM

yes you are correct

Hello, I have table in microsoft access with fields- partNumber, Date, Status. ( the status field always is one of two words - on or off can I write a iif statement in sql that says IIf ([partNumber = a certain Date]), the status will automatically display off for those records with that part number. I already have alot of records entered in database. I have tried and not used to writing IIf statements in sql- also wonder can you change a field that has data in it with a iif condition statement. thank you

Thank you for the information

Hello, I have 3 forms and 1 button on each one. (form1, form2, form3) how to code the buttons to go to each form. I know basically I have to create instance of form and also show and hide. but don't really understand. I tried writing form2 newOne = new Form2(); newOne.show(); this.hide(); I was able to click button from Form1 to Form2 but that was all - even when tried to modify. I must be not doing something. thank you