Search results

  1. M

    Validating a date from another date in another table

    Thank you for your reply. I am not able to open it. I was using office 2007. Looks like you used some other version and saved. If you can save it in lower version and send me back, would be great. Thanks
  2. M

    Validating a date from another date in another table

    Thank you Sir. You did it using functions in module. Thanks for this. I will understand it. But it is working. Thanks again
  3. M

    Validating a date from another date in another table

    Thank you for response Sir. Yes, you are correct, it is one to many relationship. I dont want to check things in sub forms. I want to check things while entering in separate forms or in table. Like we do record validation. The moment, we leave the record, alert comes. Or if it will be on...
  4. M

    Validating a date from another date in another table

    Hello All Greetings !! I have one ms access database which has two tables. One table name is Baseline. Second Table name is Followup. Both table has unique key named pid. Both table has one to one relationship set in database. In the baseline table, there is a date field named dor. In the...
  5. M

    counting multiple columns in a query

    Hi Thanks for your mail. I never worked on crosstab query using Access. If you can help me in my query, would be grateful. Thanks and Regards Manoj
  6. M

    counting multiple columns in a query

    Dear Listers I attached my query in image file. Please see. I think MS Word table is not supported here. Thanks Manoj
  7. M

    counting multiple columns in a query

    Student ID Command over subject Teaching Subject Explaining things Pedagogy Methods Solicited_Participation_Class 1 Good Average Bad Good Bad 2 Bad Average...
  8. M

    Duplicate finding in table

    Hello All In a table, where participantid is set as primary key, in this table there are two more fields, Name and Organisation. However, in a table , participantid takes a different value for a different records. But my query is, Even for a different participantid, I want to check...
  9. M

    showing , hiding fields based on previous entry

    Thanks to all It Works. May I ask another query here in this thread. In a table, where participantid is set as primary key, in this table there are two more fields, Name and Organisation. However, in a table , participantid takes a different value for a different records. But my...
  10. M

    showing , hiding fields based on previous entry

    Hello I am using Microsoft Access 2010. I have a form, having following fields Nationality, Combo box, Options are Indian/foreign State: With list of States in India. What I want is, when data entry operator , select, Foreign, State field automatically hides. And when data entry operator ...
  11. M

    MS access setting relationship and bound column

    Dear Sir I have three tables. Table 1: Group Field 1: Group Text field ( Primary key) Field 2: Group Description Text field Field 3: Uidgroup( Autonumber) Table 2: Subgroup Text field Field 1: Group ( I want to bound this column to Table 1's Group field that is column 1) I have...
  12. M

    Searchable form and export in to excel

    I have a table having fields, Group, Subgroup, Emails. I want to make a searchable form that asks user to select Group and select sub group. And click on some Export button , to export the results in to excel file. As per my data in table, There are some subgroups in group and many emails in...
  13. M

    MS Access Mixed points

    Dear Sir Greetings. I have some MS Access points. I am using MS ACCESS 2010. I have two tables. One is Group and another is MasterEmail Table Group has following fields Field Name Data Type Group Text(Primary key, There can be only one...
Back
Top Bottom