Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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
  8. 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...
  9. C

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

    Hello! There is a form that will be completed by users. Four text boxes/Combo boxes that require the user to enter information. They'll hit save record command button and it'll save to the subform/table. But the issue is a user decides to only complete two text boxes, on purpose, and leaves the...
  10. C

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

    Hello! Need some help regarding a TextBox within a form that needs to be populated already whenever a user enters the form and can add additional information within the text box. For example, a TextBox in the MainForm must have "ABCDEF" inside of it by Default and can't be removed/backspaced...
  11. C

    Make a Combo Box non-editable

    Hello! I would like to create a combo box within a form that is non-editable. Only the user can select the two options and not be able to enter any other value or text into it and hit save. For example, combobox has two values 1. Business Value 2. Business Budget I want the user to select...
  12. C

    Solved Closing an Open Form when a user select a New one

    Hello! I have a MainMenu Form where a user can click on one form and it opens up to something. Is there a way for the MainMenu or previous form to close automatically? MainMenu frmBusiness (Example of form) For example, a user selects a frmBusiness on the MainMenu, the MainMenu disappears in...
  13. C

    Solved MS Access Branding in Forms (Ribbon)

    Hello! Just require some help regarding form design. An individual would like the MS Access - "Square" and X removed from the forms. The customer would like that part removed to make it better. A close button has been added on the forms so that ribbon at the top must be removed. Thanks!
  14. C

    Solved Delete Subform Records from a Command Button in the MainForm

    Hello! I have a MainForm with a Subform inside of it. The MainForm is filled out by a user and the data shows below in the subform(Datasheet) I want a user to select a record below from the subform, and click on the Command Btn "Delete Record" in the MainForm in order for it to execute. I have...
  15. C

    Combo Box Selection Filters Results in Subform

    Can a filter occur for combo box selection into subform
  16. C

    Combo box for "Search" and "DataEntry"

    I've been looking through the forums/Youtube videos to see if a combo box in a form can "Search" and conduct "Data Entry" into a subform. I have a form set up that selects information from a combo box and other fields and displays that information into the subform. For Example inside the combo...
Top Bottom