Search results

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

    Solved Get Ribbon and Navigation layout back

    That’s the thing. I don’t have access to the VBA code anymore since I can’t get back in. It completely removed it. Does control + something work in order to get the ribbon and navigation back?
  16. C

    Solved Get Ribbon and Navigation layout back

    Hello everyone, is there a method to obtain the navigation and access ribbon back once it’s been hidden. I can’t get the ribbon to comeback after I did a code to hide it. The “file” button at the top disappeared once the code was entered. Thanks! Appreciate any help
  17. C

    VBA code to delete records from subform and autopopulate fields in Main Form.

    Hello. This may be confusing to explain but I'll try my best. I have a Main Form and Sub form. Main Form is frmEstimateBr and subform is subfrmEstimateBr. When information is deleted from the subform, certain text boxes must autopopulate into the main form. I have a Saved Record button in the...
  18. C

    Solved Default Information in a TextBox with the ability to add more MainForm

    I wanted to comeback and thank you for posting this because I needed a TextBox (Year) to be defaulted as "2023" and no deletions or additions can be made within the text field so I "Locked It" and it works perfectly fine. The one above I needed a Default value to be in there but a user can add...
  19. C

    Solved VBA code, etc. to disable MS Access Debug Message Box

    There are many things wrong with this database that got thrown into my lap. Trying to break it down bit by bit for this client to be satisfied.
Top Bottom