Need Help Creating a ID Number

[UpRider]

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,

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,

[quoted text clipped - 15 lines]

Thanks again for all your help.

 

[mattc66 via AccessMonster.com]

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,

[quoted text clipped - 30 lines]

 

[UpRider]

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,

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,

[quoted text clipped - 30 lines]

Thanks again for all your help.

 

[mattc66 via AccessMonster.com]

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,

[quoted text clipped - 28 lines]

 

[UpRider]

Matt, happy to help. I hope it serves well in your overall grand design.

UpRider

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,

[quoted text clipped - 28 lines]

Thanks again for all your help.