Recent content by chickenwings23

  1. C

    Cascading Combo Boxes on a Form.

    MajP. Thanks for helping out. But i have a concern with the code created in the second form to search business reqs. When I turn the file into a .accde file I receive an error message when trying to search for a field. "The expression on change you entered as the event property setting...
  2. C

    Invalid use of Null

    Hello, I have an access file (.accdb) that performs all codes properly, has no errors, etc., but when I create it to a user file (.accde) and try to search/filter a name within a form. I receive this error: "The expression On change you entered as the event property setting produced the...
  3. C

    Cascading Combo Boxes on a Form.

    Hi, I need help cascading combo boxes in a particular form, and I cannot figure it out. I am making a nonprofit database for our local community institution to make it easier for them to estimate business expenses, etc. I have a form called "Resources" where community members can input data...
  4. C

    Solved VBA code for emailing an individual when a record is deleted from a table(s)

    Hi, Is there a possible code to notify the Access Database Admin through outlook email once a deletion occurs from a particular table or tables? For example, there are ten records in such a table. The user deletes one because it is unnecessary, but the database administrator wants to be...
  5. C

    Solved Include a Text Search Box in Form to obtain results from subfrm

    MajPs code worked to allow a user to search for just the Name: Private Sub txtSearch_Change() Dim fltr As String Dim rs As DAO.Recordset fltr = "ResourceName Like '*" & Nz(txtSearch.Text, "") & "*'" Me.subfrmResource.Form.Filter = fltr Me.subfrmResource.Form.FilterOn = True...
  6. C

    Solved Include a Text Search Box in Form to obtain results from subfrm

    Hello, thanks for helping out, but is there a way for the Search box to search all the components within the table and be able to make edits to the data? For example, right now, the Search Box allows a user to search "Resource Name," but I would like it to explore all the components - Resource...
  7. C

    Solved Include a Text Search Box in Form to obtain results from subfrm

    Thank you both; it worked! Just want I needed
  8. C

    Solved Include a Text Search Box in Form to obtain results from subfrm

    Hello, I want to create an access file where associates can enter some essential data for later use. (Name etc.) Is there a way to include a Text Search box field within a form where it brings up the name I typed in? For example, in the tableResource I have the name John Doe, and I want to type...
  9. C

    Solved MS Access Screen Size Issue on other users

    Hello Everyone, I have run into a screen-sizing problem with MS Access. Recently, an MS access database tool was released to users, but a sizing issue came up as a concern that stopped the deployment's progress. On my end of the screen, the file opens up perfectly (Screen sizing is good...
  10. C

    Solved MS access Username displayed on Textbox field

    I was able to obtain the Windows User Name on the Form. I used this for VBA Code Public Function GetUserName() As String GetUserName = Environ("UserName") End Function. And in the MainForm Textbox User Name: =GetUserName() But When I fill out the information in the Mainform, ->Name, hour...
  11. C

    Solved MS access Username displayed on Textbox field

    Yes, I need the Windows User to pop up in the table and textbox field.
  12. C

    Solved MS access Username displayed on Textbox field

    I want the information to be stored in the table and also display on the form. I have a field in a table "user" and its in the form as well. but when i enter Environ("Username") in the textbox it shows "#Name?"
  13. C

    Solved MS access Username displayed on Textbox field

    Hello everyone, Is there a way to obtain the username of the Individual who’s entering information to display in a textbox or field. For example, if Mike Thomas opened the ms access database and entered information, is there a possible way for Mike Thomas name to autopopulate in a text box...
  14. C

    Solved Get Ribbon and Navigation layout back

    Alright I figured it out. I closed the application and on my desktop. I double clicked on the file while holding the shift key. It brought back the navigation screen. Once from there, I went into properties and found my code
Top Bottom