Search results

  1. S

    Array recordset

    ta! dear both, thanks for the replies.. apols if my query was a bit garbled.. we were left in the lurch by a colleague who went on holiday without finishing his java data checking applet, so I had to come up with a quick solution.. we had an xml import into access which after a crosstab put...
  2. S

    Array recordset

    Hi all, I have a table with multiple records per individual.. I need to search through all of their results to flag up those in a query that do not match the approved list.. what is the best way to do this? I am trying a recordset loop but am struggling a bit... here is my code so far...
  3. S

    TransferSpreadsheet error

    Apologies if this has been asked before, I have searched on the site, but no luck so... with transferspreadsheet method you cannot overwrite an existing tab in an Excel worksheet, eg. worksheet has a tab called pupil_data if you export the data again from access a new tab is created called...
  4. S

    Percentile code - Module Collection Error

    discovery! found the problem! I now have a red face, the percentile table had average point score, rather than points score. problem solved many thanks for your postings.. apols again. John
  5. S

    Percentile code - Module Collection Error

    cheers! Hi Wayne, thanks for the reply, they are underscores - we link most db's to oracle and therefore we need to avoid using spaces. does that cause a problem in the code? the line which has the glitch is With rstPercentile .AddNew ![October_2003_English_Average_Points_Score] =...
  6. S

    Percentile code - Module Collection Error

    Hi everyone, not been posting for a while, but lo and behold upon my return to access I hit a problem! I am trying to run some code which I found on this site (very kind of the provider, many thanks) & am having problems making it work with my database.. I am getting an error "Item not in...
  7. S

    Ilf statement error

    quite agree! many thanks for the input, as for the field names, you are completely right, I wanted them changed, but this is a dbase which is not ours and cannot be changed by mere mortals in such establishments, perish the thought! luckily the table is small, only 100 records, and will not...
  8. S

    Ilf statement error

    hi, have been scratching my head about this and cannot get it to work I have some schools and when they submit their targets I need to show those schools that have not submitted their targets etc, the ilf statement below works perfectly except for where the field is empty, I have tried Is...
  9. S

    Display Data Horizontally

    tricky! hi, I know of a way to do this, will hunt out the code and post it for you.. if I have read your posting correctly, you are basically turning a table/query on its head with the data becoming the columns... it is quite tricky within access and as far as I know when I and a...
  10. S

    Multiselect listbox

    new code this code has always worked for me... (am certain it came from some kind soul on this msgboard about a yr ago!)
  11. S

    Help!!! Combo box follow-up..

    any use? not sure if this is exactly the answer you need, but can you not in the query builder for the combobox move the column "DoR Sub-Classification" to the first column, then put tthe bound column property to number 1... then the combobox is still linked to the correct field, but displays...
  12. S

    query using form to filter

    can you post the db onto the forum? J
  13. S

    Access Mail merge and SMS Text

    sms texting I am not sure about mailmerge, but as for sms texting it is possible, the sms tool would just use the access dbase as its datasource, therefore you would need a make table query to make a table with the columns the program would need.. I cannot remember the one I have used...
  14. S

    Preview vs printed report

    does this help? in vb code you can specify whether to print or preview a report.. so in the onclick event when you run the report, you can just put acprint rather than acpreview... I know this does not actually answer the query about how access conducts the process, but hope it helps...
  15. S

    If only 1 record then cannot delete

    is this any use? not sure of the syntax, but cant you use recordcount? i.e. if myform.recordset.recordcount < 1 then "do something" hth John
  16. S

    Set up help

    cut down the request.. no one is going to help you if you just list all the things you need to do.. try cutting down your requests and being more specific that you require and then people will be able to help you more.. otherwise people just think that you want them to write the db for you...
  17. S

    Search between dates

    link a new form to the button, the new form is based on a query.. in the said query put in the criteria box the between dates you require... if it is referenced to fields then you put that in also rather than set dates.. you can use the query builder to create the formula.. have a search on...
  18. S

    forms & combo boxes...

    yep.... in the query which your form is based on (that is the form that will display the record you choose from your list) then put in there the same field that is in your combobox and in the criteria put this.... =Forms![Form1]![Combo0] so if your combobox bound field is [surname], then put...
  19. S

    Checkbox in forms and report

    apologies mile, did not see you had replied also... Suzy, if Mile has suggested then above then go with that..
  20. S

    Checkbox in forms and report

    ok.. you have your form with the records and the checkbox field.. lets call it checkbox1 so you create a query with the fields you want the report to show. then on the checkbox1 field you put in the criteria forms!yourform!checkbox1 = true you can do this through the expression builder...
Back
Top Bottom