I.T. Discussion Community!
-Collapse +Expand
Access
Search Access Group:

Advanced
-Collapse +Expand Access To/From
To/FromCODEGuides
-Collapse +Expand Access Store
PRESTWOODSTORE

Prestwood eMagazine

February Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyMicrosoft Access BoardAccess VBA Programming Topic   Print This     

Access Macros

Access Macros in Access VBA Programming topic (part of our Microsoft Access group).

Quick Search: Access Macros  
aka51
MD
Does anyone know how to link an access Macro through a web browser using ASP.
Peace love and happiness
 Posted 17 years ago (Thread Starter)
Comment Quote
About aka51 -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #9621, 3 replies
Thread Started 5/19/2003 6:19:00 AM
View Counter=3490
Location=MD  
Joined=18 years ago   MB Posts=25  
jdschram
MN
eh..not sure if you can do that...but I will bet you could create a function in ASP to do the same thing the macro does.

***edit***
I did find this...
http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=251
but it times out whenever i try to run it...
 Posted 17 years ago
Comment Quote
About jdschram -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #9622 (Level 1.1)  Reply to 9621
Thread Started 5/19/2003 6:31:00 AM
View Counter=2
Location=MN  
Joined=19 years ago   MB Posts=259  
Most Recent Post
jdschram
MN
yes there is...it's not too complicated either. Basically you would use the FileSystemObject (FSO) to create, open , write-to, and close a file. I've used this to write to a CSV file which can be opened by Excel. To create a CSV file it's pretty easy...a .xls file is a little tougher, and requires excel to be installed on the server. I would suggest the .csv file because it will run a little better.

I'm assuming you know how to make csv files...delimit by commas for the feilds and line breaks for the next record.

Here is some useful info
http://www.aspfaqs.com/aspfaqs/ShowCategory.asp?CatID=4

psuedo code
if file allready exists
delete it, then create it
else
create it
end if
open file with fso
connect to the db and execute SQL
while not rs.eof
write line to csv file
move next
wend
close rs
close db
close file
if you have more questions just post..

HTH
 Posted 17 years ago
Comment Quote
About jdschram -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #9628 (Level 1.2)  Reply to 9621
Reply Posted 5/19/2003 11:19:00 AM
Location=MN  
Joined=19 years ago   MB Posts=259  
aka51
MD
I don't think so ? Is there is a way to export info from the access database into an excel spread sheet using strictly ASP
Peace love and happiness
 Posted 17 years ago (Thread Starter)
Comment Quote
About aka51 -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #9624 (Level 1.3)  Reply to 9621
Reply Posted 5/19/2003 6:56:00 AM
Location=MD  
Joined=18 years ago   MB Posts=25  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1216A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #9621 Counter
3490
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech