Search results

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...

Yeah...It is going to be tough task for me as the didn't consider the old database design when he is developing the new one.thanks for your suggestions.I will try to start importing...I will bug u if i had any issues...lol...Thanks again..

Hello, I need suggestions from you how to approach for the following scenario. I have 2 ms-access databases in 97 right now.One of the developer designed a new application adding some new features.New database is in SQL right now.I believe the columns and validations are not same in both...

I am able to solve it.Thanks pbaldy for your suggestions today. You are so helpful. Thanks,

that makes sense to me..I think i asked you the wrong one... Actually there is textbox field which is being populated automatically by some random calculation.I am not able to find out where query or code is related to it.I tried to by going in to design mode and then looking at properties.I can...

thank you...I am able to figure it out...It is in the query.I have one more question which is simple to u. There is field which is calculated as below in a query.basically i think it has to be like deducting 6 months.Now I want to change it to 3 months. Between (Date()-148) And (Date()-154)...