Recent content by abcman

Hi There, I had the same problem and if you found the solution then i would appreciate that you tell me how you went around the problem. Thanks a lot.

Thanks. Someone told me that it works this way but I need to re-formulate this in a way that Access would accept it. Can Some expert please provide a hand of help. Thanks.

This is not my question. I know what you have proposed. I want to key in a date and the computer checks as a criteria if it is available between in and out. Hope for everybody help. Thanks.

Hi All, How can I write this in a query - Criteria : LIKE [Enter Date ?] = BETWEEN [Date_In] AND [Date_Out] Please note that Date_In and Date_Out are fields and I want the query to ask me a date and then if it is within both in and out it will give me the record. I tried this sentence but...

Thanks Guys, It is logic for sure. I had a look at your site yesterday on what you have posted. It is not easy for me to transfer that into a code as I am not an expert in VB. Anyway. Thanks Paul and Brian.

Hi and thanks. I think that I am doing something wrong and that is why I am not getting the same result. Would I be so rude if I ask you to send me the sample that you have showed here as an attachment ?. I am sure then I will know what is going wrong. Thanks in advance.

No I am sorry this did not work out and there was no result. Is there like a criteria I can add on my query that will provide the answer ? Thanks again all for the hand of help.

Hi All and thanks in advance for the help. I created a database with the following fields : PatientName which is a text DateIn which is a date DateOut which is also a date If the patient was in on 01/01/2012 and he was out on 10/01/2012 In the format (DD/MM/YYYY) it is so easy to get the...

Stopher thanks for the example but maybe I was not clear. I am trying to fill a form with data. One field I select, upon so another field is been Looked as it gets the value through the Dlookup. I would like both fields to be saved in a table as the one I look for using the Dlookup is not...

Thanks for the reply, In fact I tried this but still it did not update. I did add the code for the afterupdate in the ProductID and it simply did not update my Unit price field. Any other solutions or is there an example I can look at ?. Thanks.

Hi there, I made a Dlookup textbox to get a value from a table which is my main price list but need upon filling my form which holds a field called "UnitPrice" to store the value in that field but it does not as it is unbound. Is there away to go around this ? If there is an example it will...

Hi everybody. Please please please help. I have a Dlookup statement on an unbound textbox and I need to pass the value to a bound textbox. I have read few replies on the net but seems not to be understanding how to do it. Is there a live example someone can show me or assist me on this ...

Thanks for your reply. In fact what I am trying to do is to make a very simple Point of sale system where you click a button and it adds the content of this button to a list then another item will add to the same list and at the end we print this list. Do you have a demo or something that can...

Hi there, Is there a way assign a value to a command button and when I click this command button it automatically adds this value to a list on the same page like a combo box or a list box ? Thanks a mill.

Excellent. Thanks but how do I make a button that adds to my subform. Do I assign a value to it or what. 2nd. Is there an example made where I can look at and maybe learn ?. Thanks.