Search results

the following code gives me error of missing operator. can anybody help Me.RecordSource = "SELECT tblEmploymentEngagementEvaluation.EEVID, " _ & "tblEmploymentEngagementEvaluation.EmployerID , " _ & "tblEmployer.EmployerID , tblEmployer.OrganizationNameEnglish, " _ & "tblContacts.ContactID ...

I created my first database project in Access. And I intend to set it up in a local network to be used among 4-5 people. Some of the programming was in VBA and some in Macro. My Questions is , will I have problems because of the some of the functionalities are in macro and some are in VBA...

I have two tables Students table where it has StudentName and StudentID Course table where it has Student ID - CourseName -CourseID The field pf StudentID in the course table, I made it lookup field to show the StudentName instead of the StudentID. In the form of courses however, it shows...

I am new at using vba . I want to create a form in which the user can search data from all the tables. The problem I can not predict what he/she reach out. I have many tables that are linked to each other. I know how to create a query from access window. but the user will not have access to...

in my form ( continuance) if the user click on the ID it will open another form related to the ID. I do not want to show the ID number and instead I want to show word (open) or view . how can I do that

the following code gives me error if the text box is empty Dim JobDescription_var as String JobDescription_var = Me.JobDescription I think I should use Nz but I don't know how. Please help.

the second if statement in the following code gives me and overflow error. If Me.NumberOfVacancy.Value <> 0 Then If Nz(Me.StudentID, "") Or Nz(Me.EmployerID, "") = "" Then MsgBox ("You MUST choose a student and an employer") GoTo Endcode End If What...

Hi, My combo box selects the first value in my table , how can I prevent that?

My vba Editor in access is not opening anymore. when I click on code builder , it closes Access. Any idea? I tried to decompile but did not work. and this is not only on my database , but also on any new database I try to create.

access crashes when I try to open the code builder. Please any help . I tried to do the following o decompile your database, follow these steps: " From Windows Explorer, locate where your Access program is installed by searching for MSACCESS.EXE. If you have multiple versions of Access...

My msgbox shows me ""??" when it wants to report data stored in Arabic language. How can I make it see other languages other than English.