Recent content by mcescher

Thank you both. This specific example was just a single record, but I get pulling all the records at once. Just didn't want to pull the entire table when I just need a single record. Oh the trials of renovating old code... hehehe Thanks to Paul also for answering the EOF/RecordCount question.

Working on updating some old code, and I've come across some code that I'm wondering if it would be better to update, or does it matter? I need to grab some information from a table, so the first example (old) set the recordset to the table and then uses the "FindFirst" method with some...

OK, cool, I had only seen the information about the add-in he was selling. I'll check it out, thanks a bunch!

That's a nice tool, but I'd like to create something like that. Is there any documentation on how to make one?

Hey All, Wondering if anyone has written a VBE plugin for the editor. I'm not looking for an Access plugin, but a tool that helps on the code editor side. I've tried searching, but all my Google searches have yielded are instructions for Access plugins. I've got VS 15, and a few ideas of what...

Yup, know all that. This is a disconnected recordset, and not storing the values. Just a simple calculator for the user to know how much material to order. They take that and make choices in another form. Thanks, Chris

Found it... Sometimes it's the silly mistakes. While I was clicking in the Properties window in Access to add the "_AfterUpdate" link, I accidentally hit Ctrl V in that box. So instead of "[Event Procedure]" It said "Me.Refresh[Event Procedure]" And Access didn't like that...

Hi All, Kind of a strange question. I have a form with 10 text boxes that the user will fill in and the last two will do calculations based on the information that they entered. So, I've added code like this for each of the entry text boxes Private Sub txtField1_AfterUpdate() Me.Refresh...

I was mistaken on my note about that library. Should be 1D and 2D, setting up beam material and how to cut that, and also flat sheet material. Note, it even allows you to set the saw kerf and uses that in the calculation.

Had a similar project, and found a DLL online to do all the heavy lifting CutGLib.dll https://www.optimalon.com/cutting_optimization_library.htm There is some cost to it, but I don't think it was too expensive. Will do both 2D and 3D optimization.

UPDATE I noticed that clicking around on the form on other controls would make the tabs visible again. SO, in the AfterUpdate event of the tab control, set the focus to another text box and then set it back to my tab control. Not the most elegant solution, and certainly only treating the...

No code behind, already checked for that in the entire db.

Hi All, Can't find a solution on Google or here, so hoping someone smarter than I can produce the answer.:D Tab control on a form has two tabs, everything is happy. Added a third tab in the middle of the current two, and it is hiding all the tabs if I click on it first. In the attached...

Private Sub Part_Number_AfterUpdate() If Account_Ref = "ARB20" Then Part_Number_2.Visible = MsgBox("Do you need to enter another part number?", vbYesNo, "Another Part Number?") = vbNo End If End Sub Private Sub Part_Number_2_AfterUpdate() If Account_Ref = "ARB20" Then...

Here is a list of supported HTML tags: <div>,<font>,<strong>,<em>,<u>,<ol>,<ul>,<li>,<blockquote> And, styles/attributes per tag: <font>: face, size, color, style(with BACKGROUND-COLOR only) <div>: align, dir