Search results

I've got an odd one. I have a DB where there's a long text field and for each record, this long text field always starts with a date. I am trying to figure out a way to automate pulling this first date for each record and updating a separate field with it. I have thousands of records that are...

Also, could you provide an example DB of this method by any chance?

Thanks! One (possibly stupid) question...where do I call the function in Gina's PDF example once it's all set up?

Thank you. Could you provide a sample. I'm really struggling to find a walkthrough of sending batch emails. All I can find is how to use outlook automation or sendobject to email out one singular record

It's only my machine. I'm the only one importing in new records. My org does not have sharepoint or flows

The form drops all the new entries into a temp table, and then an append query adds to the main table. Each record has a unique identifier so the append filters down to ones not in the main table before appending. I can reorganize that as needed, but I'm genuinely just getting stuck on how to...

Okay. So let's say my form imports in six new records. How do I code it so that six individual emails are sent out with six individual attachments of those records?

Okay thanks. So I've got it working using the SendEmail macro in the after insert. The problem is that there's no option to include an attachment. Any suggestions?

Thanks! Perhaps a dumb question, but how do I make a VBA procedure via a data macro? When I try to add an after insert event on the table, I am only able to make a macro. I can't find where to use VBA. The 'convert to VBA' button is even greyed out...

Sorry...should of clarified. I didn't include this in the example DB. I have a report that basically just has all the individual record's fields on it. I would want to send that report via PDF.

Complex one that I was hoping to get thoughts on the most efficient way to accomplish. I want access to send out an automated email of an individual record when that record is added to the DB. I have attached an example DB. Basically, I use a form to import an excel spreadsheet of records to a...

Thank you all! This worked

I'm trying to set the focus to a subform's field from the parent form, but I can't seem to get it working. Here's what I tried via VBA: Me!subform1.Form!txtsubformfield.SetFocus Any suggestions

I was able to figure it out. I had back style set to transparent and not normal. Thanks

I have a bunch of different text fields throughout the report though that I was hoping to use conditional formatting on; there's 4 different tables that I'm using dlookups on so I don't think all could be pulled into one query

I have a text box in a report whose control source is using a dlookup formula. When applying conditional formatting to that field, the formatting only appears if the user actually clicks on the text box. It doesn't always appear and also doesn't appear when the report is export to PDF. Any...

I have a query. There's a number field in the query where any record could have a value in it from 1 to 100. I am trying to group the query by 'employeename' and then have two count columns for each employeename. A count column where the number field is below 50 and another count column where...

@June7 See the (extremely simplified) attached example DB.

So the report has three fields right next to one another. First two are lookups to tables and the third is meant to show the difference between the two fields

On a report, I have two fields using dlookups and they both show percentages. I have a third field that is meant to calculate the difference between the two. I subtracted one field's name from another but am getting a #Type error. Any suggestions on how to correctly do this?