Recent content by vadharah

  1. V

    Employment Agency database small scale design Help

    most appreciated
  2. V

    Employment Agency database small scale design Help

    Hi Guys I want to design a database for an employment agency..Is it possible with Access?...... I just need a heads up if anyone knows any Templates advice and or suggestions. Thank you
  3. V

    Problem with DoCmd.close acReport

    Is it however possible to run a query then assign a value from the query or maybe a textbox to a filed on the report and then print...for instance DoCmd.OpenReport "tester", acViewPreview, , StrWhere Reports!tester!abc.Value = Forms!form1!test.Value DoCmd.Close acReport, "tester"...
  4. V

    Problem with DoCmd.close acReport

    lol...THANK U!...sometimes i just but wonder...
  5. V

    Problem with DoCmd.close acReport

    Hi guys im having problems with the following code i open a report in vba then after doing some operations to it would like to close it and save it but having problems. DoCmd.OpenReport "tester", acViewPreview, , StrWhere ........do something here...... DoCmd.Close acReport "tester"...
  6. V

    print all records

    Hi Guys, In a nutshell i have 3 tables Students - contains the main details e.g name, D.O.B, address, contact Sciences - contains 4 science subjects physics,chem,bio maths arts - contains 4 art subjects literature,history,politics,international studies for the last 2 tables each student...
  7. V

    How to create Admin and Limited User PASSWORD

    hi, How can i create an Adim password to enable the Admin profile to have global priorities and a second account (limited user) with acces to 'input' data only?
  8. V

    SELECT query in vba

    i have a similar error to the problem i was having above... my code is: str = "SELECT People.Name, People.[Ethnic Origin], People.Gender, People.DOB, People.Daytime, People.Mobile, People.Evening, People.Email, People.DIY FROM People WHERE People.DIY=Yes AND...
  9. V

    Only select records where checkbox has been TICKED

    Dinnisk Thank you for your response. I have tried what you suggested but still im getting records with unchecked subjects. Is there a way of specifying that if a subject-checkbox hasnt been checked then it wont appear in the results i.e. the results table ONLY contains records with ticks and if...
  10. V

    Only select records where checkbox has been TICKED

    Hello Guys, I have a form containing several checkboxes of subjects studied. when a user ticks a subject(s) on the click of a button i would like to run a query that selects students with ONLY the selected subjects. what i have so far is : SELECT Student.StudentID, Student.Name FROM Student...
  11. V

    Problem with apostrophe character in Seclect Query

    thank you bob!!....muc appreciated ...im learning new things by the day
  12. V

    Problem with apostrophe character in Seclect Query

    i have a select query which is now working fine thanx to your SUPPORT!! however within my WHERE clause i am comparing with the value "Don't Have" as text the query is: str = "SELECT student.MainContact, student.Add1, student.Add2 FROM student INNER JOIN gradesON student.studentID =...
  13. V

    SELECT query in vba

    Works perfectly!!...thank you
  14. V

    SELECT query in vba

    Thank you guys for your replies. 'grades' is a table.. i have tried this: Dim str As String Dim db As Database Dim Result As Recordset Set db = CurrentDb() str = "SELECT student.MainContact, student.Add1, student.Add2 FROM student INNER JOIN grades ON student.studentID...
  15. V

    SELECT query in vba

    Hi guys, i have the following query in which i want to search for students' Name and address..where the grade is equal to a value entered in a text box..as i do that i also want to check if the recordset is empty. Dim str As String Dim db As Database Dim Result as Recordset Set db =...
See more
Back
Top Bottom