Recent content by 3link

So basically I want to type something into a textbox and have that automatically run a query in my listbox for like values. This is the code I'm using. txtProperty = Text box lstSearchResults = List Box Table = Table Private Sub txtProperty_Change() On Error GoTo Err_txtProperty_Change...

Thank you! That did it. I changed it to expression IsNull(ControlName.Value).

I have a standard input form with 8 textboxes that require input. To help remind the user to fill each textbox, I am trying to apply conditional to each box (basically red background when value = ""). This works when the form first loads. But as I move between records or create a new record...

Thank you! I'll look at this more closely tomorrow when I have a fresh mind, but it seems to make sense.

In my current setup, I have a control that counts the number of invoices I have produced for the year, and adds 1. It also adds the date and year. So it looks like this: 0216-040 This means the invoice was produced in February 2016, and it is the 40th invoice of the year.

I have a table that tracks jobs I receive from clients (jobs table). Each job has various tasks, which I track with a separate table (tasks table). I also have a third table that tracks billings (receivables table). When I bill clients, I bill for every task associated with a particular job...

I have a large report that generates information specific to a large list of contacts. I would like to email each contact a .pdf of their part of the report. If possible, I'd like access to run a loop and do this in one button click. I'm not even sure to begin with this and I can't find any...

Thank you. So I have to use VBA for this? I've just been using the macro builder. I guess I could just convert the macro and then add those lines.

I want to attach a macro to a button that runs several update queries without opening (or displaying) any of those queries and without any warnings (like the warning you get that you are about to update several records). I just want it to execute. I'm making this for someone who knows even...

I revised the code a bit to define rdSet as DAO.Recordset and set it as Me.recordset. Now I'm getting an object required message for If IsMail(Item) then

Thank you. But I'm getting a "Sub or Function not defined" error for "rdSet".

I'm trying to write a code that automatically composes an outlook email message (but doesn't send on its own). I need the code to attach the PDF that is attached to the current record. Specifically, all of the records on my table have PDF attachments. I need to send these attachments with...