| | Rating Thread /
Thread Starter | Last Post | Replies | Views |
|  | My Problem:
I have created a database here at work that is exhibiting some very
strange behaviour.
Essentially the database is structured in a...
Steve Strik
|
05-28-2004 02:06 AM
Allen Browne | 5 | 41 |
|  | Is there a way to export an MS Access Report to Word/Excel that looks
EXACTLY like it appears in Access? When I export to Excel, only
certain data...
PerryC
|
05-28-2004 01:37 AM
Albert D. Kallal | 2 | 45 |
|  | I am preparing to write a small utility which will identify redundant
objects in an ADP and its SQL db.
Suppose my code finds two objects, A and B,...
Lyle Fairfield
|
05-28-2004 01:26 AM
XMVP | 10 | 90 |
|  | Hi folks.
I have a form, frmHistory, whose Default View is set to Continuos
Forms.
The following is the coding that I inserted in frmHistory's On...
Aravind
|
05-28-2004 12:44 AM
Glenn Davy | 2 | 45 |
|  | I am currently using the Active X Calendar object in a form to select
the dates. The problem I am having is when the month changes the
calendar...
rudy
|
05-28-2004 12:24 AM
rudy | 4 | 41 |
|  | Hi
I have a access data base with a event title field and wish to only
return say 20 characters, BUT I need it to return to the last space so
If the...
Keenan
|
05-28-2004 12:16 AM
Larry Linson | 1 | 55 |
|  | Jerry Linson <admin (AT) jerseygirls (DOT) com> wrote:
Please ignore the above posting and others which are somewhat bizarre.
Note to persons new...
Tony Toews
|
05-28-2004 12:13 AM
Larry Linson | 3 | 40 |
|  | Has anyone ever come up with a way to disable macro creation within MS
Access? Not just on a project level, but to prevent macros from being
created...
Billy R. Moon
|
05-28-2004 12:11 AM
Billy R. Moon | 2 | 48 |
|  | Is there a way to programatically delete a subroutine in the class module of a
form from another form?
Thanks!
Mark
Mark
|
05-28-2004 12:04 AM
Tom van Stiphout | 1 | 39 |
|  | Dear Oracle Developers,
my task is to make up a Oracle View from a Pivot table in MS Access.
Given are two tables to join:
T_FIRM:
FIRM_ABBR ...
Michael John
|
05-27-2004 09:27 PM
Ron Tornambe | 4 | 37 |
|  | I am thinking about gettingMicrosoft Office XP Developer (549-00904) for
a project I am currently working on. This is an upgrade version. What
are...
Salad
|
05-27-2004 09:12 PM
Salad | 2 | 34 |
|  | I am using the Linked Table Manager in Access to try and connect my front
end database (on my desktop) to my backend database (on my web host) I...
HB2
|
05-27-2004 08:36 PM
Tony Toews | 10 | 60 |
|  | This is about a mysterious slow down only.
An application (split data & FE) that has run for 6 years without
error with six to ten users. The...
Bill Elgie
|
05-27-2004 08:35 PM
Tony Toews | 6 | 42 |
|  | Hi,
I have an Access project that I use to allow a client to hit an SQL
server at my host. This project has several forms that are used to
udpate...
Tim Smallwood
|
05-27-2004 08:28 PM
Tony Toews | 11 | 72 |
|  | We have an Access 2002 database of about 35 M with about 7 users. The data
lives on the server (Windows 2000 server), while the queries, forms,...
heather e blair
|
05-27-2004 08:22 PM
Tony Toews | 8 | 47 |
|  | Chuck Grimsby <c.grimsby (AT) worldnet (DOT) att.net.invalid> wrote:
Interesting idea. Identical to If and IFElse though.
Tony
--
Tony Toews,...
Sean O
|
05-27-2004 08:16 PM
Tony Toews | 6 | 35 |
|  | I've played with this for several hours trying to make it work with no
success. How do I replace "TOP 4" in the following SQL statement with
the...
Wayne Aprato
|
05-27-2004 06:22 PM
Wayne Aprato | 2 | 35 |
|  | Hi,
How can I check whether a program, started with the 'shell' function,
has terminated? Can this be done with value, returned from the...
Blue in Green
|
05-27-2004 06:20 PM
Douglas J. Steele | 1 | 33 |
|  | Hi all,
I wrote some code that would enable a combo box to find a specific record,
and if unsuccessful, to create a new one. Since the uderlying...
AW
|
05-27-2004 06:19 PM
Douglas J. Steele | 1 | 43 |
|  | In response to recent questions on when to use class modules in Access VBA,
here's a real-world scenario of mine.
I had some code that needed to...
Steve Jorgensen
|
05-27-2004 05:17 PM
WindAndWaves | 4 | 37 |
|  | I recieve the following error
OffWH
Automation Error
Library not Registered
How do i find what the library is??
Regards
DD
DD
|
05-27-2004 04:10 PM
Tony Toews | 3 | 69 |
|  | Hi,
Is that possible if the crosstab query is dynamic? Doesn't seem so as
I have to specify the control source for the text boxes and the number
of...
pw
|
05-27-2004 03:31 PM
pw | 10 | 67 |
|  | I'm building a db to store product monthly profit and loss data. Is it
better to have:
(A) each row represents the product and all of its 30 p&l line...
John
|
05-27-2004 02:29 PM
Mark | 1 | 46 |
|  | Greetings. I am looking for some advice on making a database secure.
By secure, I mean that I want only certain people to have write access
to the...
Susan Bricker
|
05-27-2004 01:28 PM
hamking | 9 | 47 |
|  | Hi All,
I'm starting some projects now that could really benefit from source code
control, but for various reasons, I don't want to have to be...
Steve Jorgensen
|
05-27-2004 01:23 PM
Alan Webb | 3 | 31 |
|  | I have a Microsoft Access 2000 (9.0.4402 SR-1) database that I am
attempting to launch from a hyperlink using Internet Explorer...
Bill Thom
|
05-27-2004 11:53 AM
Bill Thom | 0 | 39 |
|  | I have a database file that I use an autonumber field as the primary key
index. Because of some rearrangements in the past, this index does not...
noone
|
05-27-2004 10:19 AM
Julia Baresch | 9 | 35 |
|  | how do you stop Access from saving any changed data in your tables and
queries?
like i just add or change data on the table/query tables,then click...
Christopher Koh
|
05-27-2004 10:09 AM
Wayne Morgan | 3 | 34 |
|  | I have designed a Dbase,& I cant get all the Reports or some queries
to Print Monthly Summaries in Monthly date order. The date is the
first column &...
John Pettitt
|
05-27-2004 10:06 AM
PC Datasheet | 2 | 53 |
|  | Ugh, I had to change the parameters of an ODBC connection and refreshed my
linked tables which isn't so bad. But I noticed the pass-through...
jj
|
05-27-2004 09:46 AM
Donald Wisch | 1 | 46 |
|  | Replied yesterday but it's not showing up so sorry if this appears as a
re-post
------------------------
Hmm, it's not case sensitive though.
The...
Terry Kreft
|
05-27-2004 07:06 AM
Terry Kreft | 0 | 38 |
|  | Can anyone explain me the joy of let and get. Once more, I read the
explanation in the help, but did not get much wiser.
I seem to learn best from...
WindAndWaves
|
05-27-2004 06:11 AM
WindAndWaves | 8 | 62 |
|  | Hello all,
I was wondering if it is possible to call a form from a form,
depending on controls from its subform.
i.e.
I have a client details form...
Cillies
|
05-27-2004 05:44 AM
Cillies | 0 | 43 |
|  | I'm looking to call the upsizing wizard from within a VBA function,
preferably automating the entire upsizing process. Has anyone achieved
this under...
Calum Chisholm
|
05-27-2004 04:17 AM
Calum Chisholm | 2 | 42 |
|  | Hi,
I have created 2 tables tbl1 and tbl2 and added data as follows
tbl1:
account_desc accountno ...
Omavlana
|
05-27-2004 04:07 AM
Bradley | 1 | 30 |
|  | Hi,
I have created 2 tables tbl1 and tbl2 and added data as follows
tbl1:
account_desc accountno ...
K k
|
05-27-2004 04:06 AM
K k | 0 | 33 |
|  | Is there any possiblity of writing an Access or Visual Basic
application that provides a method of sharing the window focus between
Access and the...
Pete
|
05-27-2004 04:05 AM
Terry Kreft | 3 | 45 |
|  | Make sure that the form is based on the order details table....or a query
that joins both and gives you the info you are looking for...
The 'magic'...
Mal Reeve
|
05-27-2004 03:16 AM
Sabine | 1 | 35 |
|  | Hi,
I need your help to resolve this problem. I have written a right outer
join query between 2 indipendent tables as follows.
select...
K k
|
05-27-2004 12:16 AM
K k | 0 | 31 |
|  | Hi,
I need your help to resolve this problem. I have written a right outer
join query between 2 indipendent tables as follows.
select...
Omavlana
|
05-26-2004 11:59 PM
Omavlana | 0 | 38 |
|  | Is there a way to Start Filter Process (Filter by Form) using code?
Thank you for the help in advance.
MFS 43
|
05-26-2004 11:16 PM
Mike 43 | 2 | 32 |
|  | I have one client fiield that stores First and last name. I would like
to separate the names into a lastname field and firstname field. Can
anyone...
Edmund Wong
|
05-26-2004 10:12 PM
Mark G. King | 3 | 53 |
|  | Hi,
This happened a while back but never since, until now. When in the sql view
of MS Access (2002) and I try to edit the text, quite often...
Not Me
|
05-26-2004 09:36 PM
david epsom dot com dot au | 3 | 42 |
|  | Hello
When tabbing in a textbox that contains text, the text string is usually
highlighted so that if the user starts typing new text in the...
GGerard
|
05-26-2004 09:31 PM
Stewart Allen | 1 | 37 |
|  | From: "WindAndWaves" <access (AT) ngaru (DOT) com>
Subject: Re: why use a class module
Date: Wednesday, 26 May 2004 6:25 p.m.
this is my code that...
WindAndWaves
|
05-26-2004 08:55 PM
David W. Fenton | 1 | 34 |
|  | Access (Jet) caches and pools connections. If Access thinks
that the connection has not changed, it will continue to use the
old connection. I think...
david epsom dot com dot au
|
05-26-2004 07:34 PM
david epsom dot com dot au | 0 | 41 |
|  | Help wanted
Does anyone know of any books out there that addresses the problems of
marketing an Access Database program with front/back end...
Bob
|
05-26-2004 06:56 PM
Tony Toews | 1 | 37 |
|  | I have absolutely no idea. Any idea will be very much appreciated. Thanks.
Paul T. Rong
|
05-26-2004 05:44 PM
Alan Webb | 5 | 34 |
|  | QUESTION:
In an Access 2000 Query, can a computed field use IF logic?
I have two fields that must be logically concatenated. Only one or the
other...
David McCulloch
|
05-26-2004 05:37 PM
David McCulloch | 2 | 39 |
|  | Using Access-2k
The code below is used to generate a csv file that is used by another
application. All works fine till I add an additional field to...
Clint Stowers
|
05-26-2004 05:05 PM
Clint Stowers | 0 | 34 |