Recent content by MaryamF

No there is no special justification for this approach. I don't know any better.

Private Sub TXTSSN_BeforeUpdate(Cancel As Integer) Dim dbs As DAO.Database Dim rst As DAO.Recordset DoCmd.OpenQuery "QryMonthyPays" Set dbs = CurrentDb Set rst = dbs.OpenRecordset("SELECT * FROM TblMonthlyPaysTemp WHERE SSN='" & Me.TXTSSN & " ' ") With rst...

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

Thank you. Yes, Declaring an Image , was causing the error... It's still not clear to me , how to add an uploaded image to the table...

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

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

Where should I put this line: Cancel = True

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

Thanks. it works with no errors. But, I have an issue. After I get the message that the SSN already exists, I get Full Name and DOB and Phone Number pop sup to textboxes and I want to continue working on other textboxes for this SSN. But now, I have to change the SSN .... the whole project is...

Thank you. I don't get the error anymore. But the record I got from the table is the first record, not the one I want. I wrote a findfirst: rst.FindFirst "[SSN] LIKE '" & Me.SSNumber & "'" I get this error: operation is not supported for this type of object.

I get error on this line : operation is not supported for this type of object rst.FindFirst "[SSN] LIKE '" & Me.SSNumber & "'"

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

Yes, the entries are all different, and I need to work on more than 1000 tables! So it's impossible to do it manually....

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