Search results

No Can Guide Me Hello Dear Sir How Can i Delete a record in a datasheet view. i mean if we want to delete a single record.i have to right click on beging of record then push the delete from menu and after that a msg appear.or select the record and press delete the keyboard. My """""Question...

Hello Dear Sir How Can i Delete a record in a datasheet view. i mean if we want to delete a single record.i have to right click on beging of record then push the delete from menu and after that a msg appear.or select the record and press delete the keyboard. My """""Question """"" i don't want...

Key Board Shortcuts. Thanks for your zip file

Hello i want to use the Keyboard ""Esc"" key to exit from the form. i mean when the user press ""Esc"" then the form closed. i want to use the """"Prt Sc"" to execute some report. can you give any detail file example in which i can see how to use the keyboard keys. Any Help Greatly Appreciated

Simple Code for one form Private Sub Form_Error(DataErr As Integer, Response As Integer) If DataErr = 3022 Then MsgBox ("Whatever message you want") DoCmd.RunCommand acCmdUndo SendKeys "{ESC}" SendKeys "{ESC}" End If End Sub

Use the code on error Event Use the Above code on error event.

Use this Code Before Update Event of the Form this is the code for the Northwind database for orders form use for your purpose. If DataErr > 0 Then If IsNull(Me.Parent!CustomerID) Then MsgBox "Select a Customer to bill to before entering order details info." RunCommand acCmdUndo...

Your Question is not Clear hello your question is not clear .open youu question what you want to do exactly. i am sending you a file check that it may be solution of your problem.

Hello i have combo box which have value.21,22,23. i want to enter the 21,22.in the field.i want that the afterupdate it will check the 21,22 value are in list if the value are not in list then it shows message. Mean if we enter 21,25. the 25 value is not in list so afterupdate it shows a...

You want to filter the record hello you want to filter the record against the id .mean if against id filter the other related record . http://www.candace-tripp.com/_pages/access_downloads.asp visit the site and download the example file cascade combobox

Hello Dear Sir. i want if a customer enter a value in a Text Field.Then if we go to new Record. In That Text Field The Last Value we enter last time Automaticaly Shows. is it possible.to show the last value next time in new record. Any Help will greatly appreciated

Dear Sir i am using the following code for combo box. i have a combo box search which have the customerid control i have a other combo box billno. when i select a customerid the other combobox select the "billno" against the CustomerId as you can see the code . i just want to do that if there is...

Dim sbillno As String sbillno = "SELECT [bill2].[autonumber] " & _ "FROM bill2 " & _ "WHERE [CustomerID] = " & Me.search.Value Me.Billno.RowSource = sbillno Me.Billno.Requery i am using this code but there is problem of...

This is not helpful Dear this is not helpful send me the code which we can use for avoiding dupplicate value. message appear when the customer type the same value which already in the table. i think the event for this before update.

when adding new record if id has duplicate value the message appera (default message from microsoft). how can we put our message.on before update event. not using macro. in vb code.???

how can i repair a file .i have not the backup file.. the microsoft help is not working.((ETC.FileName_Backup)))))

Id also text id is also text but there is error of mismatch datafield

Hello Dear. i have form with search combo box i am using this code it's working properly for Autonumber field but it is giving error for Text Field where is the problem message """Data Type Mismatch"" can any body help me Private Sub Search_AfterUpdate() On Error GoTo ErrorHandler Dim...

Dear Can any body help me to create a report month vise. when the month end then it gives us the result and then go further. Month Vise Ledger.???????

How can we take the overall sum in Query .(in calculated Field) like we can take in report in calculated field. Rich Help Me