Recent content by KimHuff

I am not really sure what level of help to expect from this forum, but I have less than 10 weeks until my event and it's been 16 days since my last post. I do not feel I can do this without assistance so if I am asking too much... does anyone have any other ideas on how I can learn this. It...

Well, as I stated in the beginning, I just dont know how to start. Here is what I have done already but I dont know how to tie things together. (See attached file) I have the Attendee (customer) info together and I made a form, but I need to add the ordering aspect of the database and I am...

Re: Time to put on my big girl pants WELL, looks like I shouldn't pull those big girl pants out so soon... sorry, I forgot the attachment. :o I am attaching the Excel Spreadsheet we used last year with some fake data in there. I also have attached the Access database a friend created. It...

Time to put on my big girl pants Well, I have been using Access for nearly 10 years now but I have yet to fully build a database. I have made databases but they were very basic that didnt really utilize a true relational database structure. I have had a couple built for me so I understand a...

Should I remain in this topic (General) or should I move to another location? For the last several years we have been struggling with doing this in Excel. Not that Excel is a bad program, but there was a great deal of double entry and typos. I know that Access is what we need, but I never...

PNG, I had not thought about doing it that way. It has been so long since I have played with Access and unfortunately, I feel like I am starting all over again with 2007. :confused: I think the part that always stops me dead in my tracks is figuring out how to begin. I know it is crucial to...

I have been playing around with Access for over ten years but I have never really created a true relational database. I have been wanting to create a database for a non-profit group I am involved with but I just dont know how to begin. I was curious if I could get some pointers on what is the...

Thank you for spelling this out. I have always wondered what this meant. Spelling things out like that really helps. Yea.. kind of knew you wouldnt be shocked.. that was the point. LOL I too am self taught with regard to many aspects of what I do. My problem is I rarely use Access...

Do you know a good place to get help on to use Instr and the Trim options you mentioned. Adding or subtracting a number of characters from there doesnt really help me. I know you will be shocked, but I dont know VBA very well.. I actually know enough to be dangerous. I can read through some...

Thank you guys for all of your help. I did what Namilam suggested and made sure it said Public before function but it still didnt work. Not sure why so here is what I did... and btw.. it is working. I copied the code and put it in another module that I knew was working and deleted the one I...

OK, I guess I am still not getting this. I went into the table and changed the names of all the fields to the following: Parent1LName is now p1ln Parent1FName is now p1fn Parent2LName is now p2ln Parent2FName is now p2fn I went the query and added the following to the query: parents...

Dear Brian, WOW! I wish I knew how to write functions like that. When I see what you wrote it makes absolute sense to me but actually writing it.. I would be lost. ;-) Anyway, I tried putting this in the query window as an expression and I keep getting a popup wanting to know the value of...

You all bring up good points. Here are more details. First, I receive an excel file from the school with all of the data in it. Everything is all in caps (I hate that) and is combined. For example, the student name is actually all in one field. So, I run a query that separates the first...

Dear Brian, You are correct there was a typo in my example. (I have got to start getting some sleep before I post!) When I wrote the initial message I was going from memory. The actual field names are as follows: Parent1FName Parent1LName Parent2FName Parent2LName SO, I took what you gave...

Well, when I initially tried to do this I had not split up the parent field. When I received the Excel file the parents were separated by two fields... Parent1 Parent2 So not unlike the examples I was giving you before you would have... Parent1: Kim Huff Parent2: Larry Huff I ran a script to...