Search results for query: *

This is the last of my finishing touches on this project!!! When the approve or revise button is clicked in the database, a file will move from one location to another, I want to stop this from happening if a file already exists but I do not get an error window to pop up to tell me a file...

Hello Everyone! How are you doing? I am very new at writing VBA code (first time ever!) Please be patient with me... I need to create a section in my Private Sub where my approve button will only work when the Revision for each drawing includes "Rev" This is what I have and it is not...

How do I write code to figure out how to recognize the characters before the "-" symbol. If my part is 301-001 I need to capture the 301 if the part is BBLNK-001 I need to capture BBLNK. This is what I have but it only works for the first three characters. Dim strDwgNumb As String Dim strRev...

I am very new at writing VBA code and I can't figure out why this is not working. When the approve button is clicked the revision letter that is in the main table needs to index by one. The revision letter must always be letters. I have a seperate table in Access called TblRev that references...

After I go through the entire alphabet for revisions we need to go to AA, AB, etc. I am having a heard writing code to go from Z to AA using the ASCII characters. Does anyone have any ideas how I can do this. Thank you!!!

I am very new to VBA... like never wrote code before new and I need some help. We have a huge database in access where we list our part numbers and the current revision and more information and this is what we want to be able to do When you click the approve button the current file will be...