Recent content by Digby

  1. D

    Deleting data older than 6 months

    I changed it to EntryDate, but i will change it completly and try again! thanks
  2. D

    Deleting data older than 6 months

    rainman, thank you but....i did exactly as you said and it will not work, i save it then when i re open the query it has put the (DateAdd("m",6,[YourDateField]) < Date()) in the next colum! what am i doing wrong???
  3. D

    Deleting data older than 6 months

    Hi, sorry to sound stupid but where do i put the sql as i can not get it to work at all it comes up compile error and highlights "Delete" what am i doing wrong, as im not great with SQL i simply made a button in a form with wizzard then deleted the text that was put there and entered the sql...
  4. D

    Deleting data older than 6 months

    Hi, Firstly I rather unsucessfly tried the search function, I want to automatically delete any enteries older than 6 months, I do NOT want to archieve them, simply delete them. I only have three entries; Date Address Line 1 Post Code I was unsure how i would go about this or even where to...
  5. D

    Securing the back end of your database

    Its to go on a goverment sys. I have pretty much computer iliterate user and even admin dont know the diff between access and excel!!!! But all the computers are owned by NHS, and they have IT, im not worried about them getting to the tables as they work for the comp and they are not stupid...
  6. D

    Locking down an .mdb file

    But will it stop them looking at tables and querry's in design mode? and what about not opening the db window on startup? My db window does not open on startup, Im going to disable shift on open etc is there any point converting my mdb to mde?
  7. D

    Securing the back end of your database

    Ghudson I love you, sorry people, I thought I would need a whole load of code but you have just made me very very happy, this means that no one can import my back end data! Wo hooooooo lol sorry im about to get up and dance around my office!
  8. D

    Networking

    Does this mean they can not edit the data via the backend without the password? and can the front end still edit it? I like that idea as it does not matter if they import data, as long as its not corruptable i dont care if they steal it!
  9. D

    Combo box "unable to retrive data"

    I have a frm (frmWMS) which has 4 fields, Location, Room, Number and Quick dial Its based on qryWMS which has one criteria in the Location field, therefore the form shows all the results for bath or bristol or wherever the user selects. I have gone to add a combo box that lets the user select...
  10. D

    Networking

    Hello, Things have changed significantly in my progress as I learn more and more, it has got to the point where im starting afresh! Im not going to use the user security as its not worth it for me, im not storing confidential data, i have a simple log on form which will load on open, user...
  11. D

    Turn a form into a switchboard

    So can any one tell me how to turn my frmMainMenu into a switchboard? Cheers
  12. D

    Turn a form into a switchboard

    On the admin menu all the forms are tabular as this is how admin want to vies data whereas all the forms on user menu are tabular, I could turn the user main menu into a switchboard and then have a button "admin" which opens the admin menu, this could work, how do I go about either hiding the...
  13. D

    Turn a form into a switchboard

    I have made two main menus, one for admin and one for users, I want to turn these into switchboards. When you open a form asking you to log in opens if you supply the right password it opens another form depending on your access rights depends which menu it opens, it all works perfectly but I...
  14. D

    Networking

    Ian, After playing with it I have learnt to link the tables and to split the app, and to be honest both are a lot lot simpler than my idea, I just thought it would be a lot harder, im going to split it! If all works over the network it should be very good, the network cover over 70 miles, its...
  15. D

    Switchboard....

    Thanks, So my main menu that is a form with links etc. is a switchboard? I thought that it had some big thing in it that made it unique, something that could not easily be recreated, oh well, thank you though, as they say you learn something new everyday! lol
Back
Top Bottom