|
|
I have a datatable filled with data.
How can I query a cell in the table to see if it has changed since the last acceptchanges?
I'm familar with the column changing event. I want something similar to this where i can query the original value and proposed value etc. But I want to just make reference to a cell in the table and test it at my own liesure.
I can do this with a row by typing the following:
if drw.RowState = DataRowState.Unchanged then
' Do something...
endif
Is there any way to test the following for a change?
dataset.tables(0).rows(0).item <--has changes
And if so is it possible to test the current value against the oginal value in the cell?
I want to check if a certain cell value has changed and action the result.
Thanks Glenn
|
|
|
|
|
Do you know how I can capture the filename of an object (file) being dropped into an Access table's OLE object container?
Here is what I have:
1) Access 2000 with a table (fields: RecId, Filename, Blob)
2) the field Blob is an OLE object
What I want:
A) drag a file (from Windows Explore listing) and drop into OLE object - DONE!
B) programmatically record the filename of the source (file being drag-dropped)
What callback in VBA code should I react upon (mouse up? on update?)
BONUS!
I have a form tied to my blob table. When I drop into the OLE container, it shows the file as it would appear in its "Native Application" - would prefer simple ICON or nothing.
Thanks for the help.
Johnny
|
|
|
|
|
I was wondering if and how one would go about reading the information within a textbox seperated by multiple delimiter's
such as \ and \\ and \\\ to create a Folder structure. one \ is the base folder two \\ would be asub folder and three\\\ would be a folder within a subfolder. Thanks for any help as i have no clue.
eg. lets say we want to create a file structure "c:\folder\subfolder\\subfolder\\subsubfolder\\\
this would give you a regular folder and two seperate subfolders the second of wich has a subsubfolder like this:
folder
|
/ \
subfolder subfolder
\
Subsubfolder
P.S. Thanks for any help.
Late
Puppetgrimm1
Pupetgrimm1@aol.com
From: Las Vegas , NV
|
|
|
|
|
I’m trying to access one row in a table based upon its int value held locally in a variable. (I increment the 'count' variable in the application.) As you can see below, 'count' is the local variable in the application. Can this be done or is there another way?
-Shannon
If count < iResultQuery Then
myConn_.CommandText = "SELECT WorkInstructions.InstructionText FROM WorkInstructions
WHERE WorkInstructions.StepNo = count"
end if
|
|
|
|
|
spettiford wrote:
If count < iResultQuery Then
myConn_.CommandText = "SELECT WorkInstructions.InstructionText FROM WorkInstructions
WHERE WorkInstructions.StepNo = count"
end if
Should be:
If count < iResultQuery Then<br />
myConn_.CommandText = "SELECT WorkInstructions.InstructionText FROM WorkInstructions<br />
WHERE WorkInstructions.StepNo =" & count<br />
end if
hope that helps
|
|
|
|
|
THANK YOU!!! I knew there was a way, but just didn't get the syntax correct. It works great and you saved me.
|
|
|
|
|
your welcome
and for string variables:
myConn_.CommandText = "SELECT BLAH FROM BLAH_TABLE_NAME WHERE BLAH_TABLE_NAME.BLAHCOLUMN_NAME (OPERATOR)'" & report_type & "'"<br />
|
|
|
|
|
|
I have created a class library in which I have created customised textbox columnstyle.
When I click on the cell of this datagrid,actual text box is made visible(normaly text is painted in the cell using drawstring method of in overriden paint method.) & we can edit the text in it. but this text box is not handling arrow keys! The focus is lost from the text box if we click arrow keys. because data grid was handling these events. I checked these events in datagrids overriden method 'IsInpunkey' method & tried to return true whih will avoid further processing of key by base class method but it didn;t worked. I also tried to handle this through textbox's IsInputKey method, but it failed there also.
Can any body tell me why is this hapening & how can I make arrow keys work in my text box.
Thanks.
|
|
|
|
|
I have been attempting to find my own method for controlling the "boundaries" of child windows within the main parent. So far I have come up with:
Private Sub childform1_LocationChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.LocationChanged<br />
If childform1.Location.X < 144 Then<br />
' childform1.Visible = False<br />
'cannot use the visible= False as this cause the application to crash.<br />
childform1.Location = New System.Drawing.Point(144, childform1.Location.Y)<br />
'childform1.Visible = True<br />
End If<br />
If childform1.Location.X > 753 Then<br />
'childform1.Visible = False<br />
childform1.Location = New System.Drawing.Point(144, childform1.Location.Y)<br />
'childform1.Visible = True<br />
End If<br />
If childform1.Location.Y > 442 Then<br />
'childform1.Visible = False<br />
childform1.Location = New System.Drawing.Point(childform1.Location.X, 0)<br />
'childform1.Visible = True<br />
End If<br />
'for the main form<br />
F1.AutoScroll = False<br />
'F1.Refresh()<br />
End Sub
The above code works fine, does what I need it to, but there is a large amount of flickering going on when the form is moved. I tried to prevent this by making the form invisible when the relocation was going on but the application crashed as a result.
Does anyone have an idea I might try to prevent the flickering?
|
|
|
|
|
How Can I Create Query Builder Using VB By DAO Connection
S.venkatesh
|
|
|
|
|
hello,
i start vb.net programming now.
i dont any about coding,link database with access database and link between forms.please help me.
i need them.
thanks
best regaurd
k.pakzamir
|
|
|
|
|
I've recently a connection problem between vb.net and sql server and a guy have give a link to me!
I hope it's what you want and search !
ConnectionSting : http://www.connectionstrings.com
|
|
|
|
|
I've recently a connection problem between vb.net and sql server and a guy have give a link to me!
I hope it's what you want and search !
ConnectionSting : http://www.connectionstrings.com
Excuse, but I think i've post the same message with a anonymous state
SeLoRBIS
|
|
|
|
|
hi friends,
Third time i am asking about dataset when i am having table with more than
five lacs of record i want to show all record to user. that time dataset stuck(hanged) what to do?
|
|
|
|
|
I have created a package using VB .Net running under the 1.1 Framework
It has a series of buttons along the bottom of the screen.
When installed on PCs in the UK it works fine.
When installed on PCs in Germany, the users cannot see the buttons ( except for the one on the far left ). The buttons must exist, because they still function when accessed via the Tab + Enter keys.
Can anyone shed light on why they cannot see them, and how to solve the problem ?
A typical machine in th UK is Panasonic CF-29
The machine in Germany is IBM Net Vista
|
|
|
|
|
hi...
I'm manipulating on the Crytal Report. The problem is that I have one printer having many TRAYs on the printer, and I want to choose the default TRAYs when user prints the report. Besides, it doesn't allow users to select the printer. Tell me how to do that, please. Thanks
|
|
|
|
|
Hi everybody,
I want to ask a question about MshflexGrid Control ,
I have a grid in myProject that is writing with VB6 ,I update this control with timer control at 2 second from DataBase.
I want to control Grid 's Click event and When I click a Row for example row3 ıt catch this event ,but I try and try then It can create wrong result that catch LastRow of MyMshFlexGrid ,For example ,I click 3.row It display SelectedRow=39 (LastRow of myGrid)
How can I solve this problem?
I hope ,You could understand !
Thanks for your interest
|
|
|
|
|
Hi
Nice Day
Use This To Get The Row Ur Select By Click
GridName.get_TextMatrix(GridName.Row,<column u="" want="" from="" this="" row="">)
Waiting ur Reply
Best Regrad
Scorpion
|
|
|
|
|
Hi, I am facing some proplem to develop an application in VB6.0. My database is SQL Server. The main problem is I need to insert the data in a particular table using SQL DMO Objecs.
I have One database called dexpro. in this I had a table called Employee.
In another database called Mydata. in this I had a table called Employee.
So when I enter a Row in a Dexpro's Employee table that row need to check
in Mydata's Employees table. When That particular row is not exist in Mydata's Employees table, then that particular row need to add Mydata's table.
when I delete a row from Dexpro's Employee table that Particular row need to delete from Mydata's Employees table.
This is nothing but called Replication. This operations need to perform through using SQL DMO Objects.
Please send solution to me
|
|
|
|
|
hello everybody,
anyone of you can tell me how to check server hard disk space using
vb.net. Is it possible or not? If yes then explain me.
|
|
|
|
|
Yes, it's possible. But how you go about it depends entirely upon the type of werver that you're talking about. Unix/Linux, NetWare, Windows, ...???
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
i am talking about window o/s
|
|
|
|
|
Hi
I have this problem of writing to a text file everyday at a particular time say 10 AM in the morning automatically.I am being told that using windows service is a solution.I however dont know how to go about doing this
faraz
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
