Search results

most appreciated

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

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

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

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

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

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?

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

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

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

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

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

Works perfectly!!...thank you

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

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

Splendid guys Thank you

hi i have a report based on a query. The resulting list always has 5 records for each ID number.. I want to have all 5 records from an ID number on a separate PAGE. Im printing a letter for each ID number to accompany the records thus do not want to mix the records.. Is this possible? Can...

Thanx for the reply Mike, The structures are different my idea was initially to create a form where a user specifies to search data from then i use the variable in my select Query. But then again im not sure how i will sort the fields' issue. Im still learn and guess the best way to do so is...

Thank you for the reply and advice guys! much appreciated

Auto Age Calculation when you think you getting the hag of access it goes wrong. I have a table with a field called DOB (Date of Birth) i have now added a new column called Age.. What i want to do is automatically calculate the Age (based on DOB) and keep it in this column..Is this possible...