Recent content by crossy5575

That is really nicely explained, many thanks. Simon

please see attached database; from the first table student 1 got 92 in their Maths exam, from table2 this would be between 100 and 80 thus need to return a grade "A"

Hi all i have a table with player id, name and grade i have table2 with id, group, max, min where grade is a,b,c,d and the max min corresponds with the boundaries of that grade. how do i make a query that does the equivalent of a match excel function to work out how each student can be...

I have a form that i created based on a query. The form is a simple data entry form, name address etc. I want to copy that form and change the surname textbox to a combo box which will then return those records for that individual. Will this mean creating a query to filter the records and...

JHB, Loving your work! Many thanks S

Hi all I have a simple db with a table (table1) with fields ID and name. If i create a split form i can create a form where i can select a record from the bottom split, and it shows the details in the mainform. How do i do this with a mainform (table2) and subform (table2sub) still using the...

Just wanted to say I solved it. I created a 3 tier array where the Array(x1,x2,x3) x1 gave me the month, x2 gave me the date, and x3 gave me the information. thanks for your help

Will give it a go Plog thanks - it will work for this bit, however i might be in trouble trying to get an array into an array later! will let you know how i go! Simon

This is the bit i meant ... For cc = 1 To 12 'get number of days in each of the 3 months that we are looking at' xroup = "m" & cc & "days" Set xroup = DateDiff("d", firstdate, DateAdd("m", cc, firstdate)) dd = dd +...

Thanks yes it will need an array, but it will also need a variable array. with variable array names like i need for just simple variable below. for I=1 to 12 xroup=me("m" & I & "days") ... ... next i will create the declared variable m1days, m2days, m3days etc.. I then need to...

Hi there, following on from a previous thread i am trying to have a number of temporary variables simultaneously. This use would be take a concatenated string and make it a variable within a loop Dim m1days As Integer Dim m2days As Integer Dim m3days As Integer in this case - xroup = "m" &...

Thanks Plog, changed it to a query rather than SQL, just adds another component which i wanted to keep to a minimum. never mind! thanks for your help Simon

sorry i dont quite know what you mean by that? i thought the query def was the strsql?

Hi there, I have created a query in VBA to find a max id number from which i can then do 'things' I am getting a runtime error stating the field is too small to accept the amount of data Public Function holquery(findx As Integer) Dim strSQL As String Dim db As DAO.Database Dim rs As...

Reallly appreciate your patience with this, thank you. I want to populate myha(i,2) with with a letter (relating to the holiday type the person is taking), where myha(i,0) will be date over a quarter (i=0 to 80) having populated this i then need it to populate myhb(i,2) for the 2nd employee...