Query to add data from form into table

[acwest]

Hi,

I am trying to create a simple library system that allows loaning returning and reserving CD's So far i have done issueing and returning loans.

However i am a little stuck on how i would reserve a CD. So far i think it would be best if lets say the user opens a form and their will be two list boxes, one populated with the CDs they can borrower and one populated with the list of borrwer IDs, and also a text box which allows the reservation date to be entered.

How would i make a query to append this selcted information from the form into the reservations table.

Attached is the reservations form.

Any help really appreciated.

 

[acwest]

Ok no need to worry about the reservation problem anymore i have doen that.

However does anyone know if it is possible to insert the date AND time into a text box with a date picker?

 

[boblarson]

Yes, you can, however I would use a non-ActiveX control method instead. For example using this type of form based calendar.

 

[acwest]

Hi thanks for the reply,

I just downloaded that but it only inserts the date. Is there a way to do this with an ActiveX controller?

 

[boblarson]

What time do you want? Are you going to be choosing a date and a specific time? (for example choosing

3 Apr 2011 8:00 PM

If so, I would still use the other and modify the form and such to add the time, or do a search. DCrake has posted a sample with a bunch of different calendar (and perhaps time) items there. I really, really STRONGLY suggest you avoid ActiveX controls because they usually cause more problems than they are worth AND they are at risk of not working in future versions of Access. For example, all of those people who used the Calendar Control - MSCal.7 control are now having to redesign things because Access 2010 does not have that control nor does it let you use it.