Search results

Wow, that was fast, I'll check both out. THANK YOU!

I deploy my access-based application using Sagekey's wizard (2013 edition). Now, they're leaving the business. I distribute both 32-bit and 64-bit versions of my "application", compiled on different machines having Office 32-bit and 64-bit, respectively. The problem is that Sagekey is leaving...

Thanks, I was hoping someone would post more examples. Funny, I never noticed this before.

Posting this just in case others haven't noticed this. On a lark, I tried it and it worked! Me.txtConsumeCost = DSum("[cost]*[AmountUsed]", "qryfrmProposalWiz05Sub0400Parent")

Not that easy when the code is long and refers to other controls on the form. This works fine.

Just a late enhancement if anyone stumbles on this. To call from another form a public sub on a subform, this works: Call Forms("formName").Controls("subfromControlName").Form.NameofPublicSub

Thanks, that's some nice piece of coding. I thought about reading the mouse coordinates to grab info. I'm doing that now with the slider-imitation-control labels (based on some else's work). But, I can't find a way to read anything unless a selection is made, such as by using the arrow keys...

Thanks isadogs, it's not that big a deal to me if the functionality doesn't exist. It would be nice if the highlighted row could be accessed, for me it's the row number I want, but I could see perhaps using it to get more detail about the item and then popping up an informational form (I can't...

Hi DBGUY, I don't see intellisense options for those properties in the listbox. I think they may be applicable to textboxes.

Thanks CJ, but it's not multi-select and all I get is the selected first item (in the mousemove event). To get the highlighting effect, I have to click on one of the items. Then, while holding down the mouse button and moving up and down over the list I see different rows highlighted which serve...

Yes, with the mousemove event I can read the values and listindex of first selection, but I can't figure out how to read anything about the highlighted rows as the cursor moves up or down in the list. It's weird since the highlighted row changes and you'd think there would be some property of...

Ok, I thought I was a pretty good coder, but this one has me stumped and wondering if anyone can help with an obscure/arcane thing. I have a listbox on a form. When I select an item in the list, I understand how to retrieve anything needed. But I found that if I select and item, and then hold...

Thanks, that last code was brilliant and worked. I wish it would open the message to allow editing and confirm it was sent.

After 20 years with this thing - I can say the single most important thing I've found was to import all objects into a new database container whenever odd things started happening and decompile/recompile didn't work. I learned this technique from an actual Microsoft support person back in 1995...

Hi Coffee Bunny, the new link to download the code sample is posted in one of my responses in the above thread. It's here: http://www.informedcorp.com/Access-Development-developers-page.html Just scroll down to the section: Data Mover (Sample Database and Documentation): However, I'm not sure...

Hi TNB, I have absolutely no experience with SharePoint lists. This is something I cannot help you with - sorry about that!

Here's a simple modification of the above code to find (and go to) a record in a subform from a combo box that exists on a main form- the subform: Private Sub Combo54_AfterUpdate() On Error GoTo HandleErr Dim rs As Object Set rs = Me.Recordset.Clone 'this is the main form rs.FindFirst...

Hi, it's tough code - took me weeks to figure out. If we can figure out how to get a copy of the problem child, I might be able to help. If you'd like, just send me an email at support@informedcorp.com and I'll set up an account for you to upload the file. Did the original DB compile and run...

Great - let me know how it works out and/or if you run into any roadblocks. It's pretty complex code, or at least it was for me. I had it running, but slowly and Albert Kallal swooped in with a very elegant re-write of that critical core where it loops through the attachment field.

Hi again, the files are again available on our developer's page here: http://www.informedcorp.com/Access-Development-developers-page.html The link to this page has been moved to our Resources page.