Recent content by dubmunkey

do you mean this part: Comp = source.Fields("Award") i should have removed that from my code, it was left over from my first approach

Hi all, i have a bit of a bizarre one that im sure is possible but im missing a trick- basically i have to join the values of a table from this: Term Week Award Summer 3 jon for was helping raise charity money, Summer 3 lydia for getting top marks, into Term...

Hi all, i have a query which joins the email fields from a table-a table which has an email address for every teacher of a student in our school- up until a while ago this worked perfectly: and would get studentid | email 1234 | [art teacher email]; [biology teacher email] etc etc...

Hi all, just noticed the weirdest thing with a cross-tab ive created: background- corss tab is an appoinment matrix time slot as the row teacher as the column parent as the value essentially tells you which parent the teacher is seeing in any time slot... problem im getting is duplicate...

forgot to subscribe to thread

hi im using this vb code: Function MySplit(myfield,separator as string,index as long) if not isnull(myfield) then mysplit = split(myfield,separator)(index) else ' what value? 'mysplit = "XXX" end if End function to break up an address field which is separated by chr(13) & chr(10) - works...

just heard from someone else that this isn't possible- only through vb.. dubs

just heard from someone else that this isn't possible- only through vb.. dubs

Hi all, i have a main form with many subforms- each of which can have vearying lines of data... what i need to do is have the subforms grow or shrink accoridng to its contents like you can do with subreports but the can grow/can shrink properties dont seem to have any effect.. is there a way...

Hi all, im having trouble with an update query wher i need to update one field [class] of a table [txStudents] from an existing query Newfacility_Students where the StudentId in [txStudents] matches the StudentId in Newfacility_Students thought it would be simple enough UPDATE txStudents...

Hi ive set up a form which shows a number of subforms..the subforms are linked to the same table and when entries are added i need these to grow to shwo the new data... from what i remember this is possible (although me be thinking of a report) and have set them to grow on the form itself and...

Hi all, ive set up an access db which is linked to another access db- i need to be able to filter by form on the table linked to the othera ccess db- it allows me to on the original but not on the linked table giving me: is null is not null as the options- is this possible? if so what is...

Hi all, i have this query which utlises a vb function allowing you to filter a table or query by the value of a form drop down- works great! what i now need to do is do the same on a query which combines the same data with some user added data (all fields are the same) from another table- so...

ive seen it done in the past but dont have an example- it didnt involve and update query... dubs

Hi all, have used the wizard to take values for a table dropdown field from another table the table has surname forename and class all of which reside in another table... ive tried to set up the bound columns so when you select a surname from the drop down the other two fileds also...