We are developing a database to track attendance.  One factor we use is the
amount of occurrences.  For instance, I was out ill 12 day on two occurrences
for the year.  That means I was out two times in one year.  One occurrence
could be one day or 100 days as long as the days ...

Is it possible and practical to operate a database where the data is
held on the internet so that it can be accessed and modified by a
select few?
If so where should I start reading?

I have the following sql code that I grabbed from the sql view:
TRANSFORM Max(ChartQuery.amount) AS MaxOfamount
SELECT ChartQuery.period
FROM ChartQuery

Hi. I have a few access solutions and in one of it an important one I haveing
this problem and it seems that I'm not the only one:
Chinese/ strange characters
Post

I have a variable to link pictures to a form
   Me.ImgStock.Picture = "s:\pictures\" & Me.FOTO
Everytime the picture path is modified, i need to enter in all forms and
change the path to

Hi. I have a back-end and front-end solution in access.
As you may imagine, some users access to the same back-end database to
update data.
They don't usually use to update the same records.

Hello. I have 1 problem. I want to sum fields of numbers where it is formated
by IIf sentences. Therefore it can not be done, because IIf sentence is
written in "control source" (table doesn't save that number) and it is
impossible to write it in "Default value", sum is always 0.

I am able to create a macro to send an email message to my users, but how can
I populate the "To" field automatically?  My user's email address is included
on the query/report I run, and I would like to be able to send that
query/report automatically just to the users specified ...

Greeting,
I have a report which shows Students marks, in this report there is 5 fields
for Subjects and one for Total. There is one more unbound text box for
showing the progress. What I need to do is if the total text has grade <=39.9

Follows is my code:
Dim rst As New ADODB.Recordset
Dim con As New ADODB.Connection
Set con = CurrentProject.Connection

If I have a historical file in access, and then I recieve a file every week
that has the past 17 days. Is there a way to get access to merge JUST the
past days that are not included in the history.
So you have a report that is from 2/7/05 through 2/7/08. I recieve a report

I am trying to set up a table that will use a 6 digit consecutive number
with a letter prefix as the key.  I've got the format figured out, but how
do I start the numbering at say N100500 rather then N000001 ?
TIA!

I wish to read the regional settings with a access-visual basic program, to
read for example, the current language or the current date format of the pc
used. Can this be done with access-vb?
Thanks

On my data entry form using AC2003.  I have the following as the OnChange
event for a drop down combobox...
Private Sub Type_Change()
   If IsNull(Me.Type) Then

im unsure of my server provider (POP3 or IMAP) and where to find my SMTP if
anyone can help that would be great thanks