Recent content by johannaellamay

I have the same tables and query above. What I am actually trying to do is I'm creating a company-based form. We call it Property Accountability Form (PAF) where information about a certain property and the staff assigned are placed and they also sign it. The form should contain the following...

Yes I understand. I'll explain what I'm trying to do in my next reply. About "Properties", my table's name is actually "t_Properties" :)

Hi! Thanks for the link. It was extremely helpful. :)

Hi! Thanks! It works now. This is the final code on my Main table: Private Sub txtCurrentUser_Click() DoCmd.Close acForm, "f_Main" Forms!f_Login.Visible = True Forms!f_Login!txtUserName = "" Forms!f_Login!txtPassword = "" End Sub

Hi! No, I don't want to close the form. I just stated that hypothetically. When the same user is logged, I still don't want the data to show for security purposes. But that's besides the point. I just need to find a way to clear the unbound textboxes when I reset the Visibility to True again...

Hi! Yes, you're right. But Login form is not closed. The visibility is just set to False. So it's still basically running in the background, therefore, the data is not cleared. If I decide to Close the form instead of False Visibility, the value of the username will not show on the Main table. I...

Hi! I have two tables for Employees and Properties of the company. Each property is assigned to a particular employee. Here are the details: Employees Table Last Name First Name Department Position Supervisor Date Hired Location Properties Table Property number Item description Assigned...

Hi! I have a Main form and a Login form. When the user opens the database, the Login form opens. Text boxes for username and password are unbound and connected to a table that stores authorized usernames and passwords. When the username and password are correct, the Login form is set to Visible...

Never mind. I was able to make the captions work. Instead of clicking the Form button, I used the Form Wizard and just chose Datasheet! :)

Hi! I tried what you said and it could work well. However, I am limited with the width of the form. I can only add fields that can fit in 22" width. Is there any other way to change the field names on the interface? :(

Hmm. Yeah I guess it's the only way. Thank you!

Hi! Thanks for the quick reply. Yes, I understood what you mean. So what should I do if I want to change the field names in my datasheet form? I cannot find a way to change the name.

Hi! I have a table composed of more than 20 fields. Each field I put captions. When I run the table, the captions work well and appear as I like. For example, the field name is LastName and the caption is Last Name. The problem is, when I make a form and set it to datasheet view, the caption...

Noted! Thank you. :)

Hi! Thanks for the links. I finally made it work. But I just experimented. Please let me know if I did something wrong: Private Sub cmdAscending_Click() If IsNull(Me.cboField) Then MsgBox "Please choose a field.", vbOKOnly, "No field to sort." Else Form.OrderBy = "[" &...