Recent content by GeorgeChr

I have another idea come up right now: What if i create 12 different tables (one for each month) and relate all the "name" columns together somehow and therefore create a query wich draws all the payments from all the tables into one so that i can see only one student? you think that is...

the query is based on a table called "monthy fees" which demonstrates the money paid each month by each student. If i do what u say then I think that I will have to type the student name 12 different times in the name column.. Im I right? That's why I created all these different columns because...

I have designed a query wich contains the following columns: name, september, october, . . . , august. I want to create a parameter so that when i open the query i'll be able to see only one month instead of all. can i do that? I only know to create parameters for one column not for the whole...

thanx for your reply rich, can you explain me a little more detailed though what exactly you suggest? I'm a "newbie" in access... PS uncle something this a community, we exchange opinios FREE OF CHARGE. If you want to make money built a website and advertise it properly.

Sorry I got u confused, let's start over. I have a query and one of its columns (name: Level) contains values that u choose NOT type (list box). I want to have parameter which prompts the user to choose one of these values. About the form, I have a form based on that query but as far as I know...

from a form

what do you mean create a small pop up form?? I have to create o form based on the query first and then that? forgive me if i'm asking silly questions, i dont have experience..

I have a query which have a column where the values are chosen by a drop down list box (the name is "level"). I want to create a parameter where when someone opens the query he will have to choose one of these values to see. instead of the common: please enter name for exapmle, I want to be...

I have stuck in something and i hope someone will help me with this: I have created a DB which shows all the students of a musical school. Each student pays a monthly fee (sep-june, 10 payments per year). I dont want to create all these columns in my main table beacause it will be too crowded...

Acces Security related.. I have created a very good looking DB for my job and I want to be sure that noone else besides me (the creator) will use in another pc. My question is: Can I do anything to protect the whole file so that if someone wants to copy it (in a usb stick for example) he won't...

Ok thank you for that, but since that i am new to access can you tell me a way to do what i want if i create a query?

Hi, I am creating a table in 07 and I want my table to be able to calculate the difference between two amounts. I have the column "price" which shows the total amount, another one called "money paid" which shows how much of the total amount they have paid so far and the third is "money owed"...

hello all! i have a large DB and i want to put in my forms a button with wich i can send an email to the current contact i'm viewing. Is there a way i can do this? thanks!!

Hello everyone! I have a S/B and I can't add new switchboard pages in it.. I dont know why!! the thing is that i try renaming the existing ones in the switchboard manager but when i open it to see my changes, they are not there!! it's like i never did any changes! I have room for an extra page...

ted thank you very much, the second code worked perfectly and i can now open the S/B and have the form automatically closed. The first one I still have problems.. If you dont mind i attach the code so that you can tell me where exactly i should place the code. thanks though! Private Sub...