How can I display Time in minutes and seconds only.  What I need is the
ability to display hh:mm:ss in only mm:ss, this means that the hour needs to
be converted to minutes.  I'm not sure how to go about doing this.  Any
assistance would be appreciated.  thanks

I have a data access page that the DataEntry property is set to true and I'm
getting the following error message when it loads:
"Either BOF or EOF is True, or the current record has been deleted.  
Requested operation requires a current record."

I need to determine if a control has the "Locked" property during code
execution as follows:
   Dim ctl as Control
   For Each ctl In Me.Controls

having created a database and a main switchboard, i tried to open the
switchboard but failed with the following error message "Run-time error
'-2147024769 (8007007f)': Method 'Connection' of object '_CurrentProject'
failed".

I'd like to know if it is possible to initiate a menuless instance of
Powerpoint in slidesorter view on a A2000 form ?
If so, how ?
I would like to be able to sort/reorder/project my vba automation-generated

Is there a way to get the first letter of each word in a field to go to
capitals.  For example, if user enters the surname "leigh-smith" it would be
stored as "Leigh-Smith".

When I use the code below
Sub FieldOutput( )
   Dim prpLoop As Property
   Dim db as Database

i keep getting this error:  Function isn't available in expressions in query
expression '(Format([Date],"DDDDD"))'
my database was working fine and now half of my dates do not display and my
charts are not working due to this problem.

I would like to simulate the PP slidesorter on an A2000 form along with a
Project! cmdbutton that will project the selected slide.
Something similar but very basic is here
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno2k3ta/html/O
fficeAccess2PowerPoint.asp

I have a database that has 5 different tables (A,B,C,D,E). Each table has a
primary key field called id. We needed data entry to be done using one form.
So I created the main form using the fields found on table A. I created
subforms on this main form so I could add the fields ...

I have form that i would like that the code won't continue until the form is
closed.
For this i open it as dialog
Is there a way to show the form in this case not as dialog?

I have a public procedure that checks the values of several fields in a
table before the calling routine can do further processign. The procedure
can be called from a couple of places. First it can be called from the form
itself where the fields are bound to the controls on the form ...

I would like to use the selection in a combo box to follow a hyperlink. I have the combo box displaying  the description and the actual address (http://ipaddresshere). So there are two columns in the combo box, although I could do with just the description if it makes things ...

I'm trying to enable a textbox and a subform upon a checkbox being checked.  
The checkbox defaults to no and other 2 ctrls default to disabled upon form
startup.
I would like the "disabled" state to reset for new records. Right now, if I

I hope you can help me.  I am using Access 2000.  I am trying to assign a
number to a record in a form that starts with GO1, increments by 1 and then
ends with a CountyID.  The CountyID is a field on the form that the user will
fill out.