Recent content by MeU&Us

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