Search results

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

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

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

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

hi, im wanting to reference a value of a dropdown which is already serving a function - the dopdown already has it's bound set to 3 but i want this new function to refercne the second column- im tyring: "Tutor = '" & Me.ComboStaff.Value(2) & "'" which isn't working- how do i reference the...

Hi i have a macro that runs a number of queries- each one assembling data- populating tables to finally make a master table of all the data i need- it runs about 8 queries in a row- works great except i get this message at each stage of the macro: you wont be able to undo the changes thois...

hi, every time i look in or shared area i see a new backup file of one of my mde's... junior school pastoral log_backup it seems every time i delete one a new on is there next time... what's causing this? is a user not logging out of the software properly or what? cheers greg

Hi all, i have an access db which uses a vb command to piece together data fields into an email which is sent via smtp, the problem ive recently encountered is that the mails are being truncated, they don't seem to truncate at the same number of characters, but after 17 lines... ive included...

Hi all, i have a report with an embedded subreport. both come from the same table- the main report use a distinct select to get studentid, examid, yearid. the subreport matches the studentid, examid, yearid with the main report and shows the subject and result values. therefore in theory by...

Hi all, an app an ex-colleague created produces an error message when i right click on a form field. It says: mircosoft access cant find the macro 'ucas' now the macro isn't there but i need to find out what is invoking this macro, there are no vb events programmed for the field so it's not...

Hi all, an app an ex-colleague created produces an error message when i right click on a form field. It says: mircosoft access cant find the macro 'ucas' now the macro isn't there but i need to find out what is invoking this macro, there are no vb events programmed for the field so it's not...

Hi all, after spending wweks perfecting a database which centres on the ability to email the contents of what you have just entered i find that our stirling IT dept haven't actually setup any of my intended users with outlook profiles and do not intend to. Therefore whenever they try and send...

Hi, i have a db which everyone uses which has started throwing up error messages whenever someone logs in: unsafe expressions not blocked.... despite setting my macro security to low when i log in as the user to test it i get the same message, looking at the macro security shows me it is set...

Hi all, i have an access database which is linked to a sql server table. Up until yesterday everything worked fine and anyone one of my 20 users could log in. Today they are getting these error messages: warning unsafe expressions and then sql state: 28000 sql server error: 18456 login...