Entering Values from a form to a table

[YoMate]

Hi Guyz!! How u doing???!!!

I am new to VBA, and i need some help in my system..... basically i am creating a appointments Form, and in this i have some txt fields and a listbox which contains the available times ... What i want my form to do is that as the user enters the values in the form and the time selected, as clicking the "set Appointment" button it should add the values to the table.

I have included a word document of my form: Just as some help... Could you guyz help me with the coding... I am not at all good at coding! Thanx alot guys.. I really appreciate your help!!

 

[YoMate]

I reckon i forgot to post up the word document ... I have now included it

 

[Uncle Gizmo]

If I understand you correctly, you currently have what is referred to as an unbound form. That is a form that is not linked to the data table that you want to store information in.

There are certain circumstances where you would want to do this, but in your case, it is not necessary or required.

You should be using a bound form, that is a form where the main controls are bound to the underlying data table.

You can very easily create a bound form by selecting the table or query you want your data based on and select "Auto form" from the database toolbar. This wizard will create a form for you with the basic controls on it. You will be able to modify these controls, (convert them to combo boxes or list boxes) and you can add other controls like command buttons.

 

[YoMate]

OK thnx ....I'll give it a try and see wot happens..

 

[YoMate]

Ok... I tried it... it doesnt work because... the availble times in the listbox does not work ... and on the other hand... what i really want is that as the date is selected on the calendar... it should show all the appointments for that day (on the top subform) and also the form should exclude any times chosen for that day... I'll post up a smaple of my database...and u can see...
U can also implement to show what was your suggestion.. Apparently i cannot post up my database.. it says its too big.... DO u have any e-mail to which i can post it

Thanx for all the help!!

 

[Uncle Gizmo]

>>>> DO u have any e-mail to which i can post it <<<<


Hello YoMate,

Welcome to this forum. It’s one of the best of its kind around and I like it because it’s an adult forum, What I mean is you can be yourself and you don’t have to watch your P’s and Q’s.

Regarding your question, the best thing to do is post your db in this thread (Cut it down till it fits). I suggest this because I’m by no means an expert on Access and if you make a public posting of your question it will be seen by many people and you get the benefit of this pool of expertise.

The other reason for posting your question in a public area is that other people can search the forums and find answers to their questions, so each question and answer provides a pool of free knowledge for world to see.

So I strongly recommend that you post your db in the thread as this is the best way for everyone, and someone will respond…

 

[YoMate]

Ok finally i got it.... huh....got time to cut all the fits and bits

ok i have attached the document with this thread... thanx alot for ur help gizmo.


Yomate