Search results

Rich: This is what I have so far. But I am having trouble making the "All" criteria work. I am attaching the db. If you can please take a look at it. Thanks, Ekta

Thanks

Hi: I want to know if "All" criteria can be added to a listbox. Right now if users don't make any selection in a listbox it returns all the records. But users want to add "All" criteria in a list box to that. I know it can be done in a combo box. I searched on the forums but did not see it for...

purrrfect. Thanks Does it make a difference if you don't include the error handling part?

It gives me compile error.."Sub or Function not defined" and highlights "ErrorMsg"

Private Sub Months_BeforeUpdate(Cancel As Integer) If Not IsNumeric(Me.Months) Then MsgBox "You cannot type text in this field. Please enter only number for months", vbExclamation, "Error" Cancel = True End If End Sub

Will do. Mile-O-Phile, I tried the code but it doesn't do anything. It still shows the error message by Access. Thanks, Ekta

Hi: I want to create my own custom error message dialog boxes. For example I have a number field on my form. If user enters text in that field I want to display my own error message instead of the error message displayed by access. Thanks Ekta

Thanks Jon. This is perfect.

Another thing I forgot to mention. The 2 criteria's added in the query are compulsory while the criteria's entered by the user are optional.

Hi: I have a query that has 4 criteria's. 2 criteria's have been added to the query and the other two are entered by the user. For some reason when I run the query it is not taking into consideration the criteria added to the query. Can anyone please take a look at it. I am attaching the db...

Hi: I have a currency field that I want to format in $#,###k format. All the values entered in this field will be in k value. For example if a user enter 1,000 it would mean 1,000,000. It should display it as $1,000k but store it as $1,000,000. Thanx Ekta

Thanx Wayne and Dave. I got it to work.

Hi Wayne: It doesn't seem to be working. I see that you added 2 users in N_tblLocalUser. All my users are saved in N_tblPassword. Once they login in successfully their UserID and UserLevel are stored in N_tblLocalUser using append query. N_tblLocalUser is used to temporarily store the user...

Thanx for replying Wayne: This does not work. I am attaching the db. If you could please take a look at it. Ekta

Hi: I have a login form. Every user is assigned a userlevel. It is either 'admin' or 'user'. Once a user logs in successfully frmMain opens and user's userid and userlevel is stored in table, N_tblLocalUser, using append query. frmMain has Administrator button which, I want to be disabled if...

thanx Wayne, din't think about that:p ekta

Hi, I have a bound field, OriginationDate, on my form. I want that when the user adds a new record this field should automatically populate with the current date. I can use =date() or =now() but it's a bound field. I don't know where to put it. Thanx Ekta

Hi Hayley, I have a form where users enter some criteria and access filters the records that match the criteria and generate the report. Once the report opens, users want to email it using Outlook. How can I email the report using a form? Ekta

Thanx for replying Barry. I don't want to email the report from the form. I want to email it from the report itself. If I add a command button on the report it does not show the events associated with it. Is there any way I can do that?