Dear Experts
I used continuous form and I have Value1 and Value2 and I used Unbound
textbox1 to do Value1+Value2 after that I used another one Unbound textbox2
on form footer

I have a query that has a date criteria that is in a range.  For example it
runs from 1/01/08 to  03/31/08.
Is it possible to change the criteria so it always run the past 3 months
from the date is was run.  So for example, if I ran it today (07/18/08) the

Is there any way to hide/reaveal the ribbons in access 2007 using VBA?  
Specifically, I want to hide all of the standard ribbons except when a report
is brought up in print preview.  Then I want the Prent Peview ribbon to show.

Can anyone help me to find error in the following code.
I created a form with 6 comboboxes and write the ollowing code with the
guidence of  www.fontstuff.com
But, when i press the button 'Apply Filter', again, a window prompts for

hi i have two hard drives one has vista installed the other is empty, my
question is can i install my xp home on the empty drive so that i have both
os on the same computer and if so can any one tell me how to do it
thank you

Hallo an alle,
ich muss mir ein Diagramm mit Access erzeugen und weiß nicht wie. Kann mir
jemand mal einen Tip geben?

I get a download from as/400.  There is a particular field call "postdate" ,
which appears as  20080101  -   year, month, day  how do I convert this in
my query to 01/01/2008 in access 2002?
Cheers

How do I protect source code from MDE Unlocker ?
Thanks.
Chlaris

my query is full, but I need more columns.  Is there a maximum numbers
of columns you can have? On a similar note, say I was to "cut" columns
from the design of my query, how would I then "insert" more columns?
Thanks

I have 2 tables with identical structure and different data:
Table 1 Fld1 Fld2  Fld3
       1     x    A
       2     y    A

how can i put a time limit on how long a database stays opened? I have
problems with other users opening it, making changes then forgeting to close.

Greetings all...
I have a report with a subform window in it.  This code is placed in the on
open event:
   Me.RecordSource = myfilters.GetFilter(getMainForm(getSource(Me.OpenArgs)))

I am trying to import a flat file that contains Highschool student ACT
scores.   These will come to us on a cd.  Here is a link to the format
of the file.
http://www.act.org/aap/infosys/pdf/790Test08_09.txt

I have several simple tables made with autonumber fields (Primary key fields)
created automatically for each table.  I have defined the relationships
between the tables as one-to-many.  
Now the next step is to create foreign key fields in my 'many' table from my

I have 2 tables with identical structure and different data:
Table 1 Fld1 Fld2  Fld3
       1     x    A
       2     y    A