Recent content by BHWATT

That is exactly what I was looking for. I knew it had to be something simple. Been driving me crazy. Thanks for your help as well as everyone else who commented!

I am writing a report that needs to compare data from this year to data from last year and data from two years ago. I am struggling to figure out what to put in the date field criteria to show data between January and December of last year. I don't want to do between 01/01/2023 and 12/31/2023...

Hey Guys, I have an access database that contains a form with drop down selections. I am trying to create a field that is populated based on the drop downs of these fields. Each field can be Pending, Approved or Rejected. I need to have a field called stage that will display Initial if all...

Actually I think I may have just figured it out. I put all of the code in the SaveBtn sub and then added in If Cancel = False Then DoCmd.GoToRecord , , acNewRec at the end and that seems tohave solved the issue

I have been working on a form and would like it to throw a message if certain fields are not filled in correctly. I have it coded to where it works the way I want it but the issue is I have it in the before update sub and then the button I click to save is coded DoCmd.GoToRecord , , acNewRec...

Hey everyone. I am creating a databse and I would like users to be able to attach hyperlinks to documents on a server. I wrote the code Private Sub attachment_Click() Dim dialog As FileDialog Set dialog = Application.FileDialog(msoFileDialogFilePicker) With dialog .AllowMultiSelect = True...