Search results

Here it is again, ajetrumpet!!

You are just great, ajetrumpet!! YOU ARE WONDERFUL!!!! I just want to thank you so very much..it looks great!!! I gave this thread a #5 rating because it was just what I needed!! Thanks again, Adam Noreene :):p:p

ajetrumpet I am sending a zipped db to see that will help. I need to be able to open form, click on dropdown, choose a class and have it autofill the detail section with name of everyone in that class. Thanks

What I would really like is that when I open my data entry form, it asks what class..then I type in class (ex. Children III or select it from a dropdown) and it queries all those names from tblmembersinfo into the form, (at this point I'll take any thing, single form,continuous, (but, I would...

I want it to autofill the names to my form that is based on the tblattendance. My form's controlsource is tblattendance. The fields for that table are name, class, date and attendance. The same as tblmembersinfo except tblmembersinfo also includes address, etc.

Sorry...you are on the top rung of the ladder and I am on the bottom and digging.. My term for class is a field in my table(tblmembersinfo). The table fields are name, class, date and attendance. I have several names in the table that are in one class..for instance, there are 10 children in...

Yes, that does group the classes together...but, how do I get it to autofill the names that belong to that class? I would like it to (on a continuous form) to list each name that is associated with that class so that all I have to do is check the checkbox for those that are present. I have the...

I have a query for the combo box that is based on tblmembersinfo that pulls name and class. But there are several names for one class. When I select a class from the combo box, it has the class in there several times ( the number of times listed) in the table. I need the query to combine all...

Thanks, ajetrumpet.. You are correct!! I didnt have my form checked to allow data entry and my checkbox was unbound..It seems to just need some tweaking now. Thank you again.

Now I need help on the query for the form I have not worked in Access for a while and cant seem to remember how to do simple things!! I have searched before I posted this and nothing seems to be exactly what I am looking for so here goes. I have a table (tblmembersinfo) holding name, address...

Thank you PeterF...It works just great..everyone is so kind and so intelligent in this forum. I am grateful to all who have helped me. Noreene

If I wanted to put this calculation in code instead of the controlsource, exactly how do I do that? =DateAdd("n",([Tcards]*[cbominutes]/[Associates]),0) Thank you...

Thanks for your reply, Moniker. When I put this in controlsource of associates, it gives me #name, and when I try to put it in code it gives me #error.

Thanks to everyone, I have my db finished..except for 1 thing. On my form, I have an unbound textbox that I enter associates (number). This textbox is the last part of a 3 part calculation..when I enter the number of associates the next textbox(unbound) shows calculation (textbox name is...

Thanks to both of you!! By changing the bound column in my form form 0 to 1(which by doing this it didnt change the column info), it worked correctly in my report. Thanks so much!!!!

In my table and on the form, I have a combobox that the user chooses the plant the product comes from and the combobox has 2 colums: plantid(text) and minutes(number). The bound column on my table and form is 0 which of course is plantid such as CH. The table holds it correctly and the form...

Since I can get both Expected and Actual to calculate correctly but in different data types, how would I get the actual field to calculate in hours and fractions for minutes like the expected field does? I am hoping that if I can overcome that obstacle, then the Difference field will subtract...

The only fields that I bound were the TimePS and TimePE(time started and time ended). Expected, Actual and Difference are unbound. On Actual field: In Your case datediff("n",timevalue(timeps),timevalue(timepe)). This returned 00.00. On Expected field, I tried...

PeterF I used your calculation for Dateadd("n",(tcards*cbominutes/#associates),0) for the expected calculation and it works great. However, when I tried to get actual to work correctly by using datediff("n",timeps,timepe) it gives me 0.00. (This should calculate timestarted-timeended). It...

Ive tried that and I always get some crazy number...I may need to use VBA code but it would be so complicated for my knowledge that I wouldnt know how to begin. Thanks, Noreene