A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

form data over the internet?



 
 
Thread Tools Display Modes
  #1  
Old July 12th, 2004, 12:15 AM
111
external usenet poster
 
Posts: n/a
Default form data over the internet?

I have set up an ftp server and would like to know how i can automatically send
certain data from my .mdb file (on an hourly basis) so I can log into the
server from any internet connection to view the data

I suspect the best format to xfer the data from the Form would be a .txt file
so that any computer i'm using to log into the ftp site will be able to read
the data.If there is a better way please let me know.(perhaps html?)

I really don't know where to begin. I have a form which shows daily statistics
that i want to be updated on the server (hourly) so that i can log in from any
internet connection (worldwide) to view the stats. I'm not fussy about the
format of the data i only need to see the numbers.

any suggestions would be greatly appreciated.
tks


  #2  
Old July 12th, 2004, 04:50 AM
Dirk Goldgar
external usenet poster
 
Posts: n/a
Default form data over the internet?

"111" wrote in message
able.rogers.com
I have set up an ftp server and would like to know how i can
automatically send certain data from my .mdb file (on an hourly
basis) so I can log into the server from any internet connection to
view the data

I suspect the best format to xfer the data from the Form would be a
.txt file so that any computer i'm using to log into the ftp site
will be able to read the data.If there is a better way please let me
know.(perhaps html?)

I really don't know where to begin. I have a form which shows daily
statistics that i want to be updated on the server (hourly) so that i
can log in from any internet connection (worldwide) to view the
stats. I'm not fussy about the format of the data i only need to see
the numbers.

any suggestions would be greatly appreciated.
tks


It seems reasonable to write the required data out to a text file. If
it comes from a table or query, the DoCmd.TransferText method may be
useful to write it out. If not, you may need to use the built-in VBA
file I/O statements like Open, Print # (or Write), and Close.

For FTPing, you may want to try the Internet Transfer Library posted at

http://www.mvps.org/access/modules/mdl0037.htm

I've used it for HTTP (reading web pages), not for FTP, so I can't tell
you much about that aspect of it, but there are examples in the
download.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


  #3  
Old July 12th, 2004, 05:00 AM
Mingqing Cheng [MSFT]
external usenet poster
 
Posts: n/a
Default form data over the internet?

Hi,

From your descriptions, I understood that you would like to access your mdb
data via Internet connections. Have I understood you? If there is anything
I misunderstood, please feel free to let me know

However, I am not very sure about your process. Do you want to know how to
convert Access data to txt format? What do you want to do with FTP Server?

Based on my experience, you should take the following things into
consideration
1. Security
Do you have much concerns on the security of your data? If so, please make
sure that you have make it safe enough.

2. How about email sending?
We could use Access to send email to **** email address at a scheduled time.

3. If you are using HTML, I think it is the most effective way to do it.
Also, please take the security of data

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!


Sincerely yours,

Mingqing Cheng
Microsoft Developer Community Support
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

  #4  
Old July 15th, 2004, 04:06 AM
Mingqing Cheng [MSFT]
external usenet poster
 
Posts: n/a
Default form data over the internet?

Hi,

I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!


Sincerely yours,

Mingqing Cheng
Microsoft Developer Community Support
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Data not saving in the continous form wesbird Using Forms 0 July 6th, 2004 07:51 PM
How to syncronize a datasheet form and single form? Sandra Using Forms 9 June 16th, 2004 05:24 AM
Mail Merge Form and Data (Word XP) Sharon Mailmerge 1 May 7th, 2004 10:21 AM
Linking Excel data through Access to use a Form as an Interface Laura Links and Linking 0 March 23rd, 2004 04:59 PM


All times are GMT +1. The time now is 10:54 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.