I'm building an application that will need to run a specific functions at user defined times I need help with setting up the schedule part of the app. What I would ideally like to do is be able to set up an "event" which will occur at a specific time and date or at a specific time on specific days such as 9:00 Monday's Tuesday's Wednesday's and Saturday's.
View 2 Replies
On the SQL server I create a UDF. Let's name it fnCompanyDetails. It selects some information about a company from several joint tables.I then drag-and-drop this function in the new .dbml of my VB project. I want to use it with LINQ. Smth like this:
[Code]...
I have the following Query:
SELECT *
FROM tbl_Muffins
WHERE OvenLoadId IN (
SELECT OvenLoadId
[code]....
The idea of the query is that I want to specify an OrderId, and I want all Oven Loads that have items from that order in them, as well as ALL OTHER ITEMS in those loads, even though they could be from other orders.The query works as expected, but I'm not able to use it for my Crystal Report I've written it for.I have put this query into a User Defined Function, however I'm unable to use a call to that function as a table source in my Crystal Report. I am using Visual Studio 2003 (I know it is old, the client refuses to upgrade).
I need some help working out the logic when retrieving specific times from a userform I have created. In my userform, users are required to input a start and a end time in 24 hour time format. I am struggling to work out how best to analyze the selected times in order to multiply them by a set of rates, the rates are quite simple:
DayHours rate (day time is between 07:00 - 22:59)
NightHours rate (night time is between 23:00 - 06:59)
I cannot workout the logic to ascertain how many hours have been selected for which rate in an elegant manner, my best attempts so far are clunky and not quite there.
im going get ot the point i just wanta download a file from a url and have it zip to a specific user defined fileurl so here is my fake code please put in vb 2008 language. [code]
View 1 RepliesI once saw in an app a control that allowed the user to choose when they wanted the Timer running. It looked something like this: And when the squares are green, for example Tuesday 3:15 AM - 4:15 AM, the timer would run during that time period. I'm curious as to what control will allow me to do something similar?
View 3 RepliesI am trying to redirect command line output to a list box in a vba macro, and I've found some code that I think might point me in the right direction, but I keep on getting the same error. When I use this code [code]It gives me the error in the title and highlights the first declaration line.What does it take to define a new "process".
View 1 RepliesI have a countdown timer, I want to make a sound every two minutes at the moment i've got it set to if timer.txt = "00:08:00" minutes then play the sound but it stutters..
View 2 Replies[Code]...
a messagebox appear that show user-defined type not defined i had try another code but it still same error.. i'm using vb6
Can i use the timer when the user tries to log-in and the user entered a wrong password 3 times.i will give the user 5 mins to log-in again with the correct password and if the user enters the wrong pass. 3 times again i will give another 10mins also this is what i want when the user close the program the timer is also their and running that it will give the user the remaining tym on how much tym left 4 him to log-in again.Can i do this in vb.net??i dont know how 2 do this i dont have a clue if it is possible can someone give me a code??
View 9 RepliesVB2005 So I've created a pretty good and simple program to query a database and then export the data to a text file. i then transfer the file to a remote server via FTP. It all works really well and i have all the functionality setup with a button event. Now that its working what is the best way to have this program run automatically every day at 9AM and then shut down once its done. Im looking into a command line and also a service but wanted to see.
View 1 RepliesI'm converting a user generated list box to an array and then generating a user defined number of random strings and placing it in a textbox.The code I have works fine as it will generate the number of random strings the user wants, except sometimes a line is blank at the top of the list but is counted as a string.
View 4 Replies[Code].....
I got to work and only popup once instead of multiple times. But what Im wondering is It wont do that Unless I run the program AT the same time that is in the Cell. Im wondering if ma7ybe I should creat a new timer for each row then just have a timer constantly reading through the rows and to see what time is in the cell vs. System time or what.
I want to be able to check VB code for VB-specific items (for example, vbCrLf instead of ControlChars.CrLF). Is there anything (tool, VS setting or plug-in, etc.) that will check VB code for these?
View 2 RepliesIm trying to change specific lines of text in a listview at certain times of the day. Heres what im using atm , but im not sure how to change the text in the listview.
If Now.Month = 2 And Now.Day > 6 Then
ListView1.Items(0) = ("My text here !!")
End If
I'm learning to Program in school and i use vb.net 2003. Im trying to create a letter count application that displays the number of times a specific letter occurs in a word o phrase. (uppercase lowercase letters should not be counted) I started out by doing the folllowing:
[Code]...
What I am trying to do is have a class where the functions of the same name are both instance functions and shared functions.
Public Shared Function Get...(byval xx as xx)
and
Public Function Get...
The Public Function uses a Property xx created in the constructor, whereas the Shared Function has the parameters (byval xx as xx).
ok i will try to put this simple as i can. i am a doing computing coursework and as everyone can guess it is a pathetic programme i have to build. i need to work out the time difference between two times imputed by the user. i get high marks from making the programme user friendly so i want to use normal time (hh:mm). i am struggling to calculate the differences between the times.
i have tried to do it manually by working it out by sums and i have triedd to use date variables but vb 2008 just keeps saying i need to use timespan. i have never used system.timespan and have no idea how i am meant to use it.
I have created a User Defined Control that contains Add, Save, Edit, Search, Delete & Close Buttons. I added this User Defined Control in a New Form & How can I call Add, Save, EditSearch, Delete & Close Buttons of User Defined Controls from the New Form. What is the Code for calling a button of User Defined Controls from its Parent form?
View 2 Repliesexample of a user-defined exception in VB.Net. I already have two examples that I was able to find online, but other than that, I cannot think of any more. I need to find at least 5 to put in my notes, and then submit to my teacher.The two I have so far are: invalid login information (such as improper username or password), and expired credit card information on an online store.
View 3 RepliesI'm a new user of VB.Net. I do have doubt on accessing a user defined Function or Sub. In some place of program, I do see the term "Call" when using the Function/Sub. In some other place without "Call". But both works perfectly. May I know the difference between the two.
[Code]...
I apologize in advance about asking a newbie question. I am a less-than-intermediate programmer who has done most of his work in VB6, and now trying to wrap my mind around the new concepts of the NET languages.In VB 2010, I have a Structure called "Direction", with one data member -- an integer named "Value". It's supposed to represent a value of degrees from 0 to 359.
Public Structure Direction
Private d As Integer
[code].....
Is there a way to create a user-defined ImageList? I would like the user to be able to assign images to ImageList that would be stored for use in future sessions.
View 3 RepliesWell I had a thread going that branched out to this topic, so rather completely veering off the main topic there, I felt creating a new thread was adequate.So as the title says, I'm trying to create a user-defined type. It's not a simple type at that but a user here had showed me a way to fix all my problems. That was to create a type BigDecimal. Which my initial thought was to utilize the BigInteger type. Being that the Integer Part, and Fractional parts would be split off into two variables, both BigIntegers. Which would be combined at the end as a "decimal". However I have many many questions see that this is my first attempt at truly creating a type of my own. So as of right now I'm basically swinging in the dark here.
[Code]...
Im using a simple access database with only 2 tables and I creadted a form with a datagrid to show all data inside the tables, and now i want to create search buttons for each field of the table . like, "seach by Name", Seach by date" etc... i tried to use the simple code
Code:
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim cod As String
cod = InputBox("Type the Id to search: ", "Search By ID")
If cod <> " " Then
[code]....
My biggest problem now is that this code works very well to search by id (which is my table primary key), but now i want to search by other fields and this code only allows to search by primary key! Is there any way to use something similar to this code to search by other fields?
This program would allow users to click a button and display three different types of patterns (shown below). The user could also enter the number of rows they wanted to display and a character that they wanted to use for the pattern (*, &, etc).[code]...
View 3 RepliesI am having trouble with this code. Can someone tell me why the "Project Processing' section doesn't run at all? The 'Client Processing' section runs and executes find but it seems the 'Project Processing' section does not. very frustrated at the moment!
[Code]...
I have a database of 7 items that I want the user to be able to choose the order in which each is listed for use further along in programming. I'm thinking of using combboxes bound to the database. I found out that each combobox will have to have its own dataset otherwise they will all show whatever the current one that has focus changes to. Is there an easier way to be able to do this or is having 7 datasets bound to the comboboxes the best way? For this purpose I don't need all the contents listed in a DGV, only need the component name for now if this helps. Database programming is new to me and I'm a hobbyist programmer from VB6 days making the transition.
View 6 RepliesI have derived a textbox. This user control works fine everywhere. However, i have added a property in this as follow:
Public _propertyValue As Boolean
Public Overridable Property AllowNull() As Boolean
i'm having one user control in asp.net ,i just want to add the user control multiple times in a single web page in runtime in a separate table. How to do this?
View 3 Replies
