Results sent to database, now what..?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created an application for insurance in FP and have the results sent
to a results table in Access. I tried it from our website and the table is
being updated. My question is how do I get those results from the db to a
form or report where I could then scan it in to our system? If I should post
this to Access, just let me know. I haven't done this before, so I'm not sure
where to start. I tried creating a form, but it isn't large enough to hold
the 5-6 pages of data. I'm not sure if I want to select a report because I
want a separate report/form for each person that completes the application.
Does this make sense? How do I get to the final results and have it look like
an application for insurance?

Thanks in advance for any guidance.
 
You either have to download the database or create a ASP application to export the data in CSV or
Excel format.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================
 
Hi Louisa

Once you have brought the DB on to a hard drive use a an append query to
bring the data in a table (or tables) via a temp table. Set the import table
(temp) to index the ID field as unique (you need to do this or each time you
import the on-line DB or you will have duplicates)

Test the data with validation in the append

I would suggest using a stand alone form with a button (import) Something
like this will work - you will need to ask in the access forum for more
details.


Private Sub ButtonName_Click()
Dim IMPfile As TableDef
For Each IMPfile In CurrentDb.TableDefs
If IMPfile.Name = "TheNameOfTheImportTable" Then
CurrentDb.TableDefs.Delete IMPfile.Name
End If
Next
DoCmd.TransferDatabase acImport, "Microsoft Access", "PathToOnLineDatabase",
acTable, "Results", "TableToStoreTheNewData- temp"
DoCmd.SetWarnings False
DoCmd.OpenQuery "TheAppendQuery"
DoCmd.SetWarnings True
CurrentDb.TableDefs.Delete "TableToStoreTheNewData- temp"
Me.Requery
If Me.RecordsetClone.RecordCount = 0 Then
MsgBox "No new record to import" & strID & vbCrLf & vbCrLf & " No new
records have been imported" & vbCrLf & "End Process", vbInformation, " "
Cancel = True
End If
End Sub


Good Luck
 
Back
Top