Report in Certain Order
Mon, 29 Sep 2008 23:29:00 -0700
I have a Report that is sorted on Plot Numbers which is a Text Field and
includes Entries like 1A, 1B, 2A, 2B etc.
The problem is that when I run the Report the entries list as 10A, 10B, then
down the list is 1A etc. I would like the report to list 1A, 1B, 2A, 2B, 3A,
3B etc in that order.
Is there any ...
|
Problem with currentdb.execute
Mon, 29 Sep 2008 22:51:05 -0400
I have the following code in my unload event. Even though ls_SQL is set to
a value which works OK when copied into the query window, only the first of
these actually updates the tblParameters table. Any idea what's going on
and what I can do about it?
TIA
LAS
If Not IsNull(txtLev1Privs) Then
...
|
Why is a db#.mdb created each time I close my database?
Mon, 29 Sep 2008 16:54:01 -0700
Every time I close my access database, a "backup"version of my database is
automatically created with a sequential suffix (e.g. db1, db2, db3...). Why
is this, how do I change this setting. ...
|
Finding the backend tables for a front end ?
29 Sep 2008 15:04:44 GMT
I have an mdb which is a front end using an odbc connection to read and
write some back end tables (non access). If I open the linked Table
manager I can see the varios tables listed (the remote ones) with entries
like;
SubsTable (DSN=New, Database=dialler)
MemNum (DSN=New, Database=dialler)
NewNum ...
|
Chart based on query
Mon, 29 Sep 2008 05:17:00 -0700
I have created a query in MS- Access 2003 and I would like to create a line
graph that takes the values from the query and builds a graph automaticall
instead of me going and changing the values manually every time.
Can some one let me know if this is possible?
--
Prem ...
|
Victorinox Convoy Watches - Victorinox Swiss Army Watches Discount
Price
Sun, 28 Sep 2008 18:19:31 -0700 (PDT)
Victorinox Convoy Watches - Victorinox Swiss Army Watches Discount
Price
Discount Watches : http://www.watchespurchase.com/
Victorinox Swiss Army Watches : http://www.watchespurchase.com/Victorinox-Swiss-Army.html
Victorinox Convoy Watches Replicas :http://www.watchespurchase.com/
Victorinox-Convoy.html
...
|
Wittnauer Belasco Watches - Wittnauer Watches Discount Price
Sun, 28 Sep 2008 18:19:25 -0700 (PDT)
Wittnauer Belasco Watches - Wittnauer Watches Discount Price
Discount Watches : http://www.watchespurchase.com/
Wittnauer Watches : http://www.watchespurchase.com/Wittnauer.html
Wittnauer Belasco Watches Replicas :http://www.watchespurchase.com/
Wittnauer-Belasco.html
Wittnauer Belasco Watches All Fakes P ...
|
|
|
MS Access
Sun, 28 Sep 2008 20:38:06 +0200
Is there anyone that could break down in laymen terms how to work with MS
Access? I have trying to make relationship with different table and I keep
getting this message "The index or primary key can not contain a null value"
but when I attempt to correct the fault it tells me that I can not, what in
the world? ...
|
Consolidation of multiple data sources
Sun, 28 Sep 2008 11:07:14 -0400
Hi,
I have always been an Excel guy and have never used Access until just
recently when a friend showed my how to use it to identify duplicates in
some very large spreadsheets I was working on. Now having seen just a small
sampling of what Access can do, I was wondering what other applications it
would be ...
|
Default entry in table
Sun, 28 Sep 2008 13:41:24 GMT
I have a table that has a path field to an extenal directory with pctures.
One of the field is "ID" I would like the path field to capture the the
following without having to enter the ID number manually, the pictures are
named to match the ID number: \Photo\ID.jpg.
I tried to use a query but the pictures will n ...
|
