Search results

Dear arnelpg I am so sorry and embarrassed to tell you that all your suggestions are working. I discovered a hidden problem: my record source is a Dynaset and the join of my table was causing an increase of records for that record set which would obviously be more that the table. I had 2...

Thanks for your response. Unfortunately it hasn't work for me. I tried over and over. Are there any other suggestions?

Good Day all, I have a field "present" of data type yes/no, and I want to count the number of values that are yes ( which are the ticks ). I tried the following but it does not work: Count [present] The report contains groups of records which I would like to sum separately. Can...

Thanks Rural Guy. It worked instantly. I am relieved.

Good Day All. I want my code to display a message if the value in the control is Null. I test the code with a Null value in the control and the message is not displayed; it just by-passes the if function code and goes on to the remainder of the module code. Strange enough I tried the...

Actually I just discovered that my problem is really a different one. Here's the problem: I have the combo value wrapped with DateValue function like so: Datevalue(Schedule Arrival). Ultimately, what I am trying to do is add 8:00 AM to today's date so I tried: if now() >DateAdd("n", 15...

My combo is "SheduleArrival" and the button is "AutoSave". The format of the combo is medium date but the combo's value is set to either 8:15 AM or 11:00 AM; never to zero. When "AutoSave" is pressed the code executed is: me.ScheduleArrival

My unbounded control has row source type as Table/Query and the row source as a table field "StaffStartTime" with datatype Date/Time medium time. This field contain the following values "8:00 AM" and "11:00 AM". pressing a button of the form causes the value in the control to be displayed...

You additional explanations have been very useful

This was a long challenging day with a very steep learning curve; but I made it. Thanks very much for the introduction of these functions.

On a form I want to evaluate if a time entered is later than a schedule time, with a time allowance of 10 minutes added to the schedule time. here is my code: if Now() > ScheduleTime + 10 then msgbox Late end if I want to know why is the 10 not recognized and the results are...

Thanks. I just forgot one thing: in my original code above in Blue I had a lengthier query which was as follows: strfilter = "officerName= ' " & Me.txtUser & " ' AND [Auto Date] = # " & Date & "#" txtUser is a control on the form. I subsequently left out the OfficerName to make...

You have been very helpful

Thanks. I got it working

Thanks for your response. I however submitted the incorrect code. This is what is should have been: The error message is : The engine cannot find input table or query. Option Compare Database Private Sub Command26_Click() Dim curDatabase As DAO.Database Dim rs As DAO.Recordset Dim...

Good Day All. I have a form with a button, a textbox1 and some other textboxes Basically when the button is pressed I want the event to cause a table to open with only records of the value in the textbox1. I then want to add a new record using values from the textboxes on the form to the new...

Thanks for the info; But can you say which version of Access you are using. I am using ver 2007 so my page looks different from yours

No problem. I did try it first in the expression builder but it would not accept it; so may be I was applying it incorrectly or in the wrong place. However for the record and future I would still like to do away with putting it in the query. Do I place the formula in the source control...

Thanks All. This formula works. I placed it in the Query field.

Of all the "Otime" sorts for each officer's entry there is only one officers' entries that are not sorted properly; all the others are.