Search results

I think the ControlName_AfterUpdate sub has to exist before you can call it. Does the control in question have an AfterUpdate event already?

Link to Extended DLookup (from my previous post, was still under the 10 post limit for posting links): http://allenbrowne.com/ser-42.html

Just as quick note on this, I often use DLookup for situations in which I need to get one value from a table and return it to a variable in VBA and it works great (Just watch out for nulls and a few other gotchas). I've heard that its a bit slower then using other DAO or SQL based methods but...

Just thought I'd follow up on this post, I ended up cheating a bit and used excel spreadsheet to give me a semi-colon delimited string of part numbers that I just threw into regular ol' Windows XP Search. Not the most elegant solution but after I discovered that you can search for multiple files...

Thank you sir! I'll have a look at this and post back when I come up with a solution.

When do you want this to happen? I think the first step would be to decide which event you would like to occur before this change is made. By the sounds of it, you want this to happen after Combobox500 is updated? If so, in the AfterUpdate event for Combobox500 you would have something like...

Hi all, I've been tasked with taking a table of part numbers and finding the autocad drawing for each part number in a network folder and copying it to another location. Right now the table is a local Access (2010) table with a simple table structure of just 1 column called "Part_Num". Each...

I figured as much. Thanks for the prompt reply Bob, much appreciated.

Anyone know a way of implementing either of the two solutions posted without incurring the slow down caused from pulling the whole recordset in?

Also, if I set the visible property of the subform control to false, the main form still takes 10-15 seconds to load but once loaded, I can scroll without any "rendering" slow downs. I am really scratching my head on this one.

Hello all, I have a form called frmMain which is bound to a table called tblMaster. I also have a subform called frmSubForm which is bound to an BLOB attachments table called tblBlob and linked to frmMain by the primary key in tblMaster. My problem is that when opening the subform (in...

Hello all, I have a button in the header of a subform that when clicked brings up an insert file dialog for users to attach BLOBs to a form using an OLE field as the container. The problem I am having is tricky. If there are no records in the subform, and I've just opened the parent form, I...