As count how many sheets has a file Excel using VBA

Hi All,
I searched is forum for help on how to put password on forms (or just put
some kind of restrictions) and didn’t find anything.
I want to allow certain users to have access to certain forms in my MS

I want to delete all records older then one year from now.
What would be the best datepart-syntax or SQL command?
Thanks

I used to show BMP logo on a form which is linked to a table where
BMP
is stored as OLE OBJECT.
I can not show new uploaded BMP files as Content but instead as icon.

I use this entry in the data source for an unbound text box on a form in
Access 2003: =[CurrentDB].[Properties]("AppTitle") and it works fine.
When I try to do the same in Access 2007 I get the ?Name response. The
application title does exist in the 2007 version. Also, when I type ...

I'm sure this is simpler than what I've been trying.  I have a combo box that
displays hyperlinks from a table.  Works great, but you must click the
hyperlink selection twice from the combo box to make it work.  The hyperlinks
just go to generic documents located on the server.  ...

I have a form with a number (=the number of the current week)
Next to this number I have 2 pushbuttons: + and - to increase and
decrease the number (getting next or previous week.
On this form I created a subform. I get data from a table matching the

I have a form in which I have set the Navigation Button property to NO.
I have created my own buttons (btnPrevious and btnNext).
I have used the following Code in the form_Current Event:
       btnPrevious.Enabled = Not Me.CurrentRecord = 1

I've bilt an on screen calculator.  It works fine.  I now want to tie in or
attach the number keys on the keyboard to the command buttons on screen so
that the user can either click on the command button on the screen or enter
the number by using the keyboard or a combination of ...

I am trying to pull the value of the subform onto the main form which works
OK when there are records on the subform. But, if no records I get:
Run-time error '-2147352567 (80020009)':
You entered an expression that has no value.

Using access 2003.
I have a saved table query called timeSchedule.
timeSchedule, StaffNo, TimeTableNo, DayNo, StartTime, EndTime, ChargeNo,
NoOfHours,

I've noticed when running my forms database in Access 2007 under Vista that
when I click some of the command buttons, the buttons appear to stay
depressed (that is as if they are toggle buttons).  On XP, it doesn't do this.
Has anyone seen this?

I've used Allen Browne's Locking bound control codes
(http://allenbrowne.com/ser-56.html) to prevent overwriting data accidentally
My On Load property of the form is set to
=LockBoundControls([Form],True)

Why is the Me.Dirty condition false in the close event of a form?

I have a simple form with a tab control containing two pages. Each page
contains form controls such as text boxes and subforms etc. No problem. I
have to switch record source as each page is activated etc.
When I open the form the page selectors (tabs) themelves are just out of