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

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

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.

same problem if I open a new db with new tables and forms.

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

I love your idea. Thank you very much . I also found another solution ,I had to change the language setting in my laptop and make the default language in my computer Arabic not English. So no more code needed for the msgbox .

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.