Search results

Thanks all for your help. I tried this and I still got the same error!!!!!! Debug.Print "Instit= " & rs("TBL_Institutions.InstitCode") Any idea???

jdraw, thanks for your response. Do you think that the query itself has some problems I mean since it is a union query?? You have also mentioned that determinings which "InstitCode'" might cause this problem! what do you mean by that? Thanks again.

I'm facing a problem and I really appreciate eny help with this. In my continuous form I have this query in the record source SELECT DISTINCT TBL_Institutions.* FROM TBL_Institutions INNER JOIN Tbl_FieldInstitJctTbl ON TBL_Institutions.InstitCode = Tbl_FieldInstitJctTbl.InstitCode WHERE M<>""...

I am using Access 2007 and trying to set the BackColor property of a text box on a form using VBA Code in the Form_Open event with code like this: Me.txtName.BackColor = <some global variable> Here's the thing: In order to get the correct color numer, I first pick my desired color from...

Thanks for replying! Can you please submit a sample code. Thanks again.

Hi all! I really need help with this!! I have a form which displays list or applications in continuous form and when the user clicks on the application ID the attached subform is displayed with the corresponding data! What I need is to highlight or bold the application ID if it is clicked just...

Hi all. I really need help with this! I have a continuous form displaying Name, DOB and ID and I have a control button that when I click on will store the above values on another table. My problem is that I need to validate the data entered and make sure that all fields are filled! I tried using...