Recent content by AshikHusein

  1. A

    Requery form does not work

    Thanks for the great help!! That worked like a charm!! Really appreciate it!
  2. A

    Requery form does not work

    I have a form in which the boxes on the top part of the form accept the criteria which go into making up an SQL statement which then helps build up a query using querydef. The fields in the bottom part of the form are bound to the query created above using querydef. When I change the query...
  3. A

    Query Def object does not have text as criteria

    Hi, I got it!! in the SQL statement I had to put in """" & name_of_car & """" (where name_of_car is YYA5(204) from the Combo Box. Thanks for your willingness to help. Regards, Access is really cryptic!! but logical!!
  4. A

    Query Def object does not have text as criteria

    The value in the combo box appears as YYA5(204) but this is pulled from a table where the data is classified as Text.
  5. A

    Query Def object does not have text as criteria

    Hi, I am trying to pull a value from a combo box on a form to be used in SQL in the WHERE part. The field of the table from where the combo box pulls list for the combo box is "Text" However, when the query is created, it gets populated into the criteria without the quotations i.e. instead of...
  6. A

    Not a Valid Password Error

    Compact and repair did not work..Is there any way I could do it through VBA?
  7. A

    How do I get the form to be of a certain size

    Hi..I figured out how..just set the "pop up" to yes in the properties..Thanks for all those who tried to help. Rgds.
  8. A

    Not a Valid Password Error

    I am trying to link some tables to my front end and the tables are within an encrypted and password protected database. When I link the tables, it asks me for the passwork which I enter and the tables do get linked to the fron end.. However when I try to attach the table to a combo box or try...
  9. A

    How do I get the form to be of a certain size

    Hi, I am coming back to Access after a while and have forgotten how to get the form to a certain size..The form enlarges to full size in form view..I use Access 2010 :(
  10. A

    Is there a change in the "Year" function in Excel 2010

    Hi, Thanks for the response..it does work..the problem is that some of our folks have the new version of Excel and I have the old..they "thought" that date was a problem but it obviously isnt since I tested it on their computer after your reply. Thank you. Regards, Ashik
  11. A

    Is there a change in the "Year" function in Excel 2010

    Is there a change in the "Year" or any other date function in Excel 2010 compared to the previous versions of Excel. In the previous version Year(some date) returned the year of "some date".
  12. A

    How do you reference the value in a text box

    Thanks! That was extrememly helpful!!
  13. A

    How do you reference the value in a text box

    Hello, I am getting back to Access VBA programming after almost 4 years and just cant remember how do do some simple things. I want to get the value of a Text Box in a form called "frm_form_welcome" and the Text Box is called "Text11". I have set it to a date format and am trying things like...
  14. A

    Color of a border edge

    I am trying to get the color index number of an edge of a cell. So for example, for the cell B2 the code is color_index = Range("B2").Borders(XlEdgeTop).ColorIndex msgbox(color_index) This returns -4142. But if I change the range to say A1 (which is a cell without a border), it still returns...
  15. A

    Disable Macros

    I am trying to create modify an application in which if the users selects "disable Macros" the application should close. I am not sure how to go about it. Would appreciate guidance. Thanks Ashik
See more
Top Bottom