Recent content by tonez90

  1. T

    Solved Archive old records

    Hi an easy way would be to add two fields to the student records. One dealing with a completion date or similar and then a yes/no (checkbox) to signify an archive of the record. When you then display or search you could then exclude or include the archived records if you wish. I am developing a...
  2. T

    Getting pop-up form to center on monitor

    Hi unfortunately the files on the Isladogs site appear to be not there (i.e. 404 File not found came up)?
  3. T

    Auto update front-end

    One area you need to careful about is the ability to "Roll Back" the front ends in case there is an issue that just rolls out. I personally used a table in the backend which has this sort of setting in it. I also developed two bat files one to update and then one to rollback. These could be...
  4. T

    Checking License Key using HTTP

    Hi isladogs, I love you screen stuff. I have downloaded a few of your demo's and they are very useful. Keep up the great work as it will be extremely useful to me as I move forward with some of my projects. I do like you system tray example and attention seeking database. I am currently seeing...
  5. T

    Checking License Key using HTTP

    Thanks isladogs - yours look really good. I just visited your databases and some really good examples there. Im definitely going to have a look at these and certainly learn from them as well Cheers Tonez
  6. T

    Checking License Key using HTTP

    Hi I had done something for checking a text file on a web server which essentially looks at a version of a database. It could be altered to look at a licence key and an email address or name. I attached the module in text format. You can simply call it up via a function...
  7. T

    Go to the last record minus 5 records on a continuous form

    Sorry forgot to say that medium top is a number that I can set to move the record selector back a number (so Medium_Top is set to 10 which is 10 records and fits on my screen) Regards Tonez
  8. T

    Go to the last record minus 5 records on a continuous form

    Hi I have used something simple on the form when I start up and is based on the number of records being displayed. You can easily modify it to form a module etc. In my code I also resize the form depending on the number of records I want to display. It then sets to top of the form the actual...
  9. T

    Change Function name in event in form design

    Hi I have allocated a function (event) to a control on a form (i.e. =PopupCalendar([Screen].[ActiveControl]) on the event 'On Dbl Click'). The issue is that the database is quite large and the function is used on a lot of forms. I want to rename the function to say fn_popupCalendar to make it...
  10. T

    Insert data from access into a word template but multiple fields

    Thanks or that. I did that originally but I needed to keep the table format with number in column 1 and description in column 2. I have never really interacted with word before so maybe you can recommend a good reference site or similar. Thanks for your help Tony
  11. T

    Insert data from access into a word template but multiple fields

    Hi I have a database I use at work to store conditions placed on a licence. I have a word template that I use to print out the licence but I am having trouble printing multiple conditions. Each condition is given a number and can be up to around 50. I can place the first condition in the...
  12. T

    Hide label on report if field is hidden

    I assume the control with the value is also hidden then you could just Me!Label_control.visible=Me!value_Control.visible Therefor when value is hidden the label is also hidden or visa versa. You can simply place this into the on current code of the form or alternatively place it it in the...
  13. T

    Lotus Notes to Outlook

    I used to use Lotus notes and its not to dissimilar to outlook coding. Anyway here is a module I tend to use - its full of outlook type stuff and hopefully you can follow it. Most are relatively strait forward. Tonez
  14. T

    Re Email rea ddatabase. Not a problem. I havent taken it too far yet as I was designing a email...

    Re Email rea ddatabase. Not a problem. I havent taken it too far yet as I was designing a email form to be used to collect data from emails. Let me know how you get on.
  15. T

    Access Read Email Messages and Populate table

    I have attached an Access 2010 db which reads MS Outlook and displays your inbox details. To read the body you will need to develop a simple parsing utility to read and pull out the required information. You can use the Read filter to simply use the read emails. Note I have used tmp tables to...
Top Bottom