Search results

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

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

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

First of all I want to thank everyone here because before I was a total catastrophe with access and now I'm becoming an expert I think! But now I have some more complicated questions for you guys! here it goes: I have a welcome form that pops up when you open the DB and it has username...

Hello all!! i have created a very nice s/b and i want to add a clocck in it. I've tried the same way as in forms (label, adding the code in the form etc.) but it didnt work. Can anyone specify the exact code i have to enter? thanks in advance!

I have created a DB with many tables and I want to find a way where I can retrieve all the emails from every table (each one has a column with emails). Does anyone know what to do? If a record doesn't have an email address do I have to type N/A or just leave it blank?

I have created a switchboard and I've put some forms to open when you click the appropiate button in it. The problem is that when I open the form FROM the switchboard, I cant view the data in the form (only the layout such as buttons etc.). I believe that the problem has something to do with...

I have some forms created by parameter queries (the ones whith the pop up window) and everything work perfectly but when I put these forms into a switchboard I can't see the prompt window and therefore I can't use them. I've tried to figure out what's going on but I can't since I'm an amateur in...