|
Hi,
I'm trying to query 2 data (in forms of date) from 2 tables in MS Access. Then from those 2 date, I will compare and get the earliest date.
I tried the code below, but the problem is that if one of the query doesn't have the data, they couldn't make the comparison and could not display the other data. How can I fix this?
Thank you very much.
MyQuery7 = "SELECT Top 1 JOBACTIV.[STARTDATE] as strdt FROM [JOBACTIV] WHERE [MFRNAME] LIKE ('" & txtManufacturer.Text & "*') AND [SUPADDR3] LIKE ('" & txtAddress2.Text & "*') ORDER BY JOBACTIV.[STARTDATE]" <br />
<br />
MyQuery8 = "SELECT Top 1 JOBARC.[STARTDATE] as strdta FROM [JOBARC] WHERE [MFRNAME] LIKE ('" & txtManufacturer.Text & "*') AND [SUPADDR3] LIKE ('" & txtAddress2.Text & "*') ORDER BY JOBARC.[STARTDATE]" <br />
<br />
Set rs7 = db2.OpenRecordset(MyQuery7) <br />
Set rs8 = db2.OpenRecordset(MyQuery8) <br />
<br />
If rs8.Fields("strdta") < rs7.Fields("strdt") Then <br />
txtSupStartDate.Text = rs8.Fields("strdta") <br />
Else <br />
txtSupStartDate.Text = rs7.Fields("strdt") <br />
End If <br />
<br />
rs7.Close <br />
rs8.Close
|
|
|
|
|
Use UNION ALL to put the queries together, then sort by date so that you will get the earliest date first.
SELECT TOP 1 STARTDATE FROM JOBACTIV WHERE ...<br />
UNION ALL<br />
SELECT TOP 1 STARTDATE FROM JOBARC WHERE ...<br />
ORDER BY 1
---
b { font-weight: normal; }
|
|
|
|
|
I try this query, but I don't know how to see the result. How can I display the result to a textbox?
is it something like "txtdate.text = rs7.fields"?
Thanks.
MyQuery7 = "SELECT Top 1 JOBACTIV.[STARTDATE] FROM [JOBACTIV] WHERE [MFRNAME] LIKE ('" & txtManufacturer.Text & "*') AND [SUPADDR3] LIKE ('" & txtAddress2.Text & "*') UNION ALL SELECT Top 1 JOBARC.[STARTDATE] FROM [JOBARC] WHERE [MFRNAME] LIKE ('" & txtManufacturer.Text & "*') AND [SUPADDR3] LIKE ('" & txtAddress2.Text & "*') ORDER BY 1"
|
|
|
|
|
Just get the value like you did before. The name of the field is "STARTDATE".
---
b { font-weight: normal; }
|
|
|
|
|
thank you very much.
It works.
|
|
|
|
|
What are the dotNet equivalent functions for reading and writing registry values and keys?
Savesetting
GetSetting
GetAllSetting
tunde aransiola
|
|
|
|
|
As a start...
My.Computer.Registry object
|
|
|
|
|
I am using vb.net
How do the content of the textbox get highlighted when the textbox get focus? i have tried something like this
textbox.selstart=0
textbox.sellength=len(textbox.text)
but the textbox is not highlighted
tunde aransiola
|
|
|
|
|
Humm I tryed different methods including TextBox.SelectAll() and suprisingly non works.
Does anybody have any clue as to why is this so?
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
use the Sender.SelectAll property in the
Textbox_Enter event procedure
it will work
tunde aransiola
|
|
|
|
|
Set "HideSelection" property false. (VB.Net)
|
|
|
|
|
Hi Pals
I am working on vb.net 2005 windows forms project. In this I have placed "Windows Media Player" control n docked it to full and the next thing I did that I have placed a picture box control over that control n then issued a picture that is transparent but it didnt work as picture had the effect of blur n is not stable.
So next i made a new form n made it transparent with no border style n top most n then placed a picturebox control n docked it full n set its background color to the transparent color of the form. well it worked better than the prvs but still it is not stable n blurring.
I am using transparent PNG or GIF image file formats.
Please anyone help me in this regard.
thanks in advance.
MAP Tiger
|
|
|
|
|
MAP Tiger wrote: as picture had the effect of blur n is not stable.
What does this mean??? What are you trying to do with this?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I just want to place a logo on that video when it is playing.
MAP Tiger
|
|
|
|
|
You can't. The Media Player doesn't work with "overlays" like the one you'r trying to build. It'll play on top of everything you put over it on the same form. Why???
Basically, the video in the MediaPlayer is drawn and redrawn continuously, whereas your "overlay" is drawn only once. Your overlay will get overdrawn by the video by nearly every frame of video that the player shows.
There is no event to catch between video frames, so there's no way for you to tell when a frame of video is drawn so you can redraw your overlay. There are other reasons why this won't work, but this one is sufficient.
The only way to put in an overlay is to inject a custom filter into the video filter graph. The rub is that you can't use Media Player to show your video when building a custom graph. You have to show the video yourself using DirectShow in the DirectX SDK. Warning! Not for the faint of heart!
Basically, what your filter would be doing is generating a "live" uncompressed video feed that shows a static image of whatever you want to overlay ontop of the playing video.
No, I don't have any examples! I haven't touched DirectX development in quite a long time...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
-- modified at 11:46 Friday 17th March, 2006
|
|
|
|
|
hi,
how to search registry with a perticular value From command prompt.??
I want to make a batch file which will search and make a txt file with the value.
bye
Paritosh
|
|
|
|
|
You'll need some utility to do this for you. There is nothing that comes standard with Windows to export a single value from the registry from the command line.
What does this have to do with VB???
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi,
I added four buttons named first previous last next.
I am designing a simple data entry form using SqlConnection,
SqlDataReader programically.Can somebody send me code or any link.
|
|
|
|
|
take ptr as integer
now increment the pointer and decrement wherever necesary
for ex: you want to use next button
now write the code as ptr=ptr+1
ds.tables(0).rows(0)(ptr)
vijay kumar.n.s
|
|
|
|
|
for connectivity
take dataadapter ,write the query and then fill the database
ex:
dim cn as new sqlconnection(user id=" ";password=;database=pubs")
cn.open
da=new sqldataadapter("select * from tablename",cn)
da.fill(ds,"tablename")
vijay kumar n.s
|
|
|
|
|
Hi Vijay,
I am using SqlDataReader.Can you send me any link for the query?
Thanks
|
|
|
|
|
control array were present vb 6. how can they be used in vb.NET 2005.
they were very useful in vb 6.
e.g.
dim rs as recordset
...
dim i as integer
for i=0 to rs.recordcount-1
textbox(i).text=rs(i)
next
how can the above mentioned code can be manipulated in VB.NET. e.g. to display the values in the dataset.
|
|
|
|
|
You can create an array of controls - In fact there is already a collection of controls on the form called Controls
You can set up your own array of text boxes. For example:
Dim myTextBoxes As ArrayList
myTextBoxes = New ArrayList()
myTextBoxes.Add(someTextBox)
myTextBoxes.Add(someOtherTextBox)
' and so on You can then iterate over the array to get the textboxes.
ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
|
|
|
|
|
I have created a window service and in the solution i have created a config file. Now i am accessing some values from the config file in the service.
when i run the service through installutil i am not able to access config file values.
Is there any way i can run service in debug mode or can access config file.
Where will the config file be placed when i install the service on a system.
|
|
|
|
|
Make sure that the config file is in the same directory as your service .EXE. Also, make sure that the name is the same as your service .EXE name with a ".config" ending. For example, if your service filename is MyService.EXE, your config file must have the name MyService.EXE.config and reside in the same directory.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
