|
Cory Kimble wrote: Is there a query in Access I can do that updates every time a table or tables change?
No. Access databases do not support triggers. There's no way to capture when the database is updated from any and all sources.
The only way this can happen using Access is if all database transactions are done through a component that you write to do all the database work. All other applications that use that database MUST also go through your component.
Cory Kimble wrote: Keep in mind that I want to update the original table that I don't have access to.
Then you're not going to access what you don't have permissions to. If you don't have to permissions, you're not going to get them unless they are granted to you by the admin of the database. No permissions equals no update.
In your situation, you simply have no options.
|
|
|
|
|
Does the third party software keep a log of table changes? If so you could import that into your db.
_____________________________________________
Flea Market! It's just like...it's just like...A MINI-MALL!
|
|
|
|
|
No log. But, It has a query in the database that updates automatically. Is there a way I can use that?
|
|
|
|
|
Cory Kimble wrote: It has a query in the database that updates automatically
There is nothing in Access that updates THAT automatically. You'll have to find out what's making this change. That's IF you have to rights to poke around the database that much.
|
|
|
|
|
Hi,
Why is it not possible to make the value variable of a property setter ByRef? actually i need to access multiple properties of a calling form in the class and was therefore trying to pass the reference to the form to the class. Is there any way around this?
Thanks in advance!
Ahmad
|
|
|
|
|
You can't change the Setter to ByRef. It also doesn't need it. A property setter is expected to NOT change the object being passed to it, so why would you need a Ref to it??
Ahmad Zaidi wrote: i need to access multiple properties of a calling form in the class
??? Post a copy of the property code so we can see what you're trying to do. It sounds like you;re trying to exceed the bounds of what a property should be doing.
|
|
|
|
|
You are confusing a reference with passing parameters by reference. You don't need to pass a parameter by reference to pass a reference as a parameter.
You only pass parameters by reference when you need to change the variable that you are passing as a parameter. The default way of passing parameters is by value. For a reference type it means that the value of the referece is passed, i.e. a copy of the reference.
---
single minded; short sighted; long gone;
|
|
|
|
|
Thanks alot guys. You're right, i've done it with a function instead!
|
|
|
|
|
I want to write a windows service application that reads a web page. That web page requires that the client can process javascript.
Has anyone successfully implemented Javascript with System.Net.WebClient?
I tried the code from the article "A simple .NET based WebClient with JavaScript support" but that code crashes with an inner JScriptException. Its acknowledged by the author and it looks like the trail ends there.
According to microsoft the Microsoft.JScript.Vsa.VsaEngine used in that project is deprecated.
What is the current working solution for processing webpages in code?
This is what my code looks like. The web page at the URL I am calling uses javascript to set a cookie in order to prove that Javascript is running. It doesn't look like this code can do it. I can set cookies in advance but I can't seem to duplicate the javascipt setting a cookie. Help!
Dim webClient As Net.WebClient = New System.Net.WebClient
webClient.Credentials = System.Net.CredentialCache.DefaultCredentials
webClient.Headers.Add("user-agent", "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; .NET CLR 1.0.3705;)")
webClient.Headers.Add(Net.HttpRequestHeader.Cookie, "aCookie:aCokievalue")
Try
Dim data As Stream = webClient.OpenRead(sURL)
Dim reader As New StreamReader(data)
Dim s As String = reader.ReadToEnd()
'response = webClient.DownloadData(sURL)
'Return Encoding.ASCII.GetString(response)
Return s
Catch ex As Exception
Return ""
End Try
|
|
|
|
|
how do you put data into a database from a form?
|
|
|
|
|
1. Connect to database.
2. Create query from the data in the form.
3. Run the query against the database.
4. Disconnect from database.
|
|
|
|
|
how do you create the query ?
|
|
|
|
|
If you don't know SQL, you're going to find this pretty hard to do. Even if you don't want to learn SQL, learn it You ARE going to need it sometime in the future.
The query string is specific to your database table. It usually follow the following format:
SELECT columnName, columnName, columnName FROM tableName
WHERE someCondition
|
|
|
|
|
I have mistakenly deleted the my service exe from the specified path and it can't be obtained again but my control panel is still showing the service icon in my control panel > services. When i try to install the same service again from the installer,it says service already installed. Now how do i remove such a service from my control panel without my service exe?
@!$(-)@ $@r£r@Z
|
|
|
|
|
Uhhh, what does this have to do with VB.NET???
|
|
|
|
|
Hello.
I 'm writing my question for the third time, because I don't get a suitable answer. There is the origin of the Coordinate System on the top left corner of forms in VB.Net project. Is there a method or a code that we use it to change the condition of the origin of the Coordinate System. For example, set the origin of the Coordinate System on centere of the form? can you help me? please send me the method.
Thank you.
Reza Rajabi.
|
|
|
|
|
You could manually transform the co-ordinates. You'd just need to write a method that would add or remove the appropriate number of pixels. When setting the coordinates on a control or window you'd use the method to convert from yours to the windows standard.
As for the code, why not write it yourself? It's not that hard, just some simple maths (addition and subtraction).
|
|
|
|
|
Posting the question a 3rd time won't change the answers. You can change the origin by using the Scale and Transform methods and properties of the Graphics object your using to do the drawing.
|
|
|
|
|
Hello. Thank you for your reply. I used the "scale" method, but I could not change the place of the origin of Coordinate System. I used this code: "Me.Scale()"
Can you help me?
|
|
|
|
|
Did you look at the TranslationTransform of the Graphics object you're using to do the drawing?
|
|
|
|
|
Do not keep reposting the same question. It's considered rude. As stated earlier, please read the forum guidelines. Also, asking for someone to just send you the code is rude. If you have a section of code and are having troubles, please feel free to post that, and the problem, and we'll look at it.
_____________________________________________
Flea Market! It's just like...it's just like...A MINI-MALL!
|
|
|
|
|
Reza12 wrote: I 'm writing my question for the third time
Didn't you look at the replies you've received? Asking the same question over and over tends to just piss people off around here 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
I am beginning a project working with a paradox file type .DB. This is new to me and I need help. The project is to read the file, update, and add the file data to a database. Has anyone ever worked with paradox files using vb.net? If so please help.
jds1207
|
|
|
|
|
There are a couple of ways you can go about this. You can read the files using a DBase connection type, or you can import the Paradox files into MS Access/SQL Server (depending on the size) and use that as your data source.
I guess it depends whether you need to keep the Paradox file at the end, or if you are simply performing a data migration into a different database.
D.
-------------------------------------------
Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Just bugger off and leave me alone!!
|
|
|
|
|
How do you open the file with this type of extension?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
