Search results for query: *

guys please help me out here. wha ti am trying to do is import access table in my current back end database which is sql server, and my front end is access( using 2000). after browsing accessdatabase and listing tables in listbpx, i wanted to import to my currentdatabase by selecting tabels...

help me out here guys. it still gives me the expression you entered is wrong data type' i even tried this with DSN Private Sub ListTables_AfterUpdate() docmd.TransferDatabase acLink, "Microsoft Access", dbname, acTable, Me.ListTables, Me.ListTables docmd.TransferDatabase acExport...

Sql Sister i havenot yet come up with this..

AnyOne....plz

i used this code, and i am getting the error saying" The expression you entered is wrong datatype for one of the arguments." i know i selected access database. any idea. btw i am trying to import the selected table into sql server, which is my backend. ANY HELP Private Sub...

thanks for the tutorial, i really need to take a look at that once i am done with this. seriously, i know where i stand. appreciate it. But the code you posted above doesnot do anything, i mean, well it doesnot changes anything. when i pass this on my subform to updates as you have posted...

it still gives same error and points at "Private Sub InternalTransactionGrade_AfterUpdate(sValue As String, sBorrowerName As String, sExamName As String, dAsOfDate As Date) "

actually it gives messagebox with above posted message on it. and when you click ok it doesnot points to the code like other error message does. But when you compile project it gives same error and points to "Private Sub InternalTransactionGrade_Change(sValue As String, sBorrowerName As String...

yes i did, still same error

when i run the above code from my subform where the combo boxes are, from on change event of the conbo box. when i change the value in combobox it gives me message box saying " the expression on change you entered as event property setting produced the following error:Procedure declaration...

Private Sub InternalTransactionGrade_AfterUpdate(sValue As String, sBorrowerName As String, sExamName As String, dAsOfDate As Date) Dim strSql As String Dim db As ADODB.Connection 'Assuming you are using ado Set db = CurrentDb.Connection 'I think that is right strSql = "UPDATE tblMaster SET...

ANy Idea, SQl sister, or anyone else help me out here, plz

i donot know whether this works or not.

i have file browser which opens access database and loads the tables into list box. now what i want to do is to select the tables and able to import it into sql server. how do i do this. i found sample code in VB to import excel spreadsheet into sql server, can you help me to understand this...

lets say, the new aadded field in those tables,lets take 'tblexpectedutility' the new drawing ratio is added for different risk grade,( rating index for new would be 0), and i added new field exam date( where the change date for new drawing ration would be added).lets say i made changes of my...

can you give me idea about linking table.

actually is it just possible to add table in your sql databse. i donot know how that works. help me out here.

Thanks for tips SQLSister. i know exactly what you mean. since this hasto be fixed asap. what you suggest to make it work, thats first thing. this is the database from previous one( who was using this). these are the the rates( drawing ratio) stored in database. according to those rates the...

i ran the update statement on my subform 'creditmaster' on combobox onchange event, it gave same message as b4. i am not getting this. in main form there is already afterupdate event for that combo boxes. so on ran that on subform. i am not getting this, its just not hitting me.

i know what you mean but i donot know how to run this updated statment with your message box, CODE Msgbox "Update statement running from Main form combobox event", vbokonly, "Ran from main form"