|
I having problem when compare the date with the SQL, wats wrong with my code?
There are problem when i click the button on the function
"No value given for one or more required parameters"
It show the problem was in "Adodc1.Referesh"
but i not sure wats problem with it?anyone can help?
Dim today As Date
today = Now
sql = "select * from CO where [WarrantyValid]>today"
Adodc1.RecordSource = sql
Adodc1.Refresh
DataGrid1.Visible = True
|
|
|
|
|
campbells wrote: sql = "select * from CO where [WarrantyValid]>today"
Should this not be:
sql = "select * from CO where [WarrantyValid]>GetDate()"
|
|
|
|
|
i have try is but it said undefined function 'GetDate' in expression...
|
|
|
|
|
I think it should be:
sql = "select * from CO where [WarrantyValid]>" & GetDate()
|
|
|
|
|
or
sql = "select * from CO where [WarrantyValid]>" & today
|
|
|
|
|
Hi, I am working a project using visual basic studio 2005 as an interface design, microsoft sql 2005 as data store and crystal report for report engine. I am working with my local language by using unicode. However, the display on the interface itself it looks perfect however, when we view it with crystal report, it does not display properly at all.
For your understanding, Cambodia spelling is much difference from English. It has consonant with vowel and extended vowel which can be on the left, right, top, bottom, upper top, and lower bottom of consonant. The problems, is with the display of vowel, it seperated out.
Anyone outthere can solve this issue please help?
Regards,
Sithy
Sithy
|
|
|
|
|
Hi:
There is one parent form and several form mdichildren. In each child form there may be one to many controls. Information in one control is associated with other controls which may be in the same child form or in different forms.
The question is how to notify other controls if one control content is changed. What design policy (e.g. using design patterns such as Observer,or others) is appropriate ? Is there any sample I can refer to? Thanks.
David
abc
|
|
|
|
|
Your requirement is little unique so the solution would be unique too. I have one suggestion there might be many from others. well do the following
1. Build One Function on every Form with these parameters
public Function ControlAlert(FormName,Controlname,Value,any other parameter if required)
''' do here what you want to do if any other control has changed value
end function
2. on change of all the controls lying on all the forms. call one function which you will be created in your Global Module say
public sub ControlValuechanged(FormName,ControlName,ControlText)
' Over here you will get the reference of all the forms by using MDIForm Child loop and will pass the parameters to those forms in function
ControlAlert which you created on Step 1 like this
Dim frm As Object
For Each frm In MDIMain.MdiChildren
frm.ControlAlert(parameters)
Next
end sub
Rizwan Bashir
|
|
|
|
|
Your solution sounds viable. Yet I learned there are some design policies/patterns that can provide more elegant way to deal with that issue. I'll use your solution and explore design patterns as well.
Any advice besides the solution above is appreciated.
David
abc
|
|
|
|
|
i have a problem on merging 2 lists with 5 inputs on each list. the five inputs were already sorted and i'm trying to have a function to merge it. this is my defining function:
void merge(numA[],numB[],numAB[])
{
}
how can i merge the inputs in numA[] and numB[] and put them in the array of numAB[]?
|
|
|
|
|
Have a look at the Array.CopyTo method. If the final array also needs to be sorted than just make another call to Array.Sort to sort it afterwards.
|
|
|
|
|
Hi. I have a general question about custom controls. I want to make a control on a windows form that has a nonrectangular shape and the control itself is divided into several nonrectangular shapes. I need to divide the control because i want the different areas in it to have different properties.
I'd be very grateful if someone gives me a general advice on how to achieve that. I've already tried with transparent labels over a picture representing the control, but it is not nearly as good as i need it to be.
Thank you in advance.
|
|
|
|
|
A possible cheat/workaround...
Depending on how graphic you want your controls to be here's an idea (untested - something I've thought of doing but never got around to).
1. Draw your custom control in Flash (I choose Flash coz it's simple and powerful),
2. Add a Shockwave Flash object to your toolbox.
3. Create a new custom control, adding the Flash object to it.
4. Give the control applicable events like onClick, onMouseEnter/Leave, etc.
5. Use GDI+ to cut out the unwanted square bits around your control (using GDI+ available here[^]).
6. Build and test.
As mentioned earlier, I have yet to try this myself so I'm not completely sure that it'll work tho I don't see why it shouldn't given a little elbow grease. The choice of doing it this way is yours, you take my advice at your own peril 
Good luck, if you get it to work please let me know - i'd be very interested to see.
|
|
|
|
|
Thank you for the reply. I am not used to using any of the macromedia products but here's a good reason to try them out As soon as I finish the control i will write you back.
Thanks once again.
|
|
|
|
|
Hello,
I'we been looking for tutorials about how to create buttons that reacts mouse events in Direct3D application. So basicly I just want to create a normal button but later on I need to make different shaped buttons, like triangle and round.
I understand the basic consept behind the buttons, but I can't figure out how to calculate the coordinates when the mouse is over buttonarea. Basicly only thing that should be somehow calculated is that where are the coordinates that are on button are. I was thinking to draw the buttons with vertixes, but the buttons are invisible for the user, because the buttons only work as a hit points and they register that if user presses the mousebutton over them.
Any idea where I could find tutorials for these? 
|
|
|
|
|
How can I extract an embedded or attached file (say MSWORD, MSEXCEL, or PDF) inside PDF and save it programmatically, using VB.NET. I can see that you can walk through different annotations in a page but how can you determine the presence of attached file and open it and saving it programmatically.
any suggestions????
|
|
|
|
|
add handler to this procedure at the end like
Private Sub Combo1_Change() handles combo1.change
Rizwan Bashir
|
|
|
|
|
' this one is the normal generated code when you double click on the combo in design mode. and put your calculation in here
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
End Sub
Rizwan Bashir
|
|
|
|
|
you probably need to put that code in the Click event instead of the Change event.
hth
|
|
|
|
|
Hi.
Im trying desperatly to print the contents from a mdi children form, which has the look of an excel worksheet. I have a subroutine that via gdi+ creates a bitmap om the viewable part of the form. But I need to print even the part that you have to scroll to see.
It seems that is impossible to use BitBlt for this purpose, since BitBlt only can draw the viewable part. Right? If so, what should I then do? It must be possible to print? Im quite frustrated here, since it must be possible to print event the parts that aren´t in view.
If BitBlt doesnt work, can I put each control(textboxes, panels, etc) on the printdocument manually?
|
|
|
|
|
Form.PrintForm doesnt work?
|
|
|
|
|
Take a look at the message I posted in the SQL forum. Please be kind and do not cross post 
|
|
|
|
|
Now im a bit confused here. SQL-forum?
|
|
|
|
|
I need to programmatically search through email messages for a set of users on our Exchange server and make a report of and forward messages that have not been opened. Does the Exchange SDK allow this kind of programmatic access or is there a better solution? All the information I can find on the SDK is very vague.
Thanks.
-- modified at 9:35 Friday 21st July, 2006
|
|
|
|
|
Hello All,
I am developing an application using VB 2005 that will run continuously in the background on a users workstation. This application will automatically transfer files from the local machine to a remote server and vise versa. It checks for the files on a timed interval. I have two problems with this application that I am having trouble figuring out:
The first problem is that the cmd.exe shell pops up on the screen every time it maps the drive. The application needs to be completely 'invisible' to the user. I cannot have something popping up every several minutes while they are trying to work. 
The second issue is that I do not want to let a continuous connection to the remote server so I have mapped a network drive to the remote server using process.start. I have provided administrative credentials when creating the drive. Local users do not have permission to connect to the remote server. Also, I only want to create the drive when necessary, and then close it when the current process is finished with it.
The drive mapping shows in My Computer when I check for it. However, when the code tries to access the drive to transfer the files, I get an error and the program shuts down. 
The error is: system.unauthorizedaccess, eventtype: clr20r3.
I am assuming this has something to do with the user credentials, so I tried creating the mapped drive using the same command lines in my code using the command prompt. I was able to successfully create the mapped drive and access it under the local user account 
Any ideas/help would greatly be appreciated.
This is the section of code that I am using to create the drive:
Try
srvConn = New System.Diagnostics.Process
srvConn.StartInfo.UseShellExecute = False
srvConn.StartInfo.RedirectStandardError = True
srvConn.StartInfo.RedirectStandardOutput = True
srvConn.StartInfo.FileName = ("net.exe")
srvConn.StartInfo.Arguments = "use z: \\server\share" & " " & My.Settings.rbsSrvPwd & "/user:" & My.Settings.rbsSrvUsr
srvConn.Start()
srvConn.WaitForExit()
Catch ex As Microsoft.VisualBasic.FileIO.MalformedLineException
Microsoft.VisualBasic.FileIO.FileSystem.WriteAllText(My.Settings.logPoll, "Error: " & ex.Message & " occurred in rbsSrvConnection:rbsConnOpen" & vbCrLf, True)
End Try
mzak0420
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
