Search results

I have a form where i'd like the textbox (Textbox_Search) to call the command i have already formatted in the search button image (Img_Search) on keypress. I've gotten this far Private Sub TextBox_Search_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = 13 Then Call...

Hi guys thank you for your kind replies but no matter how much i modify the coding based on your references, the error keeps popping up!!!

TempPass = DLookup("StaffPassword", "Staff_chelsea", StaffId = & Me.txtloginid.Value) Do you mean this?

Upon running the code, i am unable proceed if I fill in invalid information in both the staffid and staffpassword table The highlighted is the coding that the system keeps highlighting Private Sub Command1_Click() Dim TempPass As String If IsNull(Me.txtloginid) Then MsgBox "Please enter...

Thank you so much you have been a great help!!!

yes it is only a textbox!!! then the search command is tiered to the search button next to it! Do i need to change the text box to something else?

the search bar is embedded into the form header!!!

I have a problem where i have a search bar in the header of a form and in the previous form i set this coding DoCmd.OpenForm "formname with the search bar", acNormal, , , acFormReadOnly I want to be able to fill in the search bar but also be able to view the form in a readonly view is there...

I have a text bot named txtDate and for my form timer event is the following code: Private Sub Form_Timer() Me.txtDigitalClock = Time Me.txtDate = Date End Sub It works perfectly on my parallels as i am using a mac but when the form is transferred to another computer it shows #############...

I have set a prompt for the user's password before allowing the user to access the run query Private Sub imgIncreasePayslipbyDept_Click() Dim EnterStaffPosition As String Dim strStaffPosition As String EnterStaffPassword = InputBox("Enter your Staff Password", "Password Required") If...

Thank you so much arnelgp !!!!!!!! I AM SO THANKFULLLLL

I need help for an access assignment i have from school. I am trying to limit the managers and normal staff from accessing certain information in the database. I know that i can use a security level login but my submission is in a few days and i have yet to finish the other components. So...

Thank you so much for your help :-))))))

I've been creating this form for pages now and only today does this error occur, however, when I open the VBA to view and close it again, the form continues to work normally. This error is caused by the On Load Event and Mouse Move Event. My form basically has a date and time on the header In...

Started using Access as a polytechnic module requirement and im drowning in codes alr help me pls