Pivot Chart view of Query using VBA
Thu, 9 Oct 2008 12:56:01 -0700
Scenario is, I am creating Pivot Chart view of three Queries to display
Business generating by Sales Person on Month, Quarter and Yearly basis.
Three Command Buttons are associated with three different queries Month,
Quarter, and Year (same query saved with three different names). In Pivot
Chart view Catego ...
|
Null not adding in expression
Thu, 9 Oct 2008 12:52:25 -0700
I have a query (SQL below) which works fine, with one exception:
When adding 2 values [Salaries-Actual] and [Other-Actual], if either value
is null, the resulting addition returns null. What am I doing wrong?????
SELECT BudgetTitles.BudgetUnitTitle, Sum(ActualSalaries.TotalCost) AS
[Salaries-Actual], Sum(Act ...
|
Unlink imported file.
Thu, 9 Oct 2008 11:33:00 -0700
Want to unlink Access 2003 file imported from dBase, to make minor changes. ...
|
Control Source for text box on report to display the field name
Thu, 9 Oct 2008 11:25:01 -0700
I have a database that tracks employees and the dates that they have
completed some training. Example:
SSN Last First MI Class1 Class2 Class3 Class 4 etc...
I have created a form that allows me to print a report of all employees that
have completed a class. Using a dropdown box it builds queries ...
|
Step into VBA code Problem
Thu, 9 Oct 2008 10:29:34 -0700
I have inherited an Access Database in which I can't step into any of the
code in the VBA editor? Is there a setting that does not allow me to step
into any of the code? I put in breaks, but the events just blow right
through them. Thanks.
Kou ...
|
INSERT INTO from both a table and memory variable
Thu, 9 Oct 2008 09:22:02 -0700
I want to insert a new record into Table A which consists of 4 values. Three
of those values are to be retrieved from Table B. The fourth is the value
entered by the user into a memory variable. Is this possible? If so, what
is the correct syntax? If it's not possible, what's an alternative
workaround? ...
|
Circle on report
Thu, 9 Oct 2008 07:07:01 -0700
Hi,
I have managed to draw some circles on a report but I was wondering if it is
possible to make them different colours?
--
Thank you
...
|
|
|
VB problem in Access 2007
Thu, 9 Oct 2008 06:23:01 -0700
Hello everyone
Lately I'm having a little problem with the VB in my forms...
When I start the mdb file, made in Access 2003 or 2000 can't recall, it
doesn't load the VB code behind the forms.
I've got to punch F11 and then quit, for it to load the VB, otherwise I get
an error message:
"The expression On ...
|
Hyperlink in e-mail directing to a specific record
Thu, 9 Oct 2008 01:26:01 -0700
Hi,
I'm using Access 2003
I've got a form with a button inside a record that will trigger the code as
mentioned below. This code will insert a hyperlink to whatever path i put in
there but what I'm trying to accomplish is that the hyperlink will point to a
specific record
As far as the code for sendin ...
|
Open .NET Application from MS Access 2000
Thu, 9 Oct 2008 01:25:01 -0700
Hi
I'm looking to have a button on a form within MS Access 2000 which upon
clicking, would open a Windows .NET Application (probably Framework version
3.5). I have managed to call a .NET class library from within Access but not
open an application. Is this possible?
Thanks.
Matthew ...
|
