Search results

lol...I actually did that and it worked, but then I saw Brian's post and decided to use it. God bless all!

Awesome, that worked Brian, thanks for the help from all. :)

Thank you for the reply. I tried that and it did not work.

Hey all, I am trying to write a me. statement that has more than one condition, is this possible? Here is what I have, oh and btw I'm learning access if you could not tell...:): [code] Private Sub Product_LostFocus() If Me.Product = "1" or "3" or "7" or "12" or "Large" Then Me.stocked = True...

Hey all, is it possible and if so, how or can you enable a password on say half of a form? I want to have one form on entry, but only those who have the password to be able to make changes to it, but others can view and click on certain buttons. Thanks, RR

TY for the replies.

Hey all, I looked through some of the forums, but could not find a direct answer. What I am trying to do is sum a field if it contains certain values contained in that field. Like I have a field called [Service], in that field are mutilple values, such as "Good", "Bad", "Excellent", etc. I...

Sorry, but still learning access, would that be something like: =sumIIf([AP]="AP1") Thanks for the help!

Hey all, I am using the IIf function in a report to count an occurrence. Here is what I have: I have a combo box(AP) that houses the selections, ie., AP1, AP2, AP3, etc. I am using a textbox to count the occurence of each selection so my IIf function looks like this: =IIf([AP]="AP1",1,0)...

Hey thanks all, but that was it CraigDolphin, I had the field set to text and not date...duh...lol Appreciate the help. RR

Hey all, I looked throught a couple of threads for sorting, but could not find exactly what I need. Basically, I have a list of dates: 10-Aug-07 20-Oct-07 13-Nov-07 etc... and when I try and sort these dates from earliest to latest, it only reads the number and not the month, like: 10-Aug-07...

Hey thanks RuralGuy, I believe I can use this. God bless

Hey all, I did a search for this, but could not find exactly what I wanted. What I'm talking about is under Tools/Database Utilities/BackUp Database. What do I need to do to make a backup database when a user either opens or closes the database. I looked under macros, but did not see...

Bob, I get a error when I try using this. The result is #error. Like [forms]![frmPEL]![cboMonth] & "/*/" & Val(Right(DateAdd("yy",-1,[forms]![frmPEL]![txtYear]),2))

Just a little bump...:)

Thanks bob, that worked. One other question is, this expression obviously returns the month and year as you fixed it too. Now I would like to return the same thing, except minus one year. Here is the expression that I have for that using the Val function, but not working for me. Can you take...

Hey all, I have a form that has two textboxes, one box is for month and the other is for the year. After I enter the month and year I want, I click on a command button that previews a report. Well, the report is not giving me the information for that particular month and year, actually it...

That worked, thanks for the help missinglinq. RR

Mr. boblarson, would you happened to know the answer?

Hey all, I have a text box that when I enter information into it and click tab to go to next field, that information disappears, but when I look in the table it is there. Any clues? Something I need to upcheck? RR