Search results

,,and yes.. i will not use the autonumber as a "public" identifier in the future... :).. I learn..

I started to use Access 2003 (currently 2007) as an in-house and local tool for 12 users, believing that a large multinational company would not adopt this tool globally... But the company/department did.. J . Access has proved its value (a small business solution in a large corporate...

Yes..that did it... Why are the most simple solutions most difficult to understand? :) Thanks indeed all for your asistance..i learned something new today!

I appologise for my ignorance Paul... I am on the main form and i want to setfocus to a specific controll on SUB 1 Me!Form2.Comments.SetFocus i am doing something very wrong but it just does not function...

Hi all, why does this not function: If Me![Fruits] = "Bananas" Then DoCmd.Save Forms![Form2].[Comments] SetFocus End If Forms2 is a subform Thanks!

This is most valuable information..and i can see i have lot ahead..i am indeed very greatful for you effort and assistance. Thanks a lot!

It is quite complex. Actually i do not want to email a “record” but to populate an email-template with certain data from a form. On the click of an command button i want to find and open a email template (name corresponds to the value in one of the controls in the form), edit the template, and...

Hi , Anny suggestions were i can find examples describing Access and Outllook interacting. I want to email records, store emailed records (emails) and if possible also receive or at least, flag received emails corresponding to previously transmitted... Thanks!

This is very interesting Trevor..indeed... i suppose i can alos put this in the context of AND: If Me.NameOfControl.Tag = Me.NameOfControl And If Me.NameOfControl = "Flower" Then Cancel = True Else DoCmd.Close End IF ? Thanks!

Thanks Trevor, much appriciated... i will try out both options, thanks!

HI all and thanks for all suggestion making this a great place to watch, ask and learn...! Form A. Text field A. When closing Form A, i want to inform the user that the value in Text Field A has not changed since opening Form A. If the value has changed (when opening it was 1 and when closing...

Ok , thanks.. i will concentrate on this option too...despite the upcomming WorldCup Finale :)..Thanks again!

..just one humble question... I use this code: If Month(Text1.Value) < Month(Date) Then Me.Text1.BackColor = vbGreen Me.Text1.ForeColor = vbBlack End If If Month(Text1.Value) = Month(Date) Then Me.Text1.BackColor = vbRed Me.Text1.ForeColor = vbWhite End If But if i also want to say...

Yes...this is what i was looking for...i understand now..i need to refer to one the text1 control... Thanks!

I am using this in the forms current event.. If Me![Text1] = Date Then Me.Text1.BackColor = vbRed Me.Text1.ForeColor = vbWhite The first issue i have to is replace Date with current Month..meaning that if Date is July then etc etc...i am getting gray hair on this one..

Hi, my current conditions are from that button in my application..but i need to find out a way to code the "on current" event of that specific control to format the condtions..especially to display current date in Month..its tricky since there are three conditions invloved.. Current date...

HI all, I want to display and condition (colour) a date reference in a text field Example: 11/07/2010, i use this as conditional formatting but want to replace Date() with month Field value is: Between Date() and Date()+90 / Green ..Date() should be current month and +90 should 3 months...

:) A Combox became the result..Thanks indeed!

Thank you, but how do i assign the letter R ?

Hi all.. I want to use a toggle button to cycle 3 stages... 1. Yes 2. No 3. R How do i do this, programmatically or by the property sheet related to the toggle button.. The control to be “toggled” is a text field.. I use this to “toggle” between two values..but the third? If Me![TextA] =...