Search results for query: *

Hi Randy Thanks for your reply all field datatypes are date (medium Format) Works if criteria on 1st record but if criteria on any other record you must click into field in record before message appears, I assumed that regardless of position of criteria code would read all records and flag up...

I have a table in access that holds data on vehicles there are 3 fields holding dates on MOT, Tax and Insurance renewal I am looking for 3 different messages on opening if date of any is within next 2 weeks e.g. If DateDiff("d", Me.MOT_Renewal_Date, Now()) < 15 Then MsgBox "Vehicles Due...

Many Thanks to you all for your invaluable assistance

SELECT [qrycounting tradeClockings].Trade FROM [qrycounting tradeClockings];

Hi Remou I have put in a subreport but it is only picking up last trade don't know why because when same count is done on main form it picks up all

I have a report that has a field Trade and I can place a count function that will tell me individually how many employees have what trade in the Trade Footer, and if I do a count in report footer I get an over all count of all trades. What I want to be able to do is place an individual and...

Thanks for that

Thanks to each of you for your response Can any of you suggest what would be the best alternative a to a lookup as company wants to easily select data on different forms. Thanks again for all your time and effort

Hi I have a column on a form which is a lookup from a table and I need to be able to create a left function to lift 1st 2 characters but won't come over as text just applies a number e.g. Field Name County inputs "Tyrone" on form would expect Ty but left Function is inputting 23. Any help much...

Many Thanks Remou for this. Yes I do know a user can be in more than 1 group but going to try and avoid this as best I can.

I have set up security on a database and have used Application.Currentuser to record the username so as they can have forms allocated to them and what I was looking to do is record the user groupname so as I can allocate forms to specific groups. If it is possible

Many thanks to each of you for your time and expertise it all working now

When using jadams0173 code on event load form i get my name returned in immediate window but not on form. Thanks to both of you

sorry I have set a breakpoint and nothing running

I am obviously not doing something right nothing is being returned. this is my code Private Sub Form_BeforeUpdate(Cancel As Integer) Me.currentuser = Environ("username") End Sub Thanks for your time and effort

Removed the stop but code doing nothing no error no update

I have a form with Currentuser text box on the event before update of the form my code is [currentuser]= environ.("username")

Hi Can anyone show me how to call either application.currentuser or environ("Username")the exact code. Please I have been playing around with it but no joy. I have Access security set and trying to allocate different forms to different users on opening the database. Many thanks

Thanks Remou for your quick reply Format worked a treat

Hi I have a value from a Dlookup displayed as 345.134566 and I want it to just have 2 decimal places. I have tried different formatting and the only one I get to work is Ccur but I don't want currency formatting. Can anyone help. Thanks for your continuing support