Type: Posts; User: DataMiser
Search took 0.11 seconds.
Actually that should be a sub rather than a function as it is not returning a value.
You also need to specify a argument in the sub definition if you want to pass it something
I assume that you mean two tables in a single database rather than two databases.
What do you mean when you say can't get it to work? You really should be descriptive here, are you getting errors?...
Insert adds a new row.
The FieldList does tell it which cells to place the data in but as above Insert creates a create row
You need to use an update query to change data in an...
Off the top of my head I would think this may be a case for a union
You could use that to execute two queries one to find the next highest value and the...
You are missing the field list
"Insert Into Table (FieldList) Values (ValueList)"
Don't try to add directly to the text property. Instead you should use a variable that is of type decimal and add to that then when you are done with the loop you place the value in your textbox.
show the actual code rather than sticking it in as a comment.
Your function is not defined properly you need to give it a return type
Public Function Calculate(Subtotal, decTAX_RATE) As...
A few things
1st off you are setting totalcost to the value returned from your function so it will never add the prices together it will instead hold the last price on the list.
Cost is defined as...
Download a copy of the express version and install it on your computer.
Look through the samples that are included.
Search for tutorials, samples online.
Read the documentation.
What is the error message?
If Max_Flange is a text field then the value needs to be surrounded by single quotes
Well assuming that the field is a numeric field you could use a simple query
select top 2 item,value where value >600 order by value
In this case it would return 1000 and 4000...
April 30th, 2015, 10:49 PM
well the program should start with the timer not enabled
You should enable the timer in the click event where you want the count down to begin
You should not be trying to do math on a string. You...
April 28th, 2015, 09:00 AM
I have no idea what you mean by that statement nor how it is in anyway related to the topic at hand.
Yes I have a lot of experience in the programming world and have in depth knowledge of VB Dos...
April 27th, 2015, 06:37 PM
hmmm 1 team member and no clear direction nor staff to do the work. Really does not sound like something that would be a wise investment.
April 24th, 2015, 10:30 PM
Actually you said you had written at least 1.2 the code but there is far less than 1/2 there.
You are prompting for input outside your loop so it will only ask for one value. If that value is 1-99...
April 24th, 2015, 03:32 PM
I haven't really looked at 2012 much. I see that option is available in my 2008 version but I have always used the default tabbed environment in VB.Net and like that just fine. In VB 5 and 6 I use...
April 24th, 2015, 03:26 PM
You don't seem to have did much so far, just collecting a few numbers. That part seems to have an issue in that it would not accept a score of 100 but it probably should. You should probably change...
April 21st, 2015, 11:15 AM
It would help to see some code, can't tell how you are determining the values in any of the fields so no idea why you are seeing something different than you expect.
Also would be good to know if...
April 21st, 2015, 08:43 AM
You have not shown any code that populates any of those variables other than strRequest so naturally they would be empty.
April 21st, 2015, 08:40 AM
Well you could use a timer and then in the timer code check the system time. Display your message when the time is what you want. You may also want to store the time that the message was last shown...
April 20th, 2015, 10:26 AM
I still not sure what you are actually asking. You really should provide a bit more detail. Sounds like you are using Excel [no idea which version] and you want to fire some code or a marco when the...
April 20th, 2015, 08:50 AM
Ok, I was not aware of that. I never use Forms 2.0 in my projects due to the fact that it is not one of the controls that is allowed to be redistributed.
You also were talking about clicking on a...
April 20th, 2015, 12:23 AM
Not sure what it is you are asking "multipage page tab"? Do you mean the worksheet tabs like sheet1 sheet2 sheet3 or ??
What does this have to do with VB?
April 17th, 2015, 04:17 PM
You really haven't given a clear picture of what you are trying to do. You say it should increment the range then you say A3 should be A4. Does that mean that you just want to do 3 and 4 and only on...
April 13th, 2015, 02:05 PM
Yes there is a progress bar control in VB.Net, it is in the toolbox with all the other controls.
You should replace and recode any controls that come up with that ax prefix if at all possible.
Click Here to Expand Forum to Full Width
This is a CodeGuru survey question.