cobom
Posts: 55
|
| Posted: 09/17/2004, 7:55 PM |
|
Not a critical request - just trying to get fancy  - in case anybody is interested.
We record static IP addresses in an Excel spreadsheet, we are now migrating to a class B subnetted class A scheme (10.171.0.0/16). I was asked to create a simple web based MS access dbase to record the new address / device mappings. (I know, very easy to create an IP field and be done with it). Basically the IP part will be 10.171.A.B, where A is device dependant and B is a range associated with a facility code.
e.g. 10.171.0.B = server static IP addresses
e.g. 10.171.0.1 - 10.171.0.63 = Facility range of available addresses for servers.
My idea is to log in by facility code (password HIDDEN and blank) which will provide the range, and select a device type that will provide the 3rd octect. For instance - I log in as PD, my range of selectable 4th octet addresses would be 0 - 63, I select the device type of printer, my 3rd octet would be 5, a default of 10.171. would be octet 1 and 2. Given that, can I submit the various pieces to a field (IP Address) that is in the form of 10.171.5.24 ????
OK, Most forum readers have hit the back button by now - but basically can I have 2 seperate entry fields in a form say: First Name and Last Name and have the input end up in a MS access field called user in the form of First.Last ??
_________________
cmckinney@searay.com
Will program for a Sea Ray 680 SS ;} |
 |
 |
ciberlin
Posts: 25
|
| Posted: 09/18/2004, 9:54 AM |
|
I need to do something similar but in MS SQL and ASP.
Maybe if someone answer your post I will be able to apply a similar technic to my project.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 09/18/2004, 1:29 PM |
|
You should be able to update control values in the Before Insert and/or Before Update events.
Abc.Value = Abc.Value & " - " & Def.Value
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
