Recent content by MichelleButler

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

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...

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"...

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

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

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...

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

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...

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...

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...

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...

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...

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...

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...

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...