Search results

Ok, I am not a database design expert either, although I wish I am. :-) I have a design that was already set up and so I am just trying to expand upon it and built forms to filled the tables of the database and then creating queries etc. I do this for the purpose of get use to having the...

Hi, thanks. I follow your steps, " go to Property Sheet and set the property ShowDatePicker to Alwais." In property sheet, show date picker, I only see For dates and never. Those are the two choices. I was looking for a calendar pop so user can choose the date and also a time for that...

Ok, thanks, have any idea or share any clues on how to do that on both of them?

I have both 2007 and 2010 installed but I use 2010. There is a difference with using both of these to accomplish this? Thx

Ok, thanks, I got the start time to work. When a user selects the seller combo box, the start time automatically appear with the date and time. How about the end time, I have a text box that I would like to have the user click on it and choose a date and time, hopefully with a calender pop out.

Hi, I've created a form with a number of fields. One is a combo box, label as "Seller" and the second one is a text box, label as "Start_Time" and the third one is a text box, label as "End_time". I wanted to have a time stamp on the "Start_Time" field when the user selects a seller in...

Ok Pat, thanks for your advice. I wish I am an Access expert like yourself, but I am not, I am just getting to be familiar with it. What I am trying to do is to build a database from scratch and create forms that is both convenient for the user as well as efficient without any redundancy and...

I couldn't find the CD to install it on my new lab top, but I have installed it on my old one. Without the software I wonder if I could extract it from the old lap top to the new one. Thanks!!!

I have MS office 2003 software installed on my old computer, do you know how and if I could extract the software and installed it on my new computer. Do know if this is possible. Thanks

Hi, I don't have Microsoft office 2003, I used to have it installed on my computer and also the file to download it, now I don't. I only have 2007 and 2010. Would 2007 work?

Ok, thanks. you meant Access 2010, the Northwind Sales web database ? And which form and table should I look at? Thanks

any examples? Thx

Ok how do you do this? I need to do this, so I don't creat two forms to input two tables.

Hi everyone, I created a form that allows users to enter data into the fields and populates the table. But can I have it do that and populate instead of one table, two tables? Thank you

how come it works like this in the select datediff("h", [apt finish time], [apt start time]) as difference but not in the where. I noticed I do see some negative numbers, with my code there isn't any negative numbers. the first being the start and the second being the finish with this...

only limited in uploading some of these files types and limited by size. I will forward a sample in text file after I put them together.

I tried that already, same error. I will post some image of the import data/time type and my conversion of the datas and time and then how I lead to where my error now occurs. The best I could do is post image and not a database or file right?

I tried it and still have the same error, "data type mismatch in criteria expression". I also noticed you have apt finish time, apt start time and apt finish time again. I didn't know datediff can have three values, even if I take out [apt finish time] there is still the same error.

I'll remember that. Thanks.

the error only occur in the where clause, if I take the where clause away, the code has no error.