Search results

guys....i dont know what happened but it is working now.. thanks anyway. max

I created an app., for tracking changes, where once the user is logged in , the login form is hidden. When a user modify the status of a change, i cretaed an event procedure in the update before. In that event procedure i am opening a new form to ask to continue or not and then i hide it. When...

newman, thx 4 your hlp.......max

I created an application in access 97 under win2000 Pro. Some of the forms use a calendar button. The problem is that one of the users can not use the button, when trys to open it, the calendar is blank and the following msg appears: ERROR 2863 THERE IS NO OBJECT IN THE CONTROL thx for your hlp.

Guys, i found a few answers in the forum and it is working. However, i'd like to know if there is any chance to force Lotus Notes to ask the password when the DB is locked. any suggestion? Public Sub Sendmail(Task As String) Dim nSession As Object Dim CurrentUser As String Dim...

Hi guys, here is my problem. I am sending emails when the user press a button, but the problem is: 1 - How to check is LNotes is open 2- How to know if the user needs to enter the password. With the following code an email is sent ONLY if notes is open AND the psw is not required. Public Sub...

workmad3, thx very much for your help, i will try your solution tomorrow morning. In the meantime, i solved that problem including the code as a public sub in the form and calling it with argument. is it ok? i dont know if it is a better way but it works. thx again, max.

Hi guys.....here is my problem. I am using a module posted in this website by madmaxx to send emails via notes. The module works perfectly if i run it manually, but what i dont know is: 1- how to execute this module from a form. 2- how to pass a value from a form to this module thx 4 your hlp, max.

the solution.... to solve this problem i just added the "#" before and after the value. ex. (code) If Me("Filter" & intCounter).Tag = "Teffective_dt" Then strSQL = strSQL & "[" & Me("Filter5").Tag & "] " & " <= " & "#" & Me("Filter" & intCounter) & "#" & " And "...

help i need some help please ....... thx

dakcg, basic question...did you checked the child and master link fields ? max.

sorry about the db but it was too big. now here is the sample db. Also, i added a date field in the table and modify the last combo to be the field combo. thx

more data Here is more info: i discovered that the problem is in the report and not in the form, 'cos....if i put the filter on in the report and i filter by the effective_dt field, it doesnt work. The report gets info from the table where all the data is stored. The effective_dt field is a...

here is the sample db...

i have created a new form based on a database called RptSmp97 from microsoft knowledge DB. My form, as in the sample, calls a report when it is opened and at the same time shows you a multicombo form for filtering the report. In the sample the form uses only text fields, but i need to use...

threeCrow, thx very much for your help. it works, but i am not using that form anymore. I created a new form from a sample database in microsoft knowledge database. thx a lot.

i am still trying. what i created works only if i complete both fields in the form. if i leave them in blank it doesnt bring al the data from the table. suggestions? thx

improving this problem is getting better but not enough. I created a form with 2 unbound fields which will act as filters and a button to apply the filters. Also, i created a query filtered by this 2 fields. Then, in the form when the button is pressed a new form with the result appears. My...

is this form with a query on it possible?? Hi all, In order to finish my work i need to solve this first. I would like to create a form where i can show data filtered by multiple fields. For ex i would like to filter the data by: Status and/or requester and/or open date and/or description...

wayne, i didn't know what NZ was..... it is much better than the another way. thx for your help.max.