Search results

If you get a chance will you please look at my form on the previous post attachment. I do not have all txt fields that make up franken ID as part of the table such as Plat, Class, Year, Month, and Equip. There are only 2 fields ID_Asgn and ID_Asgn_Rng that are fields on the table. When you click...

Hi MarkK, I really appreciate your help. I thought if I uploaded my zipped database that would hopefully give you an idea of what I am doing. If you look at the form in the header section is where the user completes the fields (unbound) which will make up the Visual ID when they click on Save...

Hi Markk, I know this might be a stupid question, but what would the "Ordinal" be? And how do I get the sequential number to increment if they want to issue 50 at one time? Can I add the Sequential number to the Increment number and will they have to be Dim as strings? Are you saying that the...

Thank you jdraw. We always want to try to make our customers happy. This is just a issuing and tracking of equipment database. So 1 form and 1 table. Oh and they want to print labels. That will be all. I know the number is large but would like to store it so it will be recorded in table and...

At MarkK and jdraw, My customer is wanting to make a unique Visual ID number for issuing and tracking equipment. They want the number to consist of the first 2 combo boxes which are the platforms and classes, then year and month, ID Asgn, ID range (if applicable) and E (for Equipment). They want...

I have included the effort I have made with VBA so far. Keep in mind I said this is like new to me again. I did not use format on Year and Month in VBA cause I have formatted using exp builder on ID Year as Format(Date(),"YYYY") and on ID Month as Format(Date(),"MM"). Private Sub...

Thanks for the quick reply Uncle Gizmo. Im sorry for sounding like I was asking too many questions. Wanted to make sure I had enough information and maybe went a little far. I am wanting to create a Visual ID and it needs to be a combined with other data. If that makes sense. It will be made up...

Hello Friends. Please Help! I have been trying to solve how to combine several text fields and 3 combo fields on a form to store in one control field on a table. My 3 Combo boxes are: Plat Class Equip Text Boxes are: ID_Year ID_Month ID_Asgn ID_Asgn_Rng ID_Asgn_Increment Right now ID Year is...

Hi All, I have some experience with Access, little with macros but not a lot with VBA. I have found this site through Google. And I must say you guys are so awesome!! I had to become a member and learn from the Best. I have recently started creating more databases so I am in need of some...