Recent content by rajesh876

Thank you for the help John. I am able to open the excel sheet after replacing the following code. Sub OpenSpecific_xlFile() ' Late Binding (Needs no reference set) Dim oXL As Object Dim oExcel As Object Dim sFullPath As String Dim sPath As String ' Create a...

I inserted that code in VBA editor.It is giving me an error listed below. Compile error: Method or Data member not found. Do we need to include any libraries or parent directories? Thanks,

Can you/someone please help me how to open up excel sheet in VBA code ? Thanks,

Ohh...Its my bad....I thought it is doing nothing. It is exporting the data to excel sheet. It is just not opening the sheet. Do you know how can i open that excel sheet? Please advise. Also,Can u suggest how can i make the headers bold while exporting to excel? Thanks, You are a great help...

I had written this in click event. Private Sub Command4_Click() DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "dbo_rpt-Metformin_Sulfonylurea", "W:\Prospective Patient Database\ReportsExcelSheets\MetforminSulfonylurea.xls", False End Sub Do you think i am doing something wrong...

Thanks for the reply. Can you post some sample VBA code having Docmd.transferspreadsheet to export into excel? It would be very helpful.

Hi, I am newbie in access. i have a requirement to show so many fields in report. Access reports are not good to display that. I don't want the end user to open the table and look for the information. So,I want to open up an excel sheet when they click on button and display the table/query...

Wow...I didn't realize i was in a trouble...I am keep on trying several ways from 2 days..I donno what to do..May be i export the database to Sql server but it requires lot of of time and effort..Throw any ideas if find any later..Thanks for ur suggestions today!!

I have only .mdb file. There is no special .mdw file. Also, what do you mean by SHORTCUT. I am opening the .mdb file directly which is on network drive. I copied in to my desktop and i am trying to remove security. Do you think i should Change System.mdw file? sorry...I am not much familiar...

Thanks for the suggestion. I tried in the same way. I selected users group and assigned all the permissions.Later,I imported in to empty new database. But i am still getting that read-only error. Please suggest me if i am doing wrong or if there is another way.

Hi, I have this strange problem from 2 days. I couldn't figure it out where i need to remove security. Error: The database 'test' is read-only.You won't be able to save changes made to data or object definition in this database. This is really old database.It is in access 2003.I make sure the...

I did in the other way.Thanks for your reply though.I wanted to update before because we have 2 databases of same kind with some simliar data.So i have to change the autonumbers in one database.i.e reason i asked this question.Thanks,

Hello, I am trying update the Uniqueidentifier column through all the tables in my database.When i executed the following query,I am getting an error that field cannot be updated. Please tell me how should i update the Uniqueindentifier column.Datatype of this column is autonumber. UPDATE...

hello, I am in the process of migrating data from access to sql server 2005. We have 3 separate access databases having the tables and structure.but the data is different.I have to import all this data to sql server in to 1 single database.I am able to import successfully 2 of the access...

Hello, I am getting the following error when I am trying to import the data from an existing database to an empty new database. "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." The reason why i am...