|
|
|
call an ms function with parameter from excel
Thu, 11 Dec 2008 07:55:01 -0800
Is there a way to call a function from ms access from excel which passes a
parameter? ...
|
reference and count subreport objects
Thu, 11 Dec 2008 14:50:05 GMT
I have a process that allows the user to duplicate 'stock' reports as user-
defined reports. But, I need to be able (in VBA) to check the selected
report to see if there are any subreport objects, duplicate and rename those,
then duplicate and rename the main report and change the subreport
sourceobjects to the ...
|
Displaying a chart in a form
Thu, 11 Dec 2008 02:29:00 -0800
I have the following code which creates a Chart from the data in a query,
when a form is opened. How can I then display this chart in the form, so I
can close Excel.
Private Sub Form_Open(Cancel As Integer)
On Error GoTo Form_Err
' Dimension arrays for recordset & excel etc
Dim inStat As ADODB.Rec ...
|
non relational database
Thu, 11 Dec 2008 01:34:57 -0800 (PST)
Hi,
I face the daunting task of converting a fully non relational database
in something hopefully a bit more helpful. The old database made full
use of memo fields, with data elements (for instance, dates, or
ducument number) separated with "carriage return". I already cretated
the new database structure, rel ...
|
export to Excel creates "Outline"
Wed, 10 Dec 2008 19:25:00 -0800
I am working in Access 2003. I have provided a button that allows the user
to create a "data dump" based on a 2 table SQL statement, into an Excel file.
I WANT a flat file but I am getting an "outline" file; One level of the
outline is from 1 table and the other is from the second table (This used to
prod ...
|
Duplicate record checking
Wed, 10 Dec 2008 19:01:01 -0800
I have a form that i set up for duplicate record checking, but the code i
have is not working. I found something similiar to what i wanted to do and
modified it.
The form has bound field [SBOL #] and the table providing the information is
field [SBOL] it is a text field that has numbers and sometimes letters ...
|
Re: Help with found code
Wed, 10 Dec 2008 20:29:12 -0500
Please post the exact code you've got now, as well as indicating exact where
the error occurs (and the exact error message)
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Stephen sjw_ost" <Stephensjwost@discussions.microsoft.com> wrote in message
news:A72AB8 ...
|
|
|
Delete Empty Columns
Wed, 10 Dec 2008 15:15:01 -0800
I have a query that (finally) gives me the results I want, however, I am
having trouble using the results. The query gives me eleven fields, Up5, Up4,
Up3, Up2, Up1, Target, Down1, Down2, Down3, Down4, Down5. The up and down are
sub queries where the Target (inner join) is the criteria for both. The basic
id ...
|
Create folder and name field value
Wed, 10 Dec 2008 13:30:02 -0800
Hello,
I'm trying to create a folder on my desktop by selecting values in a field
(Customer Model Code) from a table and using that field as the folder name.
I thought it might be easier to create the folder, and then rename it.
Please see my code below. I'm getting an error on the Name line- "file not
f ...
|
Access 2003 Project - Can't make ADE file.
Wed, 10 Dec 2008 12:11:03 -0800
I can't create an ADE file all of a sudden from my Access 2003 ADP file. Has
anyone encountered this issue? If you have, would you please help?
Thanks. CH ...
|
|
|
