Results 1 to 4 of 4

Thread: [RESOLVED] MS Access 2007 VBA: Version Number is populating my Document ID Number (Code Error)

  1. Apr 13th, 2010, 11:06 PM #1
    colecole
    colecole is offline

    Thread Starter
    Member
    Join Date
    Apr 2010
    Posts
    34

    Resolved [RESOLVED] MS Access 2007 VBA: Version Number is populating my Document ID Number (Code Error)

    I am attaching a copy of my Document Control System I created. I have a 3 part Tracking number for each document. Document Type + Sequential Document Number + Version Number. There is also a Doc ID number which is an auto number primary key. For some reason my Version is mirroring my DocID on my frmMasterTabForm but it is correct in my Tracking No which is all 3 numbers combined into a single string. I think the code giving me trouble is located in the Module mdlDocUtilities but I can't figure this one out!!! If you get a second to take a peek at it, I uploaded it to the following link:

    http://www.4shared.com/file/UTtAWIAO...P_DCS_V16.html
    Reply With Quote Reply With Quote
  2. May 8th, 2010, 08:24 PM #2
    colecole
    colecole is offline

    Thread Starter
    Member
    Join Date
    Apr 2010
    Posts
    34

    Re: [RESOLVED] MS Access 2007 VBA: Version Number is populating my Document ID Numbe

    Thank you koolsid!!
    Reply With Quote Reply With Quote
  3. May 10th, 2010, 02:49 AM #3
    Siddharth Rout
    Siddharth Rout is offline
    Discovering Life Siddharth Rout's Avatar
    Join Date
    Feb 2005
    Location
    Mumbai, India
    Posts
    12,001

    Re: [RESOLVED] MS Access 2007 VBA: Version Number is populating my Document ID Numbe

    You have marked this resolved? Is your query solved?
    A good exercise for the Heart is to bend down and help another up...
    Please Mark your Thread "Resolved", if the query is solved

    MyGear:
    ★ CPU ★ Ryzen 5 5800X
    ★ GPU ★ NVIDIA GeForce RTX 3080 TI Founder Edition
    ★ RAM ★ G. Skill Trident Z RGB 32GB 3600MHz
    ★ MB ★ ASUS TUF GAMING X570 (WI-FI) ATX Gaming
    ★ Storage ★ SSD SB-ROCKET-1TB + SEAGATE 2TB Barracuda IHD
    ★ Cooling ★ NOCTUA NH-D15 CHROMAX BLACK 140mm + 10 of Noctua NF-F12 PWM
    ★ PSU ★ ANTEC HCG-1000-EXTREME 1000 Watt 80 Plus Gold Fully Modular PSU
    ★ Case ★ LIAN LI PC-O11 DYNAMIC XL ROG (BLACK) (G99.O11DXL-X)
    ★ Monitor ★ LG Ultragear 27" 240Hz Gaming Monitor
    ★ Keyboard ★ TVS Electronics Gold Keyboard
    ★ Mouse ★ Logitech G502 Hero
    Reply With Quote Reply With Quote
  4. May 10th, 2010, 06:59 AM #4
    colecole
    colecole is offline

    Thread Starter
    Member
    Join Date
    Apr 2010
    Posts
    34

    Re: [RESOLVED] MS Access 2007 VBA: Version Number is populating my Document ID Numbe

    Yes, this one is solved, the one I am still having problems with is filtering on this post:

    http://www.vbforums.com/showthread.php?t=614093
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width