Recent content by mdg

That code worked great!! Does exactly what I wanted. Thanks so much for your help. You helped make my project better than it was...

Thank you for the code. I will apply it and see if it works and let you know. I was playing around with something similar but could not make it work. Is the +1 because there is no comma after the last exam number? Am working on another database at the moment and will get to this one later on...

I haven't been able to find any information on using the split function in the manner I mentioned. I am not that familiar with it either..

I am sort of stuck. What I have is the following. 1. Form: frmMain 2. tlb: tblEnrollment 3. [ExamScores] formatted for text - input data as follows: 72, 100, 88 etc... Could have as few as one exam score entry and as many as 6 exam scores, all separated by a comma. 4. [AverageScore] nuimber...

Thank you for your reply. I will give that a try.

I was wondering if there is simple way to do this. I have a single 'text' box on a form that captures test scores. The person inputing the test scores puts in all of the scores separated by commas (77, 85, 100, 75.5).. Up to 6 test scores can be placed in this single text box. The field is...

Thanks for your input. I will give that a try later on when I am done putting the rest of this monster together. I was hoping there was a built in procedure that accomplished the same thing but looks like there isn't any.

Thank you for the suggestion. I tried that and get an error "Invalid outside procedure error'. The error box reads: 'This error occurs when an event has failed to run because Microsoft Office Access cannot evaluate the location of the logic for the event. For example, if the OnOpen property of a...

I was wondering if anyone had a quick fix. Not a huge problem but is annoying. I have a fairly large table with approx 15k records. I have a form where I have a drop down/select control box that displays all of these records showing a few of the fields. I select one of these records to...

I forgot to thank you for your reply to my posts. I did in fact use your suggestion and it works just fine. I just now got back to this project and noticed that the postage was still not working, then remembered our exchange a couple of weeks ago. I looked up my post and did what you said and...

Thanks CJ_London., I will give it a try. I have to do something else right now but will try it later and let you know how it works. I was trying something like that earlier and was adding up funny for some reason.

Thanks for your response. I just got back to my computer and saw your post. There is a time stamp (date field) that is the primary key and only one record per day can be completed, so the last day (last record) comes up first when the form is opened. I attached a screen shot of the portion of...

I have 2 things that I would like my form to do if anyone has a solution that would be great. My database tracks daily activity at work and one of the forms has 3 fields for tracking postage used throughout the day and keeps a running balance as the postage is being used. So the form displays...

THank you for your suggestion. I am playing around with the options button now. It kills two birds with one stone. Much Gras...

Hello. I was hoping someone would know how to make it so only one (01) on/off control in a form can be set to -1. I have five (05) of these fields in my form for answers to select in a survey I am giving. (Answer1, Answer2 ....) See that attached form. I wish it would work so that If one is...