Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 2010 Web Form - How to output data on button click.

Status
Not open for further replies.
sqleptical

sqleptical

Programmer
Sep 26, 2001
112
US
I've got an Access 2010 Web Form (published to Sharepoint 2010) that the user will fill out at the time of an interview. When they click the Access Form Control Button, I need it to output the form data to something that the user can copy/paste the output text into another application. The output will be in narrative form and will be more than 255 characters.

When this was a client form, I just exported it to an HTML file and it worked great, but now I need it to run on SharePoint 2010.

I can't figure out a way to do this in the Web Form. I'm lost without VBA. Because of the narrative nature of the output, I don't see how a Web Report will do the trick and Web Access does not allow me to have a calculation Field that is Memo. Because blank fields and the accompanying narrative text need to be left out of the output I have not been able to figure out how to use a data macro to do this.

If anyone has an idea or can point me in the right direction, I'd certainly appreciate it.
 
Sort by date Sort by votes
...And an Access Web Form Message Box does not let you copy/paste from it.
 
Upvote 0 Downvote
Can you save it as a text file in some Temp place and display it in Notepad?

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.
 
Upvote 0 Downvote
Yes, If I just new how to do that without VBA. I feel there's a lack of info regarding this on the Web. If you have any ideas, I'd be more than happy to try. Before I could do it like this and it would right it to their desktop:

Dim c As String
Dim fs As FileSystemObject
Dim ts As TextStream
Dim getuser As String
Dim ccount As Integer
ccount = 0
getuser = Environ("username")

Set fs = New FileSystemObject

'To write
Set ts = fs.OpenTextFile("c:\users\" & getuser & "\desktop\Narrative.html", ForWriting, True)
c = "<html>"
c = c + "<b>Application Date: </b>" & Datetxt
c = c + "<br><b> Interview Date:</b> " & IDatetxt
'c = c + "<br><b> Time:</b> " & TimeTxt etc..etc...

c = c + "</html>"

ts.WriteLine c
 
Upvote 0 Downvote
Did you ask here ?
forum820

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
I'll try asking there. Thank you for the suggestion.
 
Upvote 0 Downvote
Not need programming.

Create same form but using control "WEB REPORT", this control enables following functions: Export to excel, Export to Word, Export to PDF, the only limitation is that you have to create this extra control (form). It works fine, you will see the ribbon to export after you publish it in sharepoint. I just have same problem few days ago when I was dealing with Web access 2010 and Sharepoint 2010, it seems to be that it is not well documented anywhere.

dmazzini
GSM/UMTS System and Telecomm Consultant

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PrimoSteve
  • Locked
  • Question
Cannot add Image to Command Button?
Replies
9
Views
445
PrimoSteve
PrimoSteve
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
368
dhookom
dhookom
Kennelbloke
  • Solved
Subform not updating in parent form
Replies
10
Views
369
Kennelbloke
Kennelbloke
renigar
  • Locked
  • Question
Trying to add hyperlinks to pdfs through form entry
Replies
0
Views
259
renigar
renigar
Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
193
Xavierparkash
Xavierparkash

Part and Inventory Search

Sponsor

Back
Top