Recent content by Programming

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

but I do not want to show it in combo , I want to show it in text box

Because I want data to be shown in textbox. I don't want the user to select or choose anything

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

No, I did not mean it like that. I have many tables , let us say for example the following Employers - Students- vacancy, contacts. let us say the user wants to know with each Employers who are the students who worked with. [ Employer table /student table] or Which of the Employers who...

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

But I want to store the selected data in a table

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?

Yes , I will do that. Thank you

Thank you . I tried to trace back what was the last thing that I did yesterday on my computer to find out that VBA is not working the next day. I can not understand this , but yesterday I changed the language setting on my laptop from English to Arabic so that Msgbox can show me messages in...

all situations. new one that I build- has data or not. even I tried to see if it will open for the template but did not. I tried to Repair Office , I even uninstalled and installed again. I opened my database on a different computer and it worked. Now what would my computer have against...