| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi,
I tried to execute the below command, but "WITH COMPRESSION " is not
accepted... What can be the problem?
CREATE TABLE D1_1 (D1_1_no INTEGER...
chrisdev
|
11-27-2010 05:33 PM
David-W-Fenton  | 21 | 22 |
 | | Hi John,
Here is how I would do the export given what you have said:
1) Create a 'target' database (mdb) with the filename as the exported
customer...
JohnP
|
11-26-2010 10:23 AM
JohnP | 11 | 12 |
| | | I want to run a macro after a record is added to a table. I was
looking on the property sheet but I don't see that option. Is there
any way to do...
Joe Smith
|
11-25-2010 01:14 AM
Tony Toews | 10 | 11 |
| | | I'm trying to come to grips with converting one of my Access 2002
applications to Access 2010 and have encountered a problem with graphs.
When I...
Bob Darlington
|
11-24-2010 07:17 PM
Bob Darlington | 5 | 6 |
| | | Hi,
can I open a form (maximised) and set detail height to be small? I set
form to be "single form" and detail occupies more than half the...
chrisdev
|
11-24-2010 12:10 PM
Marshall Barton | 1 | 2 |
| | | Hey there, im stuck on a rather easy problem...well apparently not for
me.
I have a Main form (F_Main) wich has 2 tabs on it (Basic and
Additional)...
Piotr Jaruga
|
11-24-2010 01:14 AM
Piotr Jaruga | 2 | 3 |
| | | Looking at a form in design view, I see a new tool called 'Navigation
Control'.
Stupidly, I thought that pressing F1 might help to explain it. But...
Bob Darlington
|
11-23-2010 05:21 PM
Bob Darlington | 6 | 7 |
| | | Simplifies SQL is
SELECT Questions.Question
FROM Questions
WHERE
(((Questions.QuestionID)=IIf(IsLoaded("Questions"),!!,!)))
GROUP BY...
Phil
|
11-22-2010 05:47 PM
Phil | 8 | 9 |
| | | We are moving our backend to SQL Server from the existing Access
database.The front end is still Access.I have set up the ODBC
Connection to the new...
Roy
|
11-22-2010 03:39 PM
Jim Devenish | 7 | 67 |
| | | One can't get the staff these days.
We have a problem that a database program is left running minimised. If this
is not spotted, one of our staff is...
Phil
|
11-22-2010 02:36 PM
Jon Lewis | 12 | 13 |
| | | Hi,
I need to change a table name referenced in > 100 queries. The queries did not pick up the rename of the table. Is there an easy way to do this...
Peter Clements
|
11-21-2010 08:27 PM
Tony Toews | 8 | 9 |
| | | Dear reader,
I need to position the cursor to a field, I use all the codes below but no
one of them moves the cursor to the specified... |
11-21-2010 02:57 PM
Barry Edmund Wright | 4 | 5 |
| | | Gartner says social computing to change the face of IT and business
Gartner has identified the impact of social media as one of four broad
trends...
JTP PR
|
11-21-2010 07:22 AM
Steve Hayes | 1 | 2 |
| | | When I open and close a database in 2002, a message appears: "There
was a problem sending the command to the program". The locking file
remains open...
Nance
|
11-20-2010 03:10 PM
Tony Toews | 1 | 2 |
| | | I have an A2000 mdb that uses CDO without any problems. The mdb was
moved to a computer with Office 2010 and Win7 and when I attempt to
email from...
Karl
|
11-20-2010 03:07 PM
Tony Toews | 2 | 3 |
| | | Hello,
I'm running Access 2002.
We use our database to print address labels and despatch order's live from
the form as they are packed and...
Nick Jones
|
11-20-2010 03:40 AM
Phil | 5 | 6 |
| | | Hi,
I have following code behind one of my unbound combo box:
Dim StrSql As String
strSql = "SELECT tblCustomer.CustomerCode,...
Shakeel
|
11-19-2010 01:58 PM
bobh | 2 | 3 |
| | | Office Button / Current Database / Application Options / Document
Window Options
if I select Tabbed Documents with Display Document Tabs is...
Roger
|
11-18-2010 04:43 PM
Albert D. Kallal | 1 | 2 |
| | | I've got the following parameterized query (ParamQuery) in Access 2000
(compatibility mode):
PARAMETERS INTEGER;
SELECT *
FROM SourceTable
WHERE...
Vern DeHaven
|
11-18-2010 08:06 AM
Bob Barrows | 3 | 4 |
| | | (Crossposted to cdma / mpa)
Does anyone have VBA code for modifying JET/ACE backend schema they
would be willing to share?
My company has a "work...
Clif McIrvin
|
11-18-2010 01:47 AM
Access Developer | 9 | 10 |
| | | Let's say you have a web hoster that supplies SQL Server. Can Access
link to the SQL server on the hosting site and use the database?
Salad
|
11-17-2010 10:36 PM
Albert D. Kallal | 7 | 8 |
| | | Hi,
I installed Access 2003 on my new Win7 64-bit system (that also has
Office 2010 installed but nothing else from Office 2003).
If I open almost...
PW
|
11-17-2010 08:08 PM
Douglas J Steele | 30 | 31 |
| | | For auditing purposes, I have a a table with 1000 records. I want to filter
for a criteria that gives me 100 records I want to audit, but I only want...
Derrick J
|
11-17-2010 06:19 PM
Vern DeHaven | 1 | 2 |
| | | Hi
is it possible to look for 2 different words in a body of text using
the like statement
thanks
kevin
kevcar40
|
11-17-2010 07:30 AM
kevcar40 | 4 | 5 |
| | | Yellowfin’s latest Business Intelligence (BI) application for the
iPhone and iPad is now available from Apple’s App Store.
BI software analyzes and...
JTP PR
|
11-14-2010 06:26 AM
JTP PR | 0 | 1 |
| | | Many of my reports have summaries / totals on the last page. For end of year
reports I only need these totals, not all the detailed stuff on...
Phil
|
11-13-2010 07:56 PM
Marshall Barton | 5 | 6 |
| | | Hi,
I have a report, the pagesize is A4, even my report only half (only
few record), is it possible to insert pagebreak for example after
group...
yanto
|
11-13-2010 09:51 AM
yanto | 2 | 3 |
| | | "David-W-Fenton" <NoEmail (AT) SeeSignature (DOT) invalid> wrote
Archiving must be done intelligently. Not all data gets archived or should
be....
Jim Devenish
|
11-12-2010 11:26 AM
Arvin Meyer | 10 | 11 |
| | | Dear reader,
How to speedup the performance of a MS Access application on a Citrix
server.
The performance is dramatically slow also on the new 64... |
11-12-2010 11:12 AM
Arvin Meyer | 4 | 5 |
| | | I want to run a macro depending on what a user enters in a specific
field. If a user enters a code (i.e., 1-A-CB939) that contains the
letters "CB",...
Joe Smith
|
11-12-2010 10:17 AM
Joe Smith | 2 | 3 |
| | | Dear All,
I am using the following query for retrieving data between customer
code
SELECT tblOrders.CustomerCode,...
Shakeel
|
11-11-2010 11:23 PM
Allen Browne | 5 | 6 |
| | | Anytime I try and compact & repair or when I try and create a backup
of my db, the program locks up. (returns a "beep" with each click and
I cannot...
WhathaveIdone?
|
11-11-2010 06:31 PM
WhathaveIdone? | 4 | 5 |
| | | Hi,
I'm totally flummoxed. We've had to change our change control
practices and I've been happily coding along until today. Goal is
that we need...
Stinky Pete
|
11-10-2010 07:42 PM
Stinky Pete | 3 | 4 |
| | | I have a bound form with a docmd.maximize in the form open event, this
crashes the system, even though I have error handling - it's been
working fine...
Roger
|
11-10-2010 06:33 PM
agiamb | 15 | 16 |
| | | Hi there
I have setup a search form that runs a selected query after a name
(text string) is enter.
Code from query - Like !!
eg An exact search...
Duncan
|
11-10-2010 05:14 PM
Duncan | 2 | 3 |
| | | I used the wizard to create a lookup and all is fine. I want to go a
step further. I want to lookup a field from a foreign table which in
turn...
JkingSJR
|
11-10-2010 01:15 PM
Salad | 1 | 2 |
| | | Dear Everyone,
as you know the price of the Oil is more and more increasing, while
the oil supply is decreasing. Moreover Oil
is causing wars,...
........
|
11-09-2010 05:12 PM
........ | 0 | 1 |
| | | Hello All!
This one has been making me insane. I'm setting the format property of a
textbox to an empty string "" and when I do, it fires the after...
Matthew Wells
|
11-09-2010 04:07 PM
David-W-Fenton | 7 | 8 |
| | | I am a novice Access user using Access 2003. I have built a database
and I am currently having a issue with one of my forms. When I select
a...
BamaBlast
|
11-09-2010 07:31 AM
BamaBlast | 0 | 1 |
| | | Each of my Report_Open events includes a 'CloseSub:' label, and I want to
insert a new line of code immediately before that line (in each of...
Bob Darlington
|
11-09-2010 02:16 AM
Bob Darlington | 7 | 8 |
| | | I have a application where multiple front ends on separate PCs connect
to multiple back ends on a server. Each front end links to a single
back end...
Owen
|
11-08-2010 11:22 PM
Owen | 18 | 19 |
| | | Dear reader,
After the following code I receive the message below:
appAccess.OpenCurrentDatabase Path & Application
Message:
This action cannot be... |
11-07-2010 07:59 PM
David-W-Fenton | 1 | 2 |
| | | Dear reader,
How to set the focus to a new to open Access application in case the new
Access space with application (program file mde) will be open... |
11-07-2010 07:57 PM
David-W-Fenton | 1 | 2 |
| | | Hi,
I am facing difficulties with an (old) app of mine.
It's an Access 2.0 application which has been running for years now.
I got complaints from a...
Arno R
|
11-07-2010 03:14 PM
Arno R | 15 | 16 |
| | | I used the Office 2007 'Save as PDF' Add-in downloaded from Microsoft
to enable output from Access 2007 reports into the PDF file format.
Will Office...
James A. Fortune
|
11-05-2010 05:32 PM
Andreas Vogt | 2 | 3 |
| | | Access 2003.
On a form, I press a button that updates a table using ADODB .Seek
and .Update.
Then I press a second button that does...
Composer
|
11-05-2010 04:44 PM
David-W-Fenton | 13 | 14 |
| | | On Nov 3, 2:52*pm, "David-W-Fenton" <NoEm... (AT) SeeSignature (DOT) invalid>
wrote:
Antivirus measures and security updates are inherently insecure...
paii, Ron
|
11-05-2010 04:04 PM
James A. Fortune | 10 | 11 |
| | | Anyone know of a good newsgroup server that carries this newsgroup?
Charter just dropped it. I accessed it via google groups.
Bob Alston
|
11-05-2010 03:28 AM
Andreas Vogt | 12 | 13 |
| | | I have a customer for my Access database who was recently given a new
laptop with the 64 bit version of Windows 7.
Once she got this new computer,...
Icarus
|
11-04-2010 11:51 AM
Icarus | 0 | 1 |
| | | Being a lazy sort of guy, I don't want to spend too much time re-inventing
the wheel.
I am in the middle of writing code that will examine any SQL...
Phil
|
11-04-2010 07:36 AM
paii, Ron | 1 | 2 |
