Please consider providing instructions in the Access Help facility on how to
avoid entries in a Combo box from being sorted.  The "not sorted" facility in
the query section doesn't seem to work.  All the Combo box entries appear in
alphabetic order by default.  I want the items ...

I have a query that provides the following structure of
information:
1   1a    1ai
1   1a    1aii

Under certain conditions, I want a form to open with a particular control
hidden (i.e., not visible)
   Me.cmdButton.visible = False
Under other conditions, I want this control to be visible.  The default

I have a table that will be populated by user input into a form.
A user will enter the full URL of a site. I only want to store the domain
name in my table.
In SQL Server I can write a trigger that once the user inserts a full URL,

I hope you can help me with this.  
I have two forms:  Form 1 (to select project ID from the combo box) and Form
2 (AddProject).  I want users to select Project Id from the combo box and
then open Add Project form displaying selected project id.

I'm trying this in a secured database :
DoCmd.TransferText acExportDelim, , sTablename, sFilename
I'm getting a 3027 error, Can't it be done in a secured database?
Thanks

I'd like to create a backup function from within a multiuser database and
I'm aware that everyone should be out of it before doing it. If I'm sure I'm
the only one with the fronted open and I have no forms open - is it then
secure to copy the backend file to another location?

From Access code, how do I round to the nearest integer given a double data
type?
E.g. #1  round  "15.5" to  16
E.g. #2  round  "15.4" to  15

I have a default recordset of 24 records that are part of a contract that I
need to be able to duplicate and then just change its ID field to a new
value in all 24 records, so that I can then make the some other ajustments
to the new contract and have them as a saved recordset.

I have an external C++ program that write data to my Access database. I would
like to determine whether the program is running, otherwise, I would display
a message to the user.  
How could I detect an external process from Access code? Any ideas?

I have a call log (memo field) which locked from being edited by user. The
purpose is to standardized the memo look and prevent user to delete existing
memo's content. It can only added by using a few unbound field.
Example

In Access code, how do I extract fraction from a double value?
E.g. I want to extract 0.16 from 29.16.
     I also want to extract 0.16 from -29.16   Any ideas?

I have a form PrintInvoices that is based on a table Invoices. The table has
one field invnbr. The form has a control txtinvnbr with the control source
being invnbr and a default value of =DMax("InvNbr","Invoices")+1. The form
also has many other controls which are all calculated ...

I have a form that I use for order entry. I want to use the same form to
display the detail of an indiviual order.
When used for order entry, I need the form to be able to accept inserts,
updates and navigate through the entrire recordset of orders.  However, when

I need some code help in getting the file names from  C:\MyFolder\
and then adding names to an accessTable