Search results

I actually need to this in one table only so for example: First Field data aaaa1111 Once, I have deleted it and changed it to bbb1111, the second field would have aaaa1111 value. Once I changed the first field value again to cccc1111, the second field would have aaaa1111 and bbb1111 so the...

Hi there, I have two fields, one is for the recent data/information a record has while the other has to comprise the first field history information...how can I do this? Any idea? Thanks!

Thanks for all of your reply. I did it already and it is similar with what Brianwarnock suggested...

I actually have list of coupons that were entered based on the first and last numbers of the coupon series. Upon retrieval, not all coupons within that series will return. What I would want to do is, I have a search box in a form that when I entered the returned coupon number, it will return...

How will I do it on code when I need to find a number between ranges. Example, i have a range start and range end fields. record number one start is 1 and end is 5, next record starts with 6 and ends with 10 and so on. Once I have searched the number 3, it will return the first record. Help anyone?

Hi Galaxiom...I quit on doing it on code and have sorted it out using query instead...:D Thanks anyway! ;)

Still getting the same error message...:(

Thanks for your reply...I've done that but now I'm getting Runtime Error 3061...it said that too few parameters. expected 1.

Hello there! For the access program I am going to do, there is already an existing data. I had imported it from Excel. Now, I have created a URN field from the look up table and wanted to update it to the main table which comprises the existing data. I've used the following code but I keep on...