Help with form

I have a fairly complex form that I have come up with for the ambulance company I work for. However I can't get it to do a couple of thing and I would really like some help. The call taking and dispatching form is the on I'm having problems with. The subform in that form should show only the calls for the current day however my inexperience is cause me problems cause I can't figure out how to make that happen. I don't know if is possible or not but I would like it also to be able when you click or double click on a record in the subform it to pull up the same record in the main form. I know that I may be asking for the impossible but if someone could just take a look and tell me how if possible or if it's not possible just let me know. I 've tried to attach a copy of the DB however the it keeps saying the file is too big. So if you have a FTP I'll sent it to you.

If the main form and sub form is bound form then by placing query in the recordsource property of subform like "Select * from tableforSubform where datefieldinsubformtable = #" & Date() & "#". Access is one of the most powerful yet programmer friendly language with which you can do a lot. If you can post your db by zipping it, I can give you a correct answer. you can directly mail me supersubra@hotmail.com if it is less than 500K.

I tried to post it but for some reason it keeps saying the file is too big......it is 934K so I don't understand why it won't post......any other ideas on how to get it to you to look at?

Have you tried with zip format.Otherwise create a new mdb and place form and blank table structure or preferably with one or 2 records and compact it from tools database compact menu and zip it. It will be definitely of a smaller size.

Give me a few minutes and I'll do that........The 934k is a zip

Go to Yahoo breifcase. Get a free FTP site and put it there and let us know the username and password (probably send it thorugh private message) and we will look at it.

S-

Ok.....I'll let you know when I have it set up......Thanks

Okay Ryan

Which form are we looking at,

And give me a detail explanation of what you want this form to do.

S-

You are looking at the Call Taking and Dispatching form. Here is what I would like for the form to do. The subform should show the runs for current day only also when you click or double click on one of those runs it fills in the main form. If there is a way to do it when the inservice time is filled in I would like that run moved to a new table called Completed Runs.....I have know Idea how to do that. If you have anymore question please send a message and I'll write you back

Okay lets see if I understand you

You have a main form, that displays all needed info for editing and adding records. You want a subform that will display a listing of all the records (for that day) that you entered from the main form. When the run is complete and you edit it complete by selecting the run from the subform by selecting from the subform and the transferring it to the form, then when you complete your run you wish to transfer that info, out of this temp holding table in to a completed table.

Am I understanding you correctly


S-

That sounds correct..........I know I'm not very good at explain this stuff but thank you for being patient with me.

Ryan

I uploaded you DB again

I tweaked your form a little bit, You can play with it and do what ever your want to it (frmCallTakeDisp).

I didn't add the feature that move a complete run to a different tab le becuase I didn't know which table to move it to.

Personnaly I would just leave it in the same table and just not display anything with an inservice date.

Let me know what you think and what else you need help with.

S-

Ok.......It is amazing what you have done......it looks great!!!!! I agree that just limiting them so that run don't show if completed but I don't know how to make that happen could you make that little adjustment for me. My boss is asking for something that I don't even know is possible or not...... if we have a patient that goes every monday, wed, and friday is there a way to put in all the runs at the same time, of course this is just an example. if it is too hard I understand. Just let me know ........Thanks again for all your help.

Make it so that complete runs don't show

Adjust the query driving the ListBox so that in the criteria of the len(InService) =0


Yes it is possible to Duplicate scheduled Runs and then just change certain info.


You would make it so that you are looking at the Run you wish to duplicate. You would create a cmdbutton that says duplicate. In that cmdbutton you would execute an insert query that would take the values from the current "conf" and add it back to the table. and then have it display the new conf so that you can edit it.

Think through what you need to do, I will help you where you want it.

S-

Thank you again for all your help.........I'm going to try to make some changes that you have suggested and I'll ask for your help when I get stuck again........Again the form you came up with looks great.