|
Cool, thanks for this. I'll swat up on it tonight.
The reason I'm asking is I have been invited for a second interview at a place that currently has and needs to support this set up until a replacement can be sorted (which will be one of my main tasks if I get the job).
They currently have about 150 users on this. They have already upgraded the data storage to SQL, but are not quite ready with an updated front end.
Wish me luck...oooo, the Jedi's will feel this one....
|
|
|
|
|
I have not actually used Access for a number of years but certainly, we would create a front end containing forms and reports and a separate mdb containing all of the tables or links to SQL server (ahem; it was along time ago).
You could then place the front end on a client machine with the back end on a server and connect the users. Not ideal but it worked reasonably well.
It was a simple and quick way of getting an application out to a small set of users but I wouldn't do that now. Either a web or winforms front end looking at a sql server database (or whatever your preferred technologies are).Tychotics: take us back to the moon
"Life, for ever dying to be born afresh, for ever young and eager, will presently stand upon this earth as upon a footstool, and stretch out its realm amidst the stars."
H. G. Wells
|
|
|
|
|
Thanks for that. It's for a company that has this in place already, but will be building a new, improved system. Unfortunatly, this system will need maintaining until the new is ready.
It's for a second interview I have, so the new system and the maintainence of the old system would be my responsibility if I get it.
oooo, the Jedi's will feel this one....
|
|
|
|
|
Good luck.Tychotics: take us back to the moon
"Life, for ever dying to be born afresh, for ever young and eager, will presently stand upon this earth as upon a footstool, and stretch out its realm amidst the stars."
H. G. Wells
|
|
|
|
|
I have this block of code in the code behind of a VB.NET web site:
If (row.HasVersion(version)) Then retVal += String.Format( _
"Version: {0} Value: {1} <br />", _
version, row(columnName, version))
Else
retVal += String.Format( _
"Version: {0} does not exist.<br />", version)
End If
Visual studio keeps reporting that 'Else' must be preceded by a matching 'If' or 'Else If' and
'End If' must be preceded by a matching 'If', but THEY DO all match!
|
|
|
|
|
mnemonic69 wrote: If (row.HasVersion(version)) Then retVal += String.Format( _
Statements are separated by an NewLine in Visual Basic. Put an enter before the "then" keyword, and it should work I are Troll
|
|
|
|
|
Eddy Vluggen wrote: Put an enter before after the "then"
FTFY
|
|
|
|
|
Thanks Dave, problem sorted!
I feel a right dummy now lol, - I'm a C# programmer and I'm only having to learn this damn new language because my college degree course uses VB
|
|
|
|
|
I know the feeling!
My degree course is all Java.......i am forever getting VB and Java syntax mixed up! And we have to use NetBeans and i am so used to Visual Studio.
|
|
|
|
|
That was a quick fix! Well spotted I are Troll
|
|
|
|
|
Thankfully, this will no longer be a problem in VS2010.
|
|
|
|
|
I'm not sure where you get that idea. In VB a line in the form:
If condition Then statement
is a self-contained, single statement If that does not have a matching End If
I have not heard that this will change in VB2010. What I have heard is that in some cases, you will not need an _ to extend a statement to a second line, but this is kind of the reverse issue.
|
|
|
|
|
I screwed up. I was talking about the "_" character. I've always hated it.
And, if using properly formatted code, it'll be eliminated in most cases it's used now. Hell, after playing with the Beta's and RC, it's gone in about 99% of my use cases.
|
|
|
|
|
Its difficult to see the formatting you have used (stick the code in a pre block).
There should be nothing immediately after the Then on the same line. Move the retVal += onto a new line.
|
|
|
|
|
Hi,
How can Convert 0x10 to Integer.
Actually my mean is this what is the real value of 0x10 in integer(dacimal) format.And what is the formula behind it.
ThanksIf you can think then I Can.
modified on Wednesday, February 24, 2010 3:25 AM
|
|
|
|
|
The VB way to write hex numbers is to use the prefix "&H".
consider this example:
Dim hexNumber As String
Dim hexValue As Integer
hexNumber = "&H10"
hexValue = Microsoft.VisualBasic.Conversion.Int(hexNumber)
MessageBox.Show(hexValue)
|
|
|
|
|
You just need to use the Convert class. i.e txtResult.Text = Convert.ToDecimal("0x10", 16) . The firat parameter is your Hex figure as a string, and the second parameter is the base to whch you want to convert from(can only be 2,8,10,16). Convert also has different functions to convert to int16, int32, short, long etc. Just type Convert. and intellisense will give you all the options.
|
|
|
|
|
please could you explain more? I can´t get your method to work
|
|
|
|
|
My apologies, Convert only converts from one base to another as an integer i.e. the ToInt16, ToInt32 or ToByte Functions have the fromBase Overload.
|
|
|
|
|
|
Each digit, counting from right to left, is a multiple of 16 to the power of that digit's position. So counting digits of the number 0x1234 as position 3210 for example we have
1 * 16^3 + 2 * 16^2 + 3 * 16^1 + 4 * 16^0 or
1 * 4096 + 2 * 256 + 3 * 16 + 4 * 1 etc
and your value 0x10 = 1 * 16^1 + 0 * 16^0 = 1 * 16 + 0 = 16txtspeak is the realm of 9 year old children, not developers. Christian Graus
|
|
|
|
|
Thank u every body. If you can think then I Can.
|
|
|
|
|
If you remove the "0x" from the front of your string you can then use Int32 to parse it to an integer:
Dim str1 = "0x10"
Dim str2 = str1.Substring(2)
Dim i = Int32.Parse(str2, Globalization.NumberStyles.AllowHexSpecifier)
MsgBox("i = " & i)
Shows i = 16.
|
|
|
|
|
Hi,
So I have a column of cells that are the combination of a other cells in the row and a result of a few "if functions." The value comes out exactly as planned however in order for the data to be sent to the DDE server I need to press F2, go the beginning of the cell to insert an "=" sign and then press enter. I would like a macro to do what I just mentioned and then go down to the cell in the column. I used to write code using C++, but I'm a little rusty and unfamiliar with VB. Below is the formula and then the result of the cell. Any information or suggestions would be greatly appreciated!
=(IF(G10>0,"=ANVDdeSrv|"&B10&"!SendOrder"&L10&"NYSE_"&ABS(G10)&"_1_100_"&M10,IF(G10<0,"=ANVDdeSrv|"&B10&"!SendOrder"&L10&"NYSE_"&ABS(G10)&"_1_100_"&N10,)))
ANVDdeSrv|AMD!SendOrder_Sell_NYSE_300_1_100_3.3
|
|
|
|
|
Turn on macro recording, perform the actions, turn off macro recording and Robert is your father's brother.
|
|
|
|