|
txt-files, that I need to import into Access
Hello all,
I have more than 4500 txt-files, that I need to import into Access
2000.
I NEED UR HELP TO REDUCE MY BURDEN.
My idea was to use a macro for this task, but I am not very familiar
with
macros. Maybe there is already a code that is suitable for this
task.
The macro should do following: After the macro is started, the user
should
be able to select the txt-files that need...
|
1 |
28.02.2006 06:39:38 |
|
|
EARN $3,000.00 A DAY. OPEN AN INCOME-DAILY ACCOUNT WITH US
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft DHTML Editing Control">
<TITLE></TITLE>
</HEAD>
<BODY>
<P>YOU COULD BE EARNING OVER $3K A DAY , $100K A
MONTH.INCOME. CHECK IT OUT. Investment is only $5. 99cents a month.</P>
<P><A href="http://www.vosar.net">www.vosar.net</A></P>
<P>Tel: 775-333-11...
|
1 |
01.03.2006 07:13:20 |
|
|
How to extract information from outlook e-mail to access database
I need to take information from an e-mail that was sent via a website using
cgi-email. The information fields are well defined, with the data encased in
square brackets. I know that I can set up a rul in Outlook to run a script
when the e-mai is received but how would I write it so that it connects to
the Access database and access then imports the information into the correct
forms and...
|
1 |
28.02.2006 20:49:26 |
|
|
SendObject - MessageText
Hi All,
I'm using the SendObject > MessageText variable to enter the body of the
email but want to write multiple lines (i.e. insert a carriage return)
Any ideas on how to achieve this would be very helpfull
If it's not directly possible to use cariage returns in the MessageText
variable, then perhaps could it be done with a text string? (however I
still don't know how to get a ...
|
2 |
28.02.2006 13:57:36 |
|
|
Debugging an Access 2000 application in Access 2003 not working?
Hi,
I have a mdb file with a lot of forms developed in Access 2000. We have
upgraded to Access 2003 and I need to debug the code in order to find errors.
But I cannot get the debugging to work. I start the mdb file and the main
form comes up. I then go into the visual basic editor and place a breakpoint
i the code of a button click and then press the button. At this time I
expected th...
|
1 |
28.02.2006 13:57:35 |
|
|
txt-files, that I need to import into Access
Hello all,
I have more than 4500 txt-files, that I need to import into Access
2000.
I NEED UR HELP TO REDUCE MY BURDEN.
My idea was to use a macro for this task, but I am not very familiar
with
macros. Maybe there is already a code that is suitable for this
task.
The macro should do following: After the macro is started, the user
should
be able to select the txt-files that need...
|
1 |
28.02.2006 06:06:09 |
|
|
can't start OLE server
I have done this for years but now....
When I create a macrp to Output a report in rtf or snp formats AND open the
saved file I get an error message telling me "Microsoft Office Access can't
start the OLE server."
If I don't open the file, it seems to work.
Any thoughts from the community on what to do to overcome this problem?
Thanks
--
KMS Technical Solutions...
|
1 |
27.02.2006 21:36:27 |
|
|
Macro Request
Hi there
I'm wanting to be able to calculate the amount of working days between two
specific dates. For example, if we entered 1st January 2006 and today (17th
February 2006) it should give me a number of 41 (including today). Would
anybody be able to provide me with a macro for this?
Many thanks in advance
Gareth Saunders
BOFH...
|
2 |
27.02.2006 17:24:18 |
|
|
Access Macro
No matter what I do I cannot get a macro to run more than 20 times. What am
I doing wrong?...
|
5 |
27.02.2006 13:39:07 |
|
|
Transfer text delimited with date in file name using a macro
I am stuck (who isn't when they post?) I have created a 4 step macro and the
3rd step, using transfer text, export delimited, with a named specification,
to export a text file using "C:\batchfile" &_Format(Now(),"yyyymmddhhmm") &
".txt", I get that '"C:\' is not a valid path.
If I remove quotes,C:\batchfile &_Format(Now(),"yyyymmddhhmm") & .txt then
(Obviously) I get a file named lite...
|
4 |
27.02.2006 03:04:47 |
|
|
Run on startup marco
What built in macro is used to run a macro on startup?
--
Pierce
Posted from - http://www.officehelp.in
...
|
2 |
26.02.2006 23:31:50 |
|
|
Real Estate - Free post Your ads about property for sale.
Real Estate - Free post Your ads about property for sale.
You can join for free and post your ads about property for sale or for rent.
www.World-Estate.com
...
|
1 |
26.02.2006 17:00:44 |
|
|
carrying out the SetWarnings action in the macro
I run a macro with a chain of queries for to update many tables. At every
turn of update appears a message of concerning warning the deletion existing
tables. I have deselected the option “Confirm Document deletions†but the
message appears afterwards. How I escape from message? Thank of support.
...
|
5 |
26.02.2006 00:18:26 |
|
|
Bypass Key Combination (Macro)
I use Garry Robinson's "Startup Properties" form to disable/enable my bypass
key.
For security purposes, as desired, holding down the SHFT key while
double-clicking on the MDB file does not allow me get "behind" the
application and gain access to the Database Window and any menus.
Currently, as the administrator, I use "^K" in order to open up my Startup
Properties form where I can e...
|
7 |
25.02.2006 21:11:36 |
|
|
deleting relationships with a macro?
I have a macro that will "clean up" my db after appending a bunch of records
from some imported tables.
after getting all the records appended, i want to delete the imported tables.
i've written the macro with "deleteObject" for each of the tables, but when
i run it, i get the error that it can't do it because the tables are linked
by relationships. none of the imported tables are lin...
|
6 |
24.02.2006 20:29:33 |
|
|
Send Email on Lotus Notes Without Hitting Send Button SendObject A
Hello everyone, I've seen every post possible on this subject, I may have
missed something, but nothing is working.
I have a sendto macro in access to send a query, it works, opens up Lotus
Notes 6.5 but it doesnt send the email, it leaves it open for editing, I have
editing as No in the Macro, is there some VBA that is needed to auto send
the email? Need help, thanks....
|
1 |
24.02.2006 19:30:09 |
|
|
Limiting the number of lines in a textbox
I have a form with a long textbox on it used for inputting notes for an
order. It is roughly 4 lines of text high. It is bound to a control that
is also used in a report. If the user inputs more that the 4 lines of text
that are visible on the form it allows him to keep typing as long as he has
not reached the field size limit of characters, however the report is not
able to show any ...
|
4 |
24.02.2006 19:12:53 |
|
|
Need to save 303 page report by group as 144 separate files
I have a 303 page report that is the detail for 144 different groups. I need
to export this report into separate pdf files one for each of the 144 groups.
Would it be possible to create a macro within the report placed in the group
header and footer that will break the report into separate output files as
the group changes?
Or will I need to create a macro that prints the reports...
|
4 |
24.02.2006 18:42:48 |
|
|
Need advice on macro
I recorded and edited this macro to remove unwanted characters from a
word 2003 document. It does what I wanted and allows me to add or
change the characters as needed, but it seems the code is very
redundent and probably could be shortened to accomplish the same
results. Any help on this would be very much appreciated. Thanks in
advance. Joe
___________________________________________...
|
2 |
23.02.2006 04:27:42 |
|
|
security in their design or implementation. Intruders can exploit
security in their design or implementation. Intruders can exploit
...
|
1 |
23.02.2006 00:27:04 |
|
|
Macro pause
Is there a way for a macro to open a table then pause while the table is
edited and macro resumes after table is closed?
Dave
...
|
2 |
22.02.2006 17:25:07 |
|
|
macro to run every hour
Hi
Is it possible to put a timer in a macro to run action queries? for example
the macro to run every hour?
Regards
Alec
...
|
4 |
21.02.2006 21:55:50 |
|
|
Use Macro to run queries in multiple option groups
I have 4 separate option groups. The first is a list of reports the user can
run. The second allows the user to choose a detailed or summary version of
their report. The third lists options as to how to sort the data and the
fourth gives advanced sorting options. They are all radio buttons. The
user can only select one choice per group. I can create a query for each
possible combinatio...
|
2 |
21.02.2006 18:23:44 |
|
|
List of Macro Functions
Is there anywhere that I can obtain a list that explains what all of the
different Macro actions will do in Access??? I'm not looking for anything to
do with coding, just with the Actions that Access provides.
Thanks!...
|
2 |
21.02.2006 17:58:34 |
|
|
how to save snapshot reports with different names via macro
I have completed a macro that saves multiple reports in snapshot format. The
macro repeats for each consecutive report to be saved. But, I have not been
able to figure out the syntax (if any) to allow the snapshot report to have a
saved file name different than the initial name indicated in the Output File
of the macro.
Is it possible to use the OutputTo, Output File to do this auto...
|
6 |
21.02.2006 17:54:05 |