I am trying to understand if Access can be used to develop a directory that
will be located in a secured website.  The directory will be for about 500
members and each should have the ability to edit their own information as
needed.

Right now, I'm doing this:
' ---------------------------------------------------------------
 Global Const gDateInterval_Day      As String = "d"
 Global Const gDateInterval_Week     As String = "ww"

I have a table made of the following fields: First_name, Last_Name, User_ID.
I would like to concatenate the First_Name and Last_Name fields into a new
field 'Name' in the same table.  So basically creating a new column called
Name that has the values of First_Name and _Last_Name ...

I'm writing an app that does reminders.
When creating a new reminder, the first thing I do is solicit
some info from the user and then spawn a series of reminder dates
depending on that information.

Got an app that keeps track of tasks that need tb done.
Original concept was that it would print a task list each
morning.
Now the clients want pop-up reminders on some tasks.

I created some new reports on my laptop and all was fine.  When I imported
the reports onto the server some fields in the report showed some of the
following errors: # Error, E + 0, +02.  Any thoughts?  Thanks.

I am linking a table from a txt file into access.
I set the field data type as "single", as I need the numbers in the txt file
However, the numbers that have 2 decimal places do not show correctly in
access table (they are rounded into either 0 or 1 decimal, and are not

My expression is
Format([Field8]),"00")
This should turn period 1 into 01, and period 2 into 02, so that 02 will
come before period 10,11 and 12 when it is sorted in the OLAP cube

I am bringing in a text file, modifying it for number formats, and then using
it in an OLAP within Excel. However one of the field is Period Number, 1 to
12, and I have tried formatting this to a number but it always ends up in the
OLAP as a general format which will not sort ...

Related to my earlier post about importing tab-delimited data to
a .adp (Access project), I found a reference which asserts that you
can't use import specifications with a .adp (as I found) but must use
a schema.ini file.

I tried ;"t";"f" so that one can type just a "t" or "f", else you need to
type in full i.e. True/False. Is there any other alternative to typing full
words? Thanks

I am trying to create a dynamic form.
I have a table with some fields like accounting_code, profit center,
value_1, value_2, etc. Each field: value_1, value_2, represents a
period of time. The user will imput values in this periods.*

Does anyone know of a painless way of resizing a form with all of its
controls, subforms, tab controls, etc in access 97 or 2000?
I created a database on a computer with a screen resolution of 1440 by 900.
Now I want to run it on computers where the resolution is closer to 800 by

when you put a picture on microsoft word, and then save it as microsoft
webpage. Then u open the doccument, why does the picture move out of place?
'

do we have an ETA when the Access 2007 Developer Extensions and Runtime will
be available for download?