Search results for query: *

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

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

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

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

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

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

Hi Me again I have a fom "Payment Certificate" with a field called [Paymentnumber]now I want to increment this field by 1 when 2 conditions occur that is when field [companyname]=[companyname] and field [contractname] =[contractname]I can get it to work for company name but not for both. I am...

Hi I am able to format the field using either CDbl() or Formatpercent([],2)but because another field has a Dlookup into it this causes errors, I think it is because formatting causes field data type to change to text. So is there any way of formatting field and keeping data type. Many Thanks...

I am trying to setvalue of a field according to result of another field and was looking to record multiple options.e.g. [County] in ("Armagh",Tyrone","etc") set value of field province to "Ulster" or [County] in ("Galway","Mayo","etc")setvalue of field "province" to "Connacht" I can get one to...

I have a Payment Certificate Query Where the Fields "ThisPayment" and "LastPayment" are added together to produce "TotalPayment" but "LastPayment" is to be generated by previous "TotalPayment" which a Dlookup will get me but appears blank, probably something to do with circular reference but not...

Hi I am trying to display the result of a field from a previous Record depending on 2 fields criteria e.g. Field name is "Payment" depends on fields "CompanyName" and "paymentNumber", Was trying to do a dlookup("[Payment]","qryPaymentCert","[PaymentNumber]="&[PaymentNumber]-1 and...