Search results

Hello, I have a module which contains the following code: Public Function GenerateNumber(frm As Form) As Integer On Error GoTo GenerateNumber_Err frm.Unique_Number = Format(Nz(DMax("[DAA-MasterTable].Unique_Number", "DAA-MasterTable", "Standard_Number = '" & frm.Standard_Number & "'...

Here's What I Tried.... OK, here is what I placed in the module: Public Function GenerateNumber(frm As Form) As Integer frm.Unique_Number = Format(Nz(DMax("[DAA-MasterTable].Unique_Number", "DAA-MasterTable", "Standard_Number = '" & frm.Standard_Number & "' AND FY = '" & frm.FY & "'"), 0)...

OK...What about this??? OK, I'm about to test the code...But I want to call this code for use in more than form. So, would I really want to place the "frm.EntryForm" in the module?? In this case "EntryForm" is the form name...But if I wanted to use the same code, I can't use the code anymore...

Hello, I am trying to put functions into modules now. I have little experiece with this since I have always placed them directly in the forms. But I'm trying to get more organized, plus (and maybe more importantly) learn VBA more. I have this code in a module called: Number_System Code...

Pat, In this case how would it affect it if by using DMax instead of DLookup?? I'm just trying to understand it more. Thanks, ---roystreet

Great Job! Hello Pat, I Greatly appreciate your help!!! :) I just got the chance to look at it now (13:49 Alaskan Time - If that gives you any idea where I'm at!) Anyway, I have to say That's slick man!! I never use that word, but currently it looks like it's running smooth! The FY is set...

Hello, I have three fields that are: Standard_Number + FY + Unqiue_Number they make up a file number. These three fields are stored separately in the table as well are concatented on before update into a field called regional_number. My problem is that the user needs to be able to press a...