Search results

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...

I have my Access program set up in my office like you have yours, on a file server with the back end and each user with their own front end etc.. It seems to work the best. We have other offices in different cities that want to use the data as well. My IT guy said terminal services was too slow...

That's what I am doing and starting to seem a bit more difficult than I first thuoght. Will be good training at least. Been awhile since I've done any network stuff. Thanks Again for your kind reply and assistance.

Thanks for your reply. I was hoping to use my own sever and avoid having to pay 3rd party fees etc. I read somewhere you can use IBM DB2-9 and set up in similar fashion using my own computer. Doing it this way I could distribute the front end to all the users and they could link to the tables...

Hello out there to the many Access gurus. I have an Access 2007 Database which I have been working on for some time and works fine on my local network at my office. I am now ready to beta test it and would like to set up a few front ends on different computers in differnet locations that are not...

Thanks for your kind reply. I was trying to do that using an event procedure and combo box like above but was having trouble here. I will keep working at it.