Can anyone tell me how to remove the last 11 characters of a string?
Much thanks,
Clint

Hi
I have this code:
hellig = DCount("Helligdag", "Helligdage", "Helligdag = #" & start & "#")
There shall count days from a table if date (Start) is in the table

With Access 2000, is there a way to use VBA to import the contents of a Text
file into a Memo field of a table?

I'd like to be able to append a new record into an existing table, where the
data for the record comes from earlier in the VBA code; then I need to find
the Primary Key field for the record I just added.
I have code that adds a new record to a table:

I am trying to open and access fill using .Net 2.0  and the OLEdb. The db
opens but when I try to read the msysobjects with a select I get an error
that the table does not have read permissions.

I am trying to find a list of properties on the objects of an
MSGraph.chart.8.  Specifically, I am trying to set the colors of the lines
for the data series in a line graph and I do not know the specific property
name(s) to do this.

When I link to a SQL table from the Access File-->External Data etc it gives
me a chance to designate the Primary Key. That allows the linked table to be
updatable and insertable, without the key it is read only.
What I can't seem to figure out is how to add an index to a linked ...

I am working on a grade school database. I would like to set a field for each
grade. How can the field automatically update evey year? For example, a
student is in G1, the field will update to G2 in Sept. Please help....

I've tried posting this twice but no reply.
I am using the following code to export field info to an email but it works
fine ONLY when I first open the DB. When I try to click on the button again I
get the 2957 run-time error. The "DoCmd" line gets highlighted.

I get the subject error message when I run this query from Excel VBE.  I am
trying to populate a combo box in Excel by connecting to an Access database.
The connection string and sql for this as follows. Appreciate all advice
given.

Just need some help please with the syntax to make a Schema change in Access
from VBA.
For instance (one that works) :-
        Set tbd = dbs.TableDefs("tblAL")

I have a database that has been working for years with multiple users on a
run-time of MS Access. For some reason, one of the users started getting the
message,
        "Execution of this application has stopped due to a run-time error.

Is [] needed in definition of parameter query.when is it supposed to used?
Clara
thank you so much for your help

Disclaimer :  I'm a programming idiot, who is programming via patching
together examples I find from other people to accomplish what I need.
I'm hoping this is an obvious error that I'm missing just because I'm
overwhelmed.  I am extracting data from an Informix database, via ...

I have a database with 4 tables.  2 are from an external database called
controllers.mdb
This database is run in 2 places.  The primary location is on a server and
all computers on the server point to "r:\r&m\site_info_sheets\maindatabase.