Need Help Creating a ID Number

  • Thread starter Thread starter mattc66 via AccessMonster.com
  • Start date Start date
Matt, do you want the FileLocation to show on frmQuotes?
I assume you want a button or method to view the file?
The folder is always the same? W:\ROOMS Daily Drawings\DWF\
You want this automatically updated when the rev is created in the code?
Do you want the code to check for the .dwf fle before it creates the
hyperlink?
If not, what should happen when the user calls the hyperlink and it's not
there?

UpRider

mattc66 via AccessMonster.com said:
Hi UpRider,

This is working great. I would like to incorporate one more option.

I would like to add the following HyperLink. I created a field in the
tblDrawingNumbers called FileLocation. It's a HyperLink file type. Could
you
help me incorporate this into the SQL Statement.

"W:\ROOMS Daily Drawings\DWF\" & [FKQuoteID] & [Revision]&".dwf"

Thanks Matt
Matt change the function to this:
Sub subUpdateMainform()
Dim strDwgLetterRev As String
CurrentDrawingNum = vbNullString
If Not Me.NewRecord Then
strDwgLetterRev = Nz(DMax("revision", "tblDrawingNumbers", _
"FKQuoteID = " & [QuoteID]))
CurrentDrawingNum = Format(QuoteID, "0000") + strDwgLetterRev
End If
End Sub

The drawing mumber will still display on the main form but without the rev
letter. Is that OK?

UpRider
Hi UpRider,
Click to expand...
[quoted text clipped - 15 lines]
Thanks again for all your help.
Click to expand...
Click to expand...

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via AccessMonster.com
Click to expand...
 
Hi UpRider,

I was thinking it would show as a Hyperlink in the subform on each line for
each revision.

The Folder name is always the same. The file name is the FXQuoteID + Revision
+.dwf
It would be cool if the code checked for the DWF file before it created it,
however the drawing may take a few days to be available from the time the
Drawing# is created and the actual drawing is done. The other option would be
to just give the user a message is the drawing is not found.
Matt, do you want the FileLocation to show on frmQuotes?
I assume you want a button or method to view the file?
The folder is always the same? W:\ROOMS Daily Drawings\DWF\
You want this automatically updated when the rev is created in the code?
Do you want the code to check for the .dwf fle before it creates the
hyperlink?
If not, what should happen when the user calls the hyperlink and it's not
there?

UpRider
Hi UpRider,
Click to expand...
[quoted text clipped - 30 lines]
Click to expand...
 
Matt, try this http://www.dbtc.org/zipmdb/drawingnumbers.zip
You have to double-click on the hyperlink. It's too easy to just click in
the field and annoyingly call up the application by accident.

UpRider

mattc66 via AccessMonster.com said:
Hi UpRider,

I was thinking it would show as a Hyperlink in the subform on each line
for
each revision.

The Folder name is always the same. The file name is the FXQuoteID +
Revision
+.dwf
It would be cool if the code checked for the DWF file before it created
it,
however the drawing may take a few days to be available from the time the
Drawing# is created and the actual drawing is done. The other option would
be
to just give the user a message is the drawing is not found.
Matt, do you want the FileLocation to show on frmQuotes?
I assume you want a button or method to view the file?
The folder is always the same? W:\ROOMS Daily Drawings\DWF\
You want this automatically updated when the rev is created in the code?
Do you want the code to check for the .dwf fle before it creates the
hyperlink?
If not, what should happen when the user calls the hyperlink and it's not
there?

UpRider
Hi UpRider,
Click to expand...
[quoted text clipped - 30 lines]
Thanks again for all your help.
Click to expand...
Click to expand...

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via AccessMonster.com
Click to expand...
 
Matt, happy to help. I hope it serves well in your overall grand design.

UpRider

mattc66 via AccessMonster.com said:
Thank you again - This works great!
Matt, try this http://www.dbtc.org/zipmdb/drawingnumbers.zip
You have to double-click on the hyperlink. It's too easy to just click in
the field and annoyingly call up the application by accident.

UpRider
Hi UpRider,
Click to expand...
[quoted text clipped - 28 lines]
Thanks again for all your help.
Click to expand...
Click to expand...

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via AccessMonster.com
Click to expand...
 
Back
Top