Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MichelleButler
  • Order by date
  1. MichelleButler

    Add 84 days onto a date input into a form

    Thank you Chris, I have already have this on the top of the form aswell. Michelle
  2. MichelleButler

    Add 84 days onto a date input into a form

    Thank you for the valuable information, Kendal. The coding you give me Kendal works really well, unfortunately the first date is in UK format but when it adds 84 days it returns it in american format. The first being UK and when it calculates the second dates The DateNextReviewDue, it returns...
  3. MichelleButler

    Add 84 days onto a date input into a form

    I am updating the DateReviewCarriedOut with a calendar using the following code: <tr> <td width="145" class="bodyBold8" bgcolor="#CCCCFF"><div align="right">Review Carried Out:</div></td> <td bgcolor="#CCCCFF"...
  4. MichelleButler

    Add 84 days onto a date input into a form

    Thank you Kendel, I will try this. Its has been a very long time since I have used tek tips, but everytime I post a problem, I have always had really good response. Many thanks again.!!!!!!!!!!!!!!! Michelle
  5. MichelleButler

    Add 84 days onto a date input into a form

    Thank you for the speedy reply. Would I have to implement this into the update query. Michelle
  6. MichelleButler

    Add 84 days onto a date input into a form

    Help!!! I have users inputting dates from a calendar that insert the dates they required into the form, but I would also like to be able to populate the next field that add 84 days onto it, from the first field. Here is an example of the code: <% Dim Conn ' Open Database Connection Dim RS...
  7. MichelleButler

    Different row colours in a form

    I can get a report to give me two colours in a report but I would like to be able to retrieve the same results in a form. I forgot how to achieve this. Many thanks Michelle
  8. MichelleButler

    Permissions on running Queries

    Hi SiJP, It will be several months before I upsize Access to SQL, as all my users are still on Access 97 and Windows NT. As soon as I get the go ahead to upgrade everybody to Windows 2000 and Office 2000 I will then upsize the database. I work in the MOD, so we are still way behind. In the...
  9. MichelleButler

    Create a logon form

    Hi SiJP, Thanks for the information, I have upsized it to SQL, unfortunately the company I work for (MOD), is way behind times and it is very hard to get software to work correctly until they ungrade all the workstations to windows 2000/office 2000. Everybody is on Office 97/windows NT. I...
  10. MichelleButler

    Permissions on running Queries

    I have received some really helpful advice on tek tips and I thought I would try this one. I have a database in Access, currently being updated to SQL but in the meantime, I have loads of people running queries on the database. I would like to try and limit the permissions on the queries, so...
  11. MichelleButler

    Users logging on directed to the correct forms

    Thank you Jamie for your reply. The information was very useful, unfortunately I can see this working but I am struggling to adapt the above coding into my code as I have already a Dlookup when trying to find the password. If I insert the above coding it already tells me that the form has been...
  12. MichelleButler

    Users logging on directed to the correct forms

    I have an access database that is used by a large orgnisation. There are different levels of access to the database. The database has been split so the users are running the correct form, but they are all connecting to the same table. I have users logging into the database now, but want I...
  13. MichelleButler

    Upsize Access to SQL

    I have a massive database currently working in Access 97, I have converted this to Access 2000, and Access XP and upsize the database. I can upsize the database and use the database in Access 2000 or Access XP connecting to the SQL tables through an odbc connection which works like a treat...
  14. MichelleButler

    Upsize Access to SQL

    I have a massive database currently working in Access 97, I have converted this to Access 2000, and Access XP and upsize the database. I can upsize the database and use the database in Access 2000 or Access XP connecting to the SQL tables through an odbc connection which works like a treat, but...
  15. MichelleButler

    users logging into the database

    Thank you for the brilliant information, it works a treat. I would also like to be able put into the same coding if possible, useraccess to menus. Let say if one person from Finance logins into the database, the username is checked for the password and then in the same table the useraccess...
  16. MichelleButler

    users logging into the database

    Thank you for the advise, this sounds like what I am after. I will give this a go!!!! Many thanks Michelle
  17. MichelleButler

    users logging into the database

    I have created a form that allows users to log in, the code checks the password stored into the table and then allows then access to the database if correct. I would like to be able to get the information stored into a different table such as auditing everytime the user logs on the username...
  18. MichelleButler

    Create a logon form

    Thank you very much for your quick replies, what Ideally I would like is to create a log on form, that allows users to log on, using a username and password, when they log on the this updates a table and insert a date stamp onto the table. I hope this makes sense. Michelle
  19. MichelleButler

    Create a logon form

    How do I get users to logon onto the database through a form and be able to track how many users log on to the database. The password would be stored into a table, and hopefully I would like to be able to get a date time of everybody who logs in. Your help would be much appreciated. Michelle
  20. MichelleButler

    Russian Charset - Cyrillic characters

    Russian Charset Cyrillic characters We are currently using a database that uses US7ASCII, oracle version 8.1.6.0.0 on an Unix Solaris 5.8. The Database is going to be used by Russian clients and I understand that the database doesn't support Cyrillic characters so I need to set up the database...

Part and Inventory Search

Back
Top