Recent content by VSolano

  1. V

    Run-time Error 91 variable not set (class Modules)

    Thanks so much for your guidance. It help to clear up my issues.
  2. V

    Run-time Error 91 variable not set (class Modules)

  3. V

    Run-time Error 91 variable not set (class Modules)

    the code works fine when I remove the information from the class initialize. The error is in here Private Sub Class_Initialize() Dim Ctr As Control Set ControlCollection = New Collection For Each Ctr In oForm.Controls Select Case Ctr.ControlType Case acLabel...
  4. V

    Run-time Error 91 variable not set (class Modules)

    I am still getting Run-time error 91 Object variable or with block variable not set
  5. V

    Run-time Error 91 variable not set (class Modules)

    Hi, I am trying to better understand the class modules in Access vba. I created my first class and I am getting a variable not set error and I can not figure out what is the problem Any guidance will be greatly appreciate. ' the class module has the following code' Option Compare Database...
  6. V

    DLookup on a SQL statement

    Thanks all I was able to go around this issue by adding a table multiple times so I can link it to the proper Id
  7. V

    DLookup on a SQL statement

    I just using the DLookup to return a user name/approver from the same table
  8. V

    DLookup on a SQL statement

    Hello, I am looking for some guidance on the following sql statement which I am using as a record source of a form. I am not sure if I can use the DLookup in this way. Some of the issue is the comma after the Dlookup. when I have the comma is indicating error "3141 the SELECT statement...
  9. V

    Missing Value in combo Box while Opening another form using openArgs

    Thanks, I was filtering the row source of the bombo box
  10. V

    Missing Value in combo Box while Opening another form using openArgs

    Hi, Any input will be greatly appreciated I have a form where I open another form using the Open Args. The form opens the correct record without any issue. I noticed that in the form that is open, there is a combo box that is displaying no value or blank value even thought the primary key...
  11. V

    unbound yes no check box in a form not working

    Thanks, The main form edit was set to No.
  12. V

    unbound yes no check box in a form not working

    hello all, I am looking for any thought regarding an unbound check box in a form that is not working. The box can not be check or uncheck. Any thought will be appreciate
  13. V

    Recordset Bookmark return no current record

    I am just trying to filter record and copy value base on a criteria. Once the first value is copy I want o bookmark the record on the destination table so I can copy the second value to the same record
  14. V

    Recordset Bookmark return no current record

    I tried placing the bookmark at the beginning and I got the same result: No current record
  15. V

    Recordset Bookmark return no current record

    I declared the RSbookmark mark as variant. I did not copy this part of the code but I state it on the information. the bookmark was set on the else statement
See more
Back
Top Bottom