Search results

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

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

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

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

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

Hey all, is it possible to add a sound to a form when it opens? If so, how would that look? Thanks in advance, RR

Here's a question: I have a form that has 2 control buttons, which open 2 other forms. The thing I want to do is put a password on the control buttons. Is this possible and if so, can you tell me how please? RR

Hello all, I am new here so please excuse the noobness. What I have is a entry form with 20 or so fields that has a members info such as name, street, city, etc. I enter the info, click add or save record, it does that, but when I go to select it from the combo box, that record is not in the...