I want to add all sub-totals in my sub-form to a total in the main form. How
do I do it

hi can someone tell what is wrong with this coding i keep oon getting an
error message saying debug
If Me.password.Value = DLookup("Consultant_Password", "tblconsultant",
           "[Consultant_ID]=" & Me.con.Value) Then

i have created a button which allows me to add a new record on a form which
is saved in the database.  i want to edit this code for the button to allow
me to add a new record but only clearing out the detail section on the form.
i want the header section of the form to stay the ...

While entering code after I type me. I used to get a list of available
objects for selection and quick typing. I still have the auto member list
flag set but the list goes away about 2 seconds after I type the dot after
me.  Is there another setting somewhere that controls this ...

"Cannot enter value into blank field on 'one' side of outer join."
Anybody?  I added a field from a seperate table to a query in the be and fe.
Only certain cells return this specific error, the rest work fine.

Is it possible to like two forms together via a certain field?  Specifically,
I do most filing of info off of the "Job Number".  I want to link the service
form to the main job form, ie when I switch records in the job form, can I
make it jump to the corresponding Job Number ...

If I sign an Access 2003 mdb with a code signing certificate that I
buy from a CA, what happens when that certificate expires? This is
where time stamping comes in, correct?
I've been reading about this on a few of the CA sites, and I don't

I have a form that has 10 toggle buttons, within an option group.  Each
toggle button opens a specific report, based on a unit selected via a
checkbox.  For example, the code for one of the toggle buttons is:
  If opgREPORTOPTIONS.Value = "1" And opgSQUADRONS.Value = "1" Then

I have a database to compile data on attendance & absenteeism.
I have over two years of data. Two ways to look at the absenteeism: monthly
basis and 12 months rolling (last 12 months).
I am looking for a formula that would give that 12 months rolling in my query.

The "Attachment" data type does not show in the dropdown list. Is there a
preference or setting I'm missing? And yes....it is Access 2007

I am currently supporting and developing several split applications wherein
the backend data files reside on the server.  Now that I have a laptop, I
would like to work on them while on the train, around the pool, etc., making
changes only to the front-end, but needing a ...

I'm at my wit's end on this one.
Hopefully I'm just doing something teminally stupid and not seeing it.
When I pass some parms on the stack to a subroutine, they are not
getting through.

I presently have Microsoft Office 1997.  I would like to install MS Office
2007 but can I be assured that my data in Access will be readable and useable
in the higher level of Office?

 I've a query that contains the General date field "recieved",I want to
count the variance in days between the values of the recieved and time(),so
that i may get the result formatted hh:nn:ss

dragi  nasi,  kako ste,   love   ante,  nick,  & drita