|
Hi,
I want to change the "Validation Rule" property of a filed in an access table using VB Script.
Current value is "=1". I want to change it to either NULL or ">=0".
Please help me...!
THe following code giving me an error...!
' Establish connection
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Persist Security Info=False;" & "Data Source=" & strDest
Set objConnection = CreateObject("ADODB.Connection")
objConnection.Open strConnString
' Create a catalog for the database.
Set cat = CreateObject("ADOX.Catalog")
Set cat.ActiveConnection = objConnection
' Get the table.
Set tbl = cat.Tables("App")
' Get the column.
Set col = tbl.Columns("ID")
' HERE I AM GETTING AN ERROR saying "Item canot be found in the collection corresponding to the requested name or ordinal"
' Set the Description property.
col.Properties("Validation Rule").Value = ">=0"
Thank you,
Regards,
ADIDADPU
|
|
|
|
|
I have a strong-typed dataset which contains and datatable, and table adpter. The table adpater has custom insert and update commands so they perform the action i require. These work fine with the datagridview items are return on the load they insert correctly and update correctly. The only problem i am having is refreshing the datagridview to show the changes that have been made.
I have tried:
datagridview.refresh
me.refresh(Just to refresh the complete form)
I use a bindingsource to connect to the dataset and return the correct table which adds a tableadpater to the page.
Any help is much appreciated.
|
|
|
|
|
Reload the dataset and bind it anew. The Refresh method is there to redraw the grid, not to reload the contents.
I are troll
|
|
|
|
|
i m new on this forum and i m an engineering student and i m working on my project. my project is about the image processing and after that our robot will response on the signal and pick a ball so basically we are doing the image procesing of a ball. we had selected the hough transform for the detection of our circular shape.but we had not yet finded the algorithm or any programming code for this purpose and we are working on vb.6. so plz can any one help me in this respect to find the algorithm or code of hough transform on vb it would be great for me .we had converted our image of ball into grey image and after setting a threshold we had obtained its binary image now we had to detect the shape and hough transform is the fastest way to detect the circular shape so plz plz help me and provide me either its algorithm or code in vb
|
|
|
|
|
VB6 is dead. Any school teaching VB6 should take a good look at the world around them. VB.NET is available for free. I suggest you download those tools first.
javeria khalid wrote: provide me either its algorithm or code in vb
I'll pretend I didn't read that
I are troll
|
|
|
|
|
You posted the same question in "Algorithms" on the 21st.
Have you forgotten the links you were given there?
No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.
This message is made of fully recyclable Zeros and Ones
|
|
|
|
|
Good Morning
I have a table object in autocad 2006 which have 5 rows and 3 columns
now i want to export the data from autocad table to the vb.net grid , ds, or to simple datatable.
i am using vb.net 2008 and objectArx, DotNetArx to communicate with autocad 2006
Please help me
|
|
|
|
|
You're going to have to find an forum that deals with AutoCad specifically. There is going to be very, very few people around here who are familiar with AutoCad, let alone the libraries you're using to talk to it. In my 7 years around CP, this is only the 2nd AutoCad question I've seen.
|
|
|
|
|
Thanks for reply
Can you tell me some good forum that deals with Auto Cad and it's my request to you that when ever you find such forum than plz tell me.
Again thanks
|
|
|
|
|
I don't use AutoCad so, no.
Try AutoDesk's site, then Yahoo and Google and a few carefully chosen search terms.
|
|
|
|
|
Hi Dear
I have found the solution for my question. Now i am using DotNetArx to select the Autocad TABLE object.
Have a nice day, take care, bye
|
|
|
|
|
I have been writing an app in Visual Studio 2008 with a sql 2005 back end. The app is in testing right now and I am trying to wrap everything up. I was just wondering if there is some easy way to tell how much hard drive storage the app will use, and also if you know how; how do I find out the minnimum RAM requirements. There may not be a way to do this but I still really need an answer to the original question (HD space requirements). Thanks in advance for your help!
-Joey
|
|
|
|
|
HDD storage required: Add the file size of finished application and support libraries to the total maximum size of any setting files you might store while the program is running
Minimum RAM requirements: Look in Task Manager's Process tab. View the Peak Working Set column (you might have to use the View menu)
|
|
|
|
|
Hi all
- I have a form with 4 RadioButton and 1 Treeview control
- Each RadioButton populate the treeview from the database in different way.
- Suppose I click on the 1st RadioButton, the Ttreeview is populated by reading from the Database, then I click on the 2nd RadioButton, The Treeview is populated, then I click on the 1st RadioButton again, the Treeview will be populated by reading again from the database.
Q: What I want is when pressing the first RadioButton first time, store - in a way - the treeview, so when pressing the same RadioButton again i don't want it to be read from database again and again.
Here is how I am populating the treeview
' **** RadioButton1_CheckedChanged ****
Dim cnn As New OleDb.OleDbConnection("Provider=VFPOLEDB.1;Data Source=F:\Help_Desktop_12\DBF\API\API.dbc")
cnn.Open()
Dim cmd As New OleDb.OleDbCommand("SELECT p_func FROM api GROUP BY p_func ORDER BY p_func", cnn)
Dim dr As OleDb.OleDbDataReader
dr = cmd.ExecuteReader
If RadioButton1.Checked Then
Me.TreeView1.Nodes.Clear()
While dr.Read
Me.TreeView1.Nodes.Add(dr("p_func"))
End While
End If
Thanks In advance.
Like car accidents, most hardware problems are due to driver error.
Samir R. Ibrahim
|
|
|
|
|
Why don't you just have two treeviews and show/hide it based on the radio button.
|
|
|
|
|
In my case, I should have 4 Treeview above each other, changing one property of a single Treeview will make me change it in the all 4.
I will check if I can store the Treeview in variable TreeNodeCollection and post back if succeed.
Thanks.
Like car accidents, most hardware problems are due to driver error.
Samir R. Ibrahim
|
|
|
|
|
You could store the values in one variable, and you could write some code to parse the contents of the variable and populate the treeview?
Edit:
Or in a file instead of a variable
If everything was not true, would it be not true that everything is not true?
|
|
|
|
|
Hi
Can someone please show me how I can disable drag and drop in a form using VB.Net?
Thanks
|
|
|
|
|
Well, I think I'm right in saying that unless you handle the drag-and-drop event nothing will happen anyway. So, don't handle the drag-and-drop event
|
|
|
|
|
Ok, so how do I handle the event? You have to excuse my ignorance, but I am fairly new to VB.Net, and I am learning by experience.
All I am trying to achieve is stop a user from highlighting a piece of text and dragging it over to a document. So, how can I stop a user from doing this?
Thanks
|
|
|
|
|
Any of you guys been exposed in creating the Schedule in a calender method. for example monday up until friday been booked and calender also utilised, feel free to post your solution have fun
|
|
|
|
|
I think you have accidentally come to the wrong site.
Try here[^].
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Tiyani wrote: feel free to post your solution
No!
|
|
|
|
|
to create a schedule using VB.NET,
|
|
|
|
|
A calender can be used to print a diary. Write your appointments with HR there
|
|
|
|