Search results

Ok, thank you!

Ok, I did what you told me and this is the list I put in the row source ;1;2;3;4;5 the selection on the form only shows 1,3, and 5. Why is that?

Hi, I wanted to create a field lookup with values that I specify, not on the table sheet, but on the form. User can click on a text box or combo box and can select a list of value that I specify, not values that are listed on a table but ones that I type in, in the form. Can this be done...

Thank you! :-)

I have a AUCTION form, it has a combo box and the label for this combo box is called seller. This combo box is a look up to the USER table which has the following fields: uid, uname, city, state The combo box is pulling and displaying a drop down list of uname from the USER table, with this...

Ok got it. Thanks

I use 2007 and is the same result. The calendar pop up can only choose a date that gets populated into The auction table and only the date shows, not the time.

Upload the database, how do I do that? I have both access 07 and 10 installed.

Ok, I noticed another problem when I tried to separate the date and time field. I can't create a time field, where a user can choose a time after they use the calendar pop up to choose the date. I believe bc if the user have the option to choose the time, it will be difficult because each hour...

Ok thanks, I am in New York, would the Eastern Time (US and Canada) Bogota, Lima work Or should I choose, Pacific Time, (US & Canada) work? And when other members post, would their post be in my time region or in theirs, because if is in their time region then it doesn't show accurate time...

maybe is the time of a different region instead of the pacific eastern time?

Ok, after I have looked it over, I don't think is possible to choose a date from a calendar pop out and also a time and input this into the fields in the table. Because is not possible, I am just going to create a separate date and time filed. Unless is possible with one step.

what does reEnter dates mean?

how, you mean refilled the form? I just did that and it still shows only the date and not the time.

I was able to select General date after I ended and then re-opened the access application, but the end_date in the table is still shown as date and no time. I have a pics below.

I am doing what you are doing but I can't select it.

what I meant to say is that the start time in the table field has the date and time, but not the end_time, the end time is the selection of the date from the calendar, on the end date table field, it only has the date and not the time. do you know how can the time be there?

Ok, I see what you did, that work. But the time didn't get insert into the table, the date did. Why is that ?

Ok, I see what you did, the difference with yours and my text box that allow you to do that and not me is because my text box in not unbound. It the data tab, it has end_time the form's record source is AUCTION. The reason I did this is because I want when the user choose a date and time, it...

this is what I did from the instructions that you have given: Open up the form in design view, go to property sheet, click on the end_time text box, go to format tab, format your text box as date (how to do this?) And would there be a time, they are allow to choose for that date, if not how...