473,386 Members | 1,699 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

new to programming in VB; help!!!!

3
Hi all,

I am a total newbie to programming and this is my first posting on a forum, so forgive me if I break any unwritten etiquette about posting. To get to the point I've been using VBA for access to create a tool that will resolve an IP address range using a single network address and the network bit and also convert the results to Hex. I have been able to use the network address / bit to calculate the Subnet mask as well as using the hex function to convert the network address to hex (altough I have identified a bug with this but more of tht later); the problem I have is creating the code to run the comparison between the 0's and the 1's of the network address and subnet mask to derive the start and end ip addresses, I can do this in excel with vlookup, search and len functions but I am struggling trying to translate this to code, and therefore I am in need of any suggestions from more experienced programmers to help me along. Thanks for your assistance
Jun 13 '07 #1
3 1830
r035198x
13,262 8TB
Hi all,

I am a total newbie to programming and this is my first posting on a forum, so forgive me if I break any unwritten etiquette about posting. To get to the point I've been using VBA for access to create a tool that will resolve an IP address range using a single network address and the network bit and also convert the results to Hex. I have been able to use the network address / bit to calculate the Subnet mask as well as using the hex function to convert the network address to hex (altough I have identified a bug with this but more of tht later); the problem I have is creating the code to run the comparison between the 0's and the 1's of the network address and subnet mask to derive the start and end ip addresses, I can do this in excel with vlookup, search and len functions but I am struggling trying to translate this to code, and therefore I am in need of any suggestions from more experienced programmers to help me along. Thanks for your assistance
Well you post that in the wrong forum!
I've moved it to the access forum for now.
Jun 13 '07 #2
kepston
97 Expert
If your address values are numbers, you can use the logical operators - And, Or, Xor etc.
To convert a string to a number use Val() or CDbl()
Jun 13 '07 #3
catzid
3
Thanx for the tips. I will have a go and let you know how I get on.
Jun 15 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Jst | last post by:
Do you need programming help? If so, pop along to our new forum and post your questions to our qualified developers. http://forum.elistarcreations.com
10
by: Rohit | last post by:
I need some ideas on how to write a program that could -- Read an MS Access database and grab information say Vehicle year, vehicle make -- Make a call to a website and enter the information...
3
by: Spartan815 | last post by:
I am writing a program that does a command line search for a specified file, or to match a pattern (i.e. search for *.h). Once it finds the file(s) it has to output absolute pathname, size, owner...
4
by: Scott C. Reynolds | last post by:
I need to do something in an asp.net application to get shipping costs from UPS. a)does anyone have any C# code for this? That would be immensely helpful as then I could examine it and apply it...
0
by: nimisha | last post by:
I'm only new to learning shell programming and we have this current task to create a .sh program (basic shell only) that can output a web access statistics report of accesses for each month in a year...
3
by: lavender | last post by:
C programmingBelow is my question and the code, but I donno the code is correct or not, can anyone please help me to correct it if I wrong. Write a program that will swap two values in an array....
4
by: crookj | last post by:
I was wondering how i can program in pcl to shift my text 10mm to the right and 6mm up. This would include all text. I print out a form and everything is shifted down and to the right. was...
1
by: alibaaba | last post by:
HI All, i am a 4th year business student and i took web design online course for fun however i did not see that last 2 chapters were python programming.This has no relevance to my major nor does...
1
by: Dennis | last post by:
HI All, i am a 4th year business student and i took web design online course for fun however i did not see that last 2 chapters were python programming.This has no relevance to my major nor does...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.