Search results

I am sorry ... maybe someone else will give you the solution you are looking for. I can not, with a clear conscience, give a solution that I know is not correct solution. RDH

Sounds like you may have the "Data Entry" property for the form set to Yes ... it should be No if you want to see existing records also. HTH RDH

Here is the same answer I gave at another site where you posted this question. What you are trying to do is store the results of a calculation in a field in a table. Unless you have a special reason for this .. it violates Normalization Rules and should not be done. You should always...

I has no effect on our relationship .... As I said ... it did not offend me .... I just believe in this case credit should have been given to QDS who stopped what he was doing to freely help you with the problem at hand. I think enough has been said and we need to carry on ..... RDH

I have answered thousands of questions on the internet at many different sites and I have never went to another site to ask a question to specifically get the answer to another question asked by someone else in a different forum. I find this borderline "Plagiarism" .... RDH

It's just you didn't answer the question and you gave no credit to the person who did give the answer. This does not offend me ... it's just the way it was done ... doesn't leave a good taste. I think that proper credit should have been given in this case. And if you didn't notice .... I am an...

What is strange about this reply is that it is "word for word" the exact same reply as given at the location below: Same Reply As This Only difference is that "this reply" was made 10 minutes "after" the one at the linked location. RDH

Does the form contain a subform ....??? If it does .. then the form record (parent record) will be saved when you navigate to the subform .. so it must be deleted at that point. But if there is no no subform ... Me.Undo should do the job. RDH

I don't quite understand your question ... If the ending time spans past midnight ... it will not be the same day. You may be referring to "workday" ... but Access does not care about workday when attempting to calculate the elasped time between the two time values. Technically .. under normal...

In defense of Jack ...... If you would have only used the phrase "Export to Excel" in your original post you may have gotten the correct reply sooner. RDH

If the ending Time value will span past midnight ... you will have a problem due to you only entering a Time values. If the Date and Time is entered you would not have the problem. You simply use the DateDiff() function to calculate the elapsed time. If your total elapsed time will never span...

Access or the user has Canceled and operation. Access will generate the error code 2501 when this happens. You must add error handling to your code to capture the specific error number and handle it accordingly. HTH RDH

You use the "Default Value" property of the field in table design. To populate with the Current Date use: =Date() as the Default Value. If you want the Current Date and Time use: =Now() as the Default Value. HTH RDH

You should to validate the entry using the Before Update event. This way you could invoke the "Cancel" argument of the procedure to stop the control from loosing focus. Also to select the text in a control use: Me.InvoiceNo.SelStart = 0 Me.InvoiceNo.SelLength = Len(Me.InvoiceNo) Loose the...

More than likely to recordset returned from your query contains no records ... this will cause what you describe. Check the query that the form is bound to to see if there are any records being returned. HTH RDH

If only the time values are entered ... and the ending time spans past midnight the result will be incorrect. Entering the Date and Time stops this problem but if the elapsed time will never span more than 24 hours ... follow the link below to a work around and more info on this problem...

You can create a custom menu bar and remove all standard menus. You can put only what you want in your custom menu .. this includes leaving out the Exit command if you want. RDH

If Access is used as the backend file .... nothing but the tables and relational join information goes there. Everything else resides in the frontend file. HTH RDH

Go to the link below where I posted complete instructions on how to do this. Stop Users from Closing Access with X control in Main Menu HTH RDH

No problem ... You are Welcome ... :-) RDH