Recent content by foxtet

  1. F

    filter query result based on combobox

    Hi every one. In the small db attached I have query1. I want combo box selection in the form to be filtered in the query. combo box values include. Morning;Evening;All. When selected All query should append all results. Fox
  2. F

    Highlight the entire row when mouse moves over the row

    Can it be done by coding?
  3. F

    Update declare statement

    The error actually occurring some part of the code given below from this code where and what additional lines of code to be added? Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long Function fOSUserName() As...
  4. F

    Update declare statement

    Which part of the code do I have to add this? I don't understand yet
  5. F

    Update declare statement

    Dear Experts, I have used custom security module to login the database. This module works fine with 32bit systems. when attempt to run in 64bit it generates the error find in attached. I have attached sample login module. Can any one update declare statements as mentioned in the error message...
  6. F

    Highlight the entire row when mouse moves over the row

    Hi every one Is there any way to highlight the entire row when mouse moves over the row in the continuous form? If any suggestions please share foxtet
  7. F

    Double click continuous form to open another form

    Hi one more help on this Is there any way that can be possible to highlight the entire row when mouse moves over the row in the continuous form. In this case tbl_Contact_Info form. foxtet
  8. F

    Double click continuous form to open another form

    Hey sneuberg Its accurate..timely reply with full solution.. Thanks in millions!!!!
  9. F

    Double click continuous form to open another form

    Dear Guys, How to open frmEditContact form when I double clicked the continuous form. sample is attached for reference. Please give me solution foxtet
  10. F

    display save data on subform on another form

    Thank you arnelgp, It helps but there is run time error 438 could you get a fix to throw this away foxtet
  11. F

    display save data on subform on another form

    That is helpful. Now instead of refreshing whole form how do I refresh or Requery a control in a form. In the attached sample On AddNewContact from there is designation text box. If designation is not available I have done to double click that text box to open add new designation form...
  12. F

    display save data on subform on another form

    Hi Guys! I find it difficult to get data on available contacts subform when i click save button in add new contact form. I have used a macro on click event of save button on add new contact form to do this but its not working can you review this issue and get me a workable clue foxtet
  13. F

    Search Facility using text box

    Dear All I want implement search facility using txtSearch. and btnReset. the code is as follows. this doesnt work fine. Any help is greatly appreciated. foxtet Private Sub cmdReset_Click() Me!txtSearch.SetFocus Dim strSearch As String strSearch = "SELECT * FROM tbl_Entity_Info" Call Form_Load...
  14. F

    Open correct report

    I use the following command. it displays all records.but I want display specific record. Private Sub cmdInv_Click() Dim strReportname As String Dim strCriteria As String strReportname = "rptInvoice" strCriteria = "[InvNo] = & Me.InvNo" DoCmd.OpenReport strReportname, acViewPreview...
  15. F

    Open correct report

    I have a billing form. After input necessary data I want invoice to be created. When I press create invoice button it displays different invoice. how to handle this? foxtet
Top Bottom