Search results

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 = "[" &...

That's exactly my question. How do I tell Access to sort ascending and descending? From what I've made so far, I thought when I used Me.OrderByOn = True, it will be sorting Ascending so I was looking for a way to sort Descending. Or did I get it wrong? Do you have any suggestions for the codes...

Hi! I have a problem with my code. I'm trying to sort and filter a continuous form. Sort ascending and filters works perfectly fine. But my descending button doesn't work. I basically have a combo box which contains a field list. Then two buttons (asc. and desc.), then a text box for filter, a...

Hi! I was finally able to create my code for sorting my continuous form. However, filtering is a bit of a pain. Here's my code: PPrivate Sub cmdAscending_Click() If IsNull(Me.cboField) Then MsgBox "Please choose a field.", vbOKOnly, "No field to sort." Else Me.OrderBy =...

Also, I tried using VBA on my form. Then after a while, Access keeps asking me to setparameter on cboField. I even deleted my codes which had cboField in them but it still kept asking me for it. I have no idea why. It's really frustrating.

Hi Gina, I am still having issues with my sort and filter. Whenever I write the macros, it works perfectly. But when I try to close and reopen my database, Access just gives me an error and says that the macro does not work. I tried to read and analyze Allen Browne's example. But it didn't...