|
Storing and reading variable parameters in Access
Hi,
Can anyone point me in the right direction?
I'm developing a small Access ap which includes some exporting of data in
excel & text format.
I want to make the export file paths and names dynamic rather than hard
coded (in a table or external file?) so the users of the ap can configure
this (without me :-)).
Thanks in advance,
Damien
...
|
7 |
6/24/2007 9:16:58 AM |
|
|
news groups
This is a multi-part message in MIME format.
------=_NextPart_000_0014_01C7B4CE.22D49BD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
------=_NextPart_000_0014_01C7B4CE.22D49BD0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"&g...
|
2 |
6/22/2007 8:16:19 PM |
|
|
Test for records before TransferSpreadsheet
Hi,
I'm using TransferSpreadsheet to output the results of a query to an Excel
file.
Can someone please help with a logical test I can use to make sure the query
will return more than 0 records before I run the TransferSpreadsheet code?
TIA
Damien
...
|
3 |
6/22/2007 2:35:34 AM |
|
|
Use TransferSpreadsheet and open Excel directly
Hi
How can I export a result from a query directly into a new book in Excel
(Book1), and then run a short macro in Excel (to do some basic formating on
the query output).
Currently I use TransferSpreadsheet to save the query to a named file, and
then the user need to go to the location an open the file.
Code like this, today:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel...
|
3 |
6/22/2007 12:18:50 AM |
|
|
FillCDays()
Hey Guys (and Gals),
What I would like is if an Associate has more than one activity on any
single day it should show them all. (This end result shows in a calendar
style report.) Right ow it only shows the first activity. I have marked
what I think is the offending line (<--THIS LINE), any ideas without me
rewriting the whole thing?
Function FillCdays()
On Error Resume Next...
|
15 |
6/21/2007 5:56:45 PM |
|
|
Problem with versions of word and outlook
Hi
My access app uses word and outlook references which I can not get rid of
due to certain features that my app has. I have this problem that I need to
send me app to various clients who have varying versions of outlook and word
and thus my app fails to run. Is there anyway my app can find the versions
of outlook/word at start-up and readjust links to appropriate versions of
outlook/...
|
13 |
6/20/2007 6:25:49 AM |
|
|
Converting DB from A2000 to A2003
I have an application which is currently in A2000. It consists of a
front-end MDE and a back-end MDB. During initialization, I re-link all
back-end tables.
When I come out with a new version, I simply ship a replacement MDE
front-end. I basically don't touch the MDB back-end.
This application is deployed to roughly one thousand clients (most are
single-user / stand-alone, a few sh...
|
15 |
6/19/2007 1:36:27 AM |
|
|
connect to a SQL Server table through code?
Hi!
I have an Access db that I need to connect to a SQL Server table. I'd like
it run from several clients and I don't want do create a ODBC-connection on
every client. Is it possible to connect through code and does anyknow how to
do that?
Thx!
/e
...
|
5 |
6/18/2007 6:19:55 PM |
|
|
need help exporting a report and setting the location of the file...
This code acts like it's running. It scrolls through the pages anyway.
DoCmd.OutputTo acOutputReport, "rpt_OutreachContact-Report", "Rich Text
Format (*.rtf)", "Outreach Contact - Report.rtf"
When I rerun it, it doesn't ask if I want to over write the old file.
And I don't know where it's putting the file...
I thought I could put the file on the desktop by adding this "C:\Documents
and...
|
3 |
6/18/2007 4:34:20 PM |
|
|
Select Statement
I'm having difficulty executing the following sql statement. Can someone
tell me if my syntax is correct? Do I have missing double or single quotes?
The date function I'm using takes what the user enters on the form as lets
say 06/26/2006 and converts it to a Julian date like 107177 that is held in
one of our peoplesoft tables. I've used this line of code many times in the
criteria li...
|
4 |
6/14/2007 4:41:52 PM |
|
|
Need thoughts on Access vs. Other environment
Hi.
As I worked for a agency a couple of years ago I developed a
budgeting/forecast application tailored for a spesific market. I used MS
Access, which was the most "efficient" way to do it at the time (some 7
years ago).
They still buy the application from me as I run my own business now.
Now I consider to migrate the application into a more "robust" environment.
It's starting to g...
|
7 |
6/13/2007 7:18:13 PM |
|
|
Mail Merge
Hello All,
I am not sure this is the correct form, if not maybe someone can tell me
where I should post.
Here is my goal.
I have an Access database that opens up several or just one Word Document(s)
depending on which document(s) they select. I have my queries in Access as
the Data Source. Depending on which icon the user click the report either
opens in Word or prints directly to t...
|
3 |
6/12/2007 10:32:45 AM |
|
|
********TESTING**************
--
With my best regards!
Tommy Wong ...
|
2 |
6/10/2007 5:16:31 AM |
|
|
VB versus VBA
In VB were are using the PaintPicture Method in order to draw the contents of
a graphics file (.bmp, .ico etc) on a form or printer.
I would like to program that in VBA for MS Access . It seems that VBA
doesn't work with this method.
Does anybody know the equivalent of the PaintPicture Method (VB) for VBA?
--
Thanks for input
--
Friedi...
|
3 |
6/9/2007 5:49:23 AM |
|
|
Objects from Classes in Library Database
What's the best way of creating an object from a class (module) in a library
database?
I know I could declare a public variable in a standard module in the library
"As ClassInLibrary" and that would be seen by the database. But is this the
best way?
By moving some code from the database to a library database, I've also had
to move public Enums from the classes in the library to stand...
|
3 |
6/9/2007 2:32:04 AM |
|
|
unexpected datediff months
Everyone,
I just got bit by the datediff function. Just putting this out here as
a caution to everybody. This it the kind of problem that can drive you
nuts.
Consider these lines:
MsgBox DateDiff("m", "1/1/2007", "2/28/2007")
MsgBox DateDiff("m", "1/31/2007", "2/1/2007")
They both return 1. It makes sense to me now. Datediff tells you how
many "1st of the month" are between the ...
|
3 |
6/7/2007 7:03:16 PM |
|
|
µç×ÓÉÌÎñ·¢Õ¹Ç°¾°
Çë´ó¼Ò·¢±íһϵç×ÓÉÌÎñµÄ·¢Õ¹ÏÖ×´ºÍǰ;
...
|
2 |
6/7/2007 12:30:18 PM |
|
|
Access 2003 : I would like some numbered alarms to skip. 1, 2, 3, 0, 4, 5, 0, 6
This is a multi-part message in MIME format.
------=_NextPart_000_0024_01C7A1CC.9705F9A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi everybody,
Actual numbering of the alarms : for 1 to wathever. But, after 365 days =
of the last number 1, the count returns to 1
New numbering of the alarms, if the field AlarmeFondee is check, skip =
t...
|
13 |
6/7/2007 12:27:58 PM |
|
|
FollowHyperlink to .ASP website
How do I use the FollowHyperlink method to go to a .asp website and
automatically enter in the parameters to run a search and go to the
search results page?
E.g., if the site is a driving directions website or a search engine,
how do I automatically search for the key terms the user selected in
my database?
There is a 'extrainfo' parameter in the FollowHyperlink command as
well as a mso...
|
1 |
6/6/2007 2:42:01 PM |
|
|
Package installation
Somebody else knows any program or a company who sell a program where I can
make the wizard install package for my database created in Ms Access 2003?
I have ADE (access developer extensions) but is not really good.
Is it possible to make with the program MSI?
Thanks
JCP
...
|
8 |
6/5/2007 4:12:58 PM |
|
|
integrate the Redemption library in code so outlook security messege will not jump
how can i integrate the Redemption library in this code
so outlook security messege will not jump?
Dim olApp As OutLook.Application
Dim Olmapi As OutLook.NameSpace
Dim OlTmp As OutLook.MAPIFolder
Dim Olfolder As OutLook.MAPIFolder
Dim OlMail As Object
Dim OlItems As OutLook.Items
Dim strname
Set olApp = CreateObject("Outlook.Application")
Set Olmapi...
|
4 |
6/5/2007 4:04:22 PM |
|
|
Special Folders
How can I get special folders path in wondows XP?
I need to obtain My Documents folder path.
Thanks
JCP
...
|
6 |
6/1/2007 7:19:06 PM |
|
|
Setup Display properties in Windows XP
In windows XP, how can I setup display properties, tab appearance and
windows and buttons change from windows classic style to Windows Xp style
over vba?
Thanks
JCP
...
|
12 |
6/1/2007 6:26:17 PM |
|
|
Can anyone help with this?
I have a function that puts a long text string in a field. Part of the text
is a generic description for the price of a product, ie "price". I have the
prices I want to use in it's place in another column in the table. I tried
using DLookup to put in the prices, but it only returns the first value. I
need it to loop through all the prices and replace the generic text with the
price from ...
|
4 |
6/1/2007 4:05:16 PM |
|
|
Thanks
Thanks for the help.
K.
...
|
1 |
5/31/2007 3:38:18 PM |