Recent content by darshanhiranandani24

Hi everyone, I’m Darshan Hiranandani, in a bit of a bind and need some help. I’ve set up a database to track client activity for my team—though I’m not really familiar with programming. I followed some guides I found online to create the database, imported the right files, created a form, and...

Hello everyone, I'm Darshan Hiranandani, I have a table called "Dispatch Details" with the following columns: Dispatch Date Party Name Truck Number Freight Charges I’ve created a form that works for single dispatch entries. However, I now need a solution for cases where multiple parties are...

Hi everyone, I’m Darshan Hiranandani, using Microsoft Access to send emails through Outlook with a donor’s tax receipt attached. The email opens in Outlook with the recipient and subject already filled out, but it defaults to plain text format. I would prefer to have the email open in HTML...

Hi Everyone, I’am Darshan Hiranandani, I've got a couple of questions and thought it might be more efficient to post them together in one thread instead of multiple, but please feel free to jump in with any thoughts or suggestions! Question 1: I have a table with 10 fields. If I create a...

Hi Team, I'm Darshan Hiranandani, need some help formatting a cell to create lot numbers in the format: SupplyID-Date-Ascending number. I’ve managed to get the SupplyID and Date part working, but I’m struggling with the ascending number that should reset for each ingredient. For example, I...

Hi everyone, I'm Darshan Hiranandani, working on a simple database for a small non-profit to manage donor information and tax receipts. I'm using the DoCmd.SendObject command in Access to open Outlook with pre-filled TO, SUBJECT, and an attached tax receipt PDF. The issue I'm facing is that...

Hello everyone, I'm Darshan Hiranandani, I have an MDB (Microsoft Access) file that is password-protected, and it also uses an associated MDW (Microsoft Database Workgroup) file for additional user-level security. I know the password for the database itself, but I am encountering issues with...

Hi everyone, I’m relatively new to Access and might have misunderstood some things, so I hope you can help me with an issue I’m facing at work. I recently made some tweaks to a form and report using a runtime version of Access, but now I want to revert to a backup I created by copying the...

I’m thrilled to bring my expertise to this platform. Beyond my professional focus, I have a deep passion for technology and gaming. I’m fascinated by how these areas intersect and influence each other, and I’m eager to explore and discuss these intersections with all of you. Technology's rapid...