Search results

  1. C

    Import button to ask for location of file

    Hi thre, I have been searching all over on how to create an import button on a form in access 2010 where I can set which table it should copy the data into but the user could locate the import file. NOTE: the reason being I have locked all the ribbons... If necessary I could make a specific...
  2. C

    Import from multiple docs to one record in a table

    Thanks, but if I want to print a report afterwards for every student will a cross tab query work?
  3. C

    Import from multiple docs to one record in a table

    Hi there, It's my first time trying to work with big imports. What I wanted to do was try and import from 5 excel sheets into one table and merge them into 1 record. E.g. I have pupils with test results for maths, English and ICT. I have 3 spreadsheets called Maths, English and ICT and I...
  4. C

    DB To save passwords

    Virusworld that db is tops, one little virus on the unhide it unhides all the passwords, can we make it just unhide that record? thanks
  5. C

    How to create a query on lookup of multiple values

    Would you mind to have a go at mine as i am not the best at vba to run a query and i want mine to work off relationships that when i select year 07 and year 08 from the table "years" it will pull up all the records in "students with that criteria. Thanks
  6. C

    How to create a query on lookup of multiple values

    Thanks, will take a look some time.
  7. C

    How to create a query on lookup of multiple values

    Hi there, I have attached a db with two tables. I wanted to create a form where you can select multiple values from the table "years" and on a button it would open a query displaying all the records in "students" in those years selected. Please help.:banghead: Thanks
  8. C

    Confirm Quit

    What i done was just made a new form called frmShutDown and in there put "are you sure you want to quit" and added buttons Continue, Cancel... Seems to be doing a great job, i am now in the process of disabling the MS Access x button so that users must shut through my dialog!
  9. C

    DB To save passwords

    I really do like it, is there a way that when i insert the pass to unlock it is displayed as **** instead of the actual letters. Many thanks for that
  10. C

    DB To save passwords

    Thanks, will have a look at it.
  11. C

    DB To save passwords

    Hi, I got an error. I have attached the db can you please have a go and send it back. Ta
  12. C

    DB To save passwords

    Hi there, I want to create a database that i can save all my passwords in. In the table the password field is set as password and therefore displays "*****". I want to create a form with from that table and put a little unhide button next to the field password saying Unhide password. Is this...
  13. C

    lookup Combo Box

    When I insert a new combo that should pull down records in my columnar form, the combo on select will only pull that record up once i have been into design mode or something similar and every time i reopen the form it just doesn't work. Does anyone know if there is a fix for this most annoying...
  14. C

    Changing to a record based on text box entry

    Hi there, I find the combo box bugged every so often and doesnt always work, so i therefore made a query with a criteria on the ID [place ID no.] and that way it just pulls that one up. it is lovely to use! If anyone has any idea why when i creat a form combo to select records in that table...
  15. C

    Trouble setting Temp Var

    Hi there, I have done that now, would you mind to try and look at it again. Thanks a mil:banghead:
  16. C

    Trouble setting Temp Var

    Thanks for your response, Is it a big job for you to change this as I am happy for you to change whatever necessary to get this working. Thanks for all your help
  17. C

    Temp vars trouble

    Please would someone be able to help me out on my sample DB to get the temp vars running, I am having a lot of trouble. My db is in a forum under temp vars, thread 1286451 Ta
  18. C

    Trouble setting Temp Var

    Sorry unsure what you mean, Is it not code?I don't think I worked on macros on my logging in for?
  19. C

    Trouble setting Temp Var

    Many thanks for your reply. Unfortunately I cant get that code to work. attached is my sample DB. could you possibly let me know where I am going wrong. Thanks a mill.
  20. C

    Trouble setting Temp Var

    thanks, it is the second column on my drop down. how would i place it into this script? TempVars.Add ???, "??"
Back
Top Bottom