Replies

Thanks Hans…..I think you posted your post while I was still composing mine….

Thanks it worked.
I just found out the easiest way to do it.
The Hyperlink address propert y of the command button can be used to set it up directly…..

Thanks a lot guys

Isha

OK then I would do it in two steps:
Will have a form with two command buttons: One will take the user to this webpage…..the user will download the excel file.
Second button will import the excel file into access.
I need some help in writing the code for 1st button.
By using the wizard that comes up when you put a new command button on the form I have been able to open the explorer on click of this button….code is:

stAppName = “C:Program FilesInternet ExplorerIEXPLORE.EXE”
Call Shell(stAppName, 1)

How can I make this page to go directly to a particular web site say http:/ /www.cnn.com/

Isha

Charlotte,
Yes my receipt control system is a Access database. I need to provide some interface in my application so that by clicking on a command button user is able to go to the webpage of website that is doing websurvey and download a file directly into the system (IF possible)…..otherwise into an excel file and then I could import it into my system.
This website has provibed a option by which we can download the excel file.
I hope I have been able to explain it properly….otherwise plese let me know…
Thanks…..

I realised all I want to solve this problem is the application path.
Here is the code that I used to get the path of the mdb:

Public Function GetAPath()
Dim FullPath$, AppPath$
Dim DB As Database
Dim iloc As Integer
Dim X As Integer

Set DB = CurrentDb

FullPath = DB.Name

For X = Len(FullPath) To 1 Step -1
iloc = InStr(X, FullPath, “”)
If iloc 0 Then
Exit For
End If
Next X

GetAPath = Mid$(FullPath, 1, iloc)

End Function

And then I am calling this function from the following :

Private Sub exportFile(qryName As String)

DoCmd.TransferSpreadsheet acExport, 8, qryName, GetAPath + qryName, True, “”
End Sub

Thanks.

Thread locked – please respond to the duplicate thread in Excel using the link below – WendellB 21-Aug-02 11:07
Hi ,
I need some help on this problem . I get a excel sheet from users.
In one of the column depending on the status of a task, cells are filled with either RED or GREEN color. I import this excel sheet to Access and then generate a report. Now in this report my users wants to see the same colors as in excel sheet. Is there a way to read the color in excel sheet while importing ??

Can you explain it a little more

No the .mdb was on my C: and I replaced the .mdb with a new one and it started working. It seems this problem happens in 2 cases because there is bug in the Microsoft OLE DB Provider for Jet version 3.51. Accidently one of the fields changed to memo and it started giving the error. For more detail on this you can go to
Memo field in Access:
http://support.microsoft.com/default.aspx?…b;en-us;Q198532

Thanks anyway
Isha

Mark, could you please give me a sample code.

Thanks!
Creating form in datasheet view is a fantastic idea.
Thanks a lot for your help.

You can deal with this problem in two ways…
The easy alternative is to add ‘On Error Resume Next’ immediately after all you dim statements.
The other alternative is to check each of your str variables for null within your addnew statements…

Like
With rsLog
.AddNew
If Not Forms!frmPhyChanges!ProviderName.Value & “” = “” Then
.Fields(“ProName”) = strProName
end if
Let me know if it still doesn’t work

I don’t know if you have do it just once or it is a routine data import.
if its not routine then you can do something like this
give all the columns some appropriate name and Import it to access.
in access you can make some queries to separate the data as required.

Instead of creating form again from scratch…try this
In th database window right click on the form name (the one with problem)
and click on ‘Save as Report’…..
give it a appropriate name and take a printout….
if u want to see this report from the form….provide a command button on the form
and on its click event call this report

Isha