Search results

i am using this query....... UPDATE Drugs INNER JOIN MedUpdate ON Drugs.GenericName=MedUpdate.GenericName SET Drugs.DrugID = [MedUpdate]![DrugID], Drugs.GenericName = [MedUpdate]![GenericName], Drugs.MedicineCategory = [MedUpdate]![MedicineCategory], Drugs.BrandName = [MedUpdate]![BrandName]...

same problem... the above code gives the number of records to be updated, not the actual updated records

i tried that too, no success.:-(

no... i just visited different forums to get to this code, and it works fine so far... and how to Use code tags(#)???

i am using this code, and it is giving me the error.......object variable or with block variable not set Private Sub UpdateMedic() Dim db As Database If Dir("C:\CFS\Update\Update_Medicine.xls") = "" Then Call MsgBox("Source File does not exist!" & vbCrLf & "Please Create a...

this gives me the following error object variable or with block variable not set

as far as delete and append query concerns, it works great, but for update query it doesnt show the desired result. it shows total update able records, but not the actual updated records.any ideas..........

i ll post it, but once you have disabled it, and you dont have any control to enable it again, you simply cant enable it, thats what i guess..... any ways i ll post it for you, ...im at work now...

i found the solution problem solved

i found the solution problem solved

thanks, i ll give it a try,

i have tried that too, no result, ........

hi im developing database in access 2007. i need to bypass / disable the shift key at startup, thus not enabling the user to use the shift key and enable the navigation pane, default menu and access options. i have gone through all the forum, searched a lot, tried AllowBypassKey2kTo2k7...

hi im developing database in access 2007. i need to bypass / disable the shift key at startup, thus not enabling the user to use the shift key and enable the navigation pane, default menu and access options. i have gone through all the forum, searched a lot, tried the above given 2 solutions...

i am using this code to delete the records from table pls tell me how to implement the above described code into it,,,,or any other code Private Sub Command33_Click() Dim iResponse As String iResponse = MsgBox("You are about to delete all the Medicines record." & vbCrLf & "Currently there are "...

thanks for the help. it did work

i know Dcount() will work for me, i just dont know how to get this function in msg box. i need message box to display like this: Total No. of records in Table A are 1500. Total No. of records in Table B are 1000. Total No. of Records in Table C are 900. can u elaborate a little bit pls

hi i need to view the total number of records in 3 different tables, to be displayed, before running a query, and after runnig the query, i also want, after running the query ( update or append), that how many records have been adde, or updated. i want these results in a message box, using vb...

hi im using update queries, and append queries to update records from excel sheets, all i want is to view the result of successful query running. i may need something like, if the query runs successfully, ........ else move unsuccessful records to a new table to follow up later, ... and the...

thanks for help!