Search results

See the attachment.. Le

Hi, Is it possible to use the mouse wheel go through a text box instead of using a vertical bar? Thanks, Le

Try this this database Le

Ok. Follow these steps. 1) Goto the "frmSearchPermit" , click on current and put the code: Private Sub Form_Activate() Me.Recalc End Sub 2) Goto the "tblUser" form, and put code on the delete button: On Error GoTo Err_Delete_Click Dim rsp As Integer rsp = MsgBox("You will delete...

Second try... Le

Try this one... Le

I did several changes on the forms. Frist, I put me.recalc on the frmPermitSearch. Then, on the delete button, I took off me.Restore and on the query "qryUserTblData" I took off the table "tblItemNumHold". Take a look on the database. Hope this help, Le

I have done a query , "qryEmployees" and put it in the source on the New Starter form . Take a look on the "qryEmployees" and on the New Starter form. Hope this help, Le

Not quit sure understand your message. The Shift field is still visible. Le

In your TabCtl30, instead of putting Me.Requery change to Me.Recalc, Le

Try this... Private Sub Form_Current() Me.Recalc Me.Button_Name.Caption = Me.FieldName ' text field that you want the text appear End Sub Le

See attachement... I have replaced your list box by a subform. Le

See attachement.. I have fixe the query. But still the Search form seems not working. Le

In your query "qrySearchCriteria", the "PersonnelNo" field type does not match with your "Occupational Profile Ref" fieldt ype . One is a number field type and other is a text field type. First, you have to fix this. Hope this will help, Le

In your Main form, you have to put Modify = Yes and also to your subform Modify = Yes. Le

Hello, What is the code to detect a close form? I have to put in a condition statment. Example : If forms!frmWords.Close then ... End if But this don't work. The word "Close" isn't right. What is the snytaxe? Thanks, Le

The only thing you can do is add a subform. Le

For example, the "Ang RH Vibe Pts", how do you calculated this? Give me the fields for this calculation. Or, what is the vector sum is it like this : Vector sum = X*X + Y*Y + Z*Z ? and what are the fields do you need to calculated these fields : TTR EAV LH hrs, TTR ELV LH hrs, TTR EAV RH...

Your query causes the problem. If you run the queries "qryTestData" or "qryEAVandELVtimes", you will see at the end, it contains a blank record which means that you can add a new record. But if you run the query "qryCombinedData", you don't see a blank record which means you cann't add any...

If you can, transfere your tables and forms to a new database. Then, copy your tables but this time, choose the option copy table structure only. So, you will have the same structure of your tables but without data. Delete the old tables and rename the new tables to their appropried names. This...