Search results

none of this is helping...here is more of an idea what i want to do. a user is filling out a form...when done the record that he or she just created needs to be put in report form and emailed to the boss

that link works great...thanks

yes...havent found what i was looking for guess ill keep looking

When A User Fills Out My Form...and Selcts Exit Sign For A Fixture I Want A Email Sent To Me. How Do I Do This

I Want To Type 4.2 But Acess Rounds It To 4.0...ive Tried Fixed And General Format

I Want To Type 4.2 And Access Is Rounding It To 4.0...ive Tried Changing The Format To General Or Fixed But I Cant Get Access Not To Round

In My Table I Want To Type A Number (4.2) But I Cant Get Access Not To Round That To (4.0) Any Suggestions

Oooopppppss Thanks

Remind Me Again...when Opening This Form I Want A New Record Displayed...how Do I Do It

If I Wanted To Create A Form With Combo Boxes That Limit The Choices For Example 1st Box Gives Option Of "meeting Room" "exhall"...if The User Chooses Exhall Then A, B,c,d,e Pop Up In A New For And Combo Box. If They Choose Meeting Room Then 201, 202, 203, Pop Up In A New Form And Combo Box.

In My Querry If I Want To Round The Answer Of An Expression To The Nearst Whole Number....example 3.97362352 What Do I Do The Expression Is As Followed What We Use In Next Year: [bulbs Per Month]*12

Expr1: DateDiff("m",#12/1/2003#,Now()) NEVER MIND IT WORKS WITH THIS....THANKS AGAIN GUYS SO FOR MY IGNORENCE

Now A Enter Parameter Value Box Opens With #12/10/2003#

Not Under Standing [my Date Feild] I Assume That Is The Total Amount Of Bulbs Used Since 2003 Again I Have The Total Bulbs Used Since 2003 I Want To Divide That By The Date The Form Is Open On (in Months) So I Can Find Out How Many Of That Bulb I Use A Month

I Have A Querry That Adds The Amount Of A Certain Light Bulbs I Have Order Since 2003. I Then Subtract The Amount Of That Light Bulb I Have On Hand Now...it Gives Me The Amount I Have Used Since 2003. Now I Want The Querry To Take That Number And Divide It By The Numberber Of Months Its Been...

PART NUMBER: IIf([MANUFACTOR SENT]=2,[GE PART #])OR IIf([MANUFACTOR SENT]=3,[PHILLIPS PART #])OR IIf([MANUFACTOR SENT]=1,[SYLVANIA PART #]) CAN ANYONE HELP ME FIX THIS EXPRESSION

PART NUMBER: IIf([MANUFACTOR SENT]=2,[GE PART #])OR IIf([MANUFACTOR SENT]=3,[PHILLIPS PART #])OR IIf([MANUFACTOR SENT]=1,[SYLVANIA PART #]) CAN ANYONE HELP ME FIX THIS EXPRESSION

IIf([MANUFACTOR SENT]=2,[GE PART #]) this expression works fine in my querry....but i need to add to it...if the user doesnt choose 2...if he chooses 1 then i need the sylvania part number or if he chooses 3 i need the phiilips part number....so i used this expression IIf([MANUFACTOR...

i have a table which list bulb info...like three manufactors part numbers... i created a querry for when i order a bulb (with information from a order table) if i select "ge" for the manufactor i want the ge part number to go in the part number feild in this querry. my expression Expr1...

i get error with this expression. and the new expression you gave me -----IIf([MANUFACTOR SENT]="GENERAL ELECTRIC",[GE PART #],"some other ref")----now just puts "some other ref" in expr1... can some one help me...and not give me advice they know wont work.