Search results

  1. M

    Too many popups on query run

    to run this line, I get too many popups : DoCmd.OpenQuery "QryMonthyPays" "QryMonthyPays" is a Make Table query. ...run the query.... ....is about to make a table.... .....is about to delete the existing table.... ... How can I avoid all these popups ? Anything that I could change on Options...
  2. M

    Solved Object variable or with block variable not set

    I get this error message : Object variable or with block variable not set on this : Private Sub CmndAddTenant_Click() Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim TSSN As String Dim TFN As String Dim TDOB As Date Dim msg As Integer Dim TF As String Dim...
  3. M

    Solved Reference a Property.....

    I appreciate your time and help in advance. I get this error message : "You can't reference a property or method for a control unless the control has the focus." on this line : "Me.TenantName.Text = """ I need the textbox TenantName to be cleared ....
  4. M

    Solved If .NoMatch Then , Doesn't work

    Appreciate your help in advance, on this program , I can't get the If .NoMatch Then part working... when there is no match I want to get the message says 'welcome". ----------------------------------------------------------------------------- Private Sub SSNumber_BeforeUpdate(Cancel As...
  5. M

    Solved MS office cannot find the field ... referred to in your expression.

    I need and appreciate your help. Running this program I get the error message: MS office cannot find the field ... referred to in your expression. Highlight stands on the red line. I have a table :TblePeople , a form with a textbox which gets TenantSSN. if it exists in the table, a massage...
  6. M

    Transpose column to row

    I have a table with one Field and 83 records. I need to transpose this one column to 83 columns, so I would have a table with 83 columns and one row…. Is there any way to do this? Appreciate Maryam
Top Bottom