Recent content by ipaqAccess

Hi, I got a table contained fields below: Part number. Review status 1 Review status 2 Review status 3 .... Review status 10 Latest Review status. (this is the field that have the value of the latest Review, assume 1 is the 1st review then after that is 2 ... until 10. Field has not have the...

Hi, I have table Parts with Fields: - Part number: Contain part numbers - Description: Description of the parts. - 1st Sample: Contains either "Approved" or "Conditional Approved" or "Rejected" - 2nd Sample: Contains either "Approved" or "Conditional Approved" or "Rejected" - 3rd Sample: As...

Hi, I've been searching but could not find a way to solve this. I have a Form with List box that list the items and several text boxes that display info of the selected items in that list box. So I use the Dlookup in the list box so that the text boxes will auto update the info regard to the...

@missinglinq: I tried your guide but unable to make it work. Wonder if the issue may be the Screen.PreviousControl? but have no answer for it. Thanks a lot.

Hi, Thanks for your help. Sorry I was busy with another project that couldnt take a look into this till now. I have attached the file that I'm currently working on. So what I want to do is under form FA Date Update. There are about 12 text box that display date. User will have to select one by...

Hi, Hi, I'm using Access 2010. I know that the date picker for text box are built in for text box. But you need to click many times to select the date. So what I'm trying to do is to have a date picker always appear and save sometimes for the store admin as she need to run through about 400...

Hi Trevor, Thanks for your help. But it's not. These 6 text boxes do not hold the same value. E.g I have a list of items. Each items have Buying Date, Shipping date, Deliver date, Return Date..etc.. So everyday store admin will go through the list and update the date of each items. So instead...

Hi, On my form, currently there are 6 'date' text boxes and one calendar picker that always display. I would like the calendar picker to "auto-bound" to the selected text box, save the selected date and auto bound to other text box when you select to other text box. As I'm new to Access and...

It's helped. Appreciated for your time. In summary for anybody have the same problem as mine, there are 2 ways to get to this. I think your way is fast and clean for forms with a few columns, but if the form required more than 10 text boxes then I think using Dlookup is easier to manage...

Hi, Thanks much for your help. Currently I am using Dlookup to do what I wanted to do. But it required a bit of coding which i am not preferred. I would prefer simple settings that can do the work and leave the programming for more complex task. According to your solution, the Listbox should...

Hi all, I am newbie and trying to create a Form to checking the arrival/amount on stock status of a list of goods. So I have: Table tbl_parts with part number and description which Part number is the key. Table tbl_arrival with Part number and ship date, arrival date, and delivery date ...