Search results

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

    Recordset Bookmark return no current record

    Hi I am trying to bookmark the position on a recordset to later return to the same position and the bookmark codes is returning no record. I have not used this before but any help will be greatly appreciated. The problem is when stepping to RSBookmark = rs4.Bookmark the rsbookmark has been...
  17. V

    Adding Default value of zero when there is no any value

    Does not works means it does not print zero when the value is null. The invoiceamount is a field in the new table. I am pulling the invoice amount from one table and copy into another
  18. V

    Adding Default value of zero when there is no any value

    I tried both of these options and it does not work. I created this field on the table using the tabledef and I created as double.
  19. V

    Adding Default value of zero when there is no any value

    Hi all; I am having a hard time adding a zero to a calculated value to a group of fields on a table. I can not add this property under the table because I am deleting and creating the table often. I tried NZ and Format and I was not able to see default zero when there is not value. Any help...
  20. V

    Reuseable Where Condition

    I am not following the original advice. The variable are declared outside de procedure
Back
Top Bottom