Search results for query: *

Hello, For a new app I am trying to get our twitter feed in it, So far I have got a JSON Parser for search, but this just searches twitter for any tweet of any user with the name you supply. I just want to show the tweets I did place on my account in a UITableView. Can someone help me point in...

Hi Jason, Thanks for your reply, I was looking on google for a very long time, After my post on here I found something of usefull, see code below; string connectionstr = Properties.Settings.Default.VerzendDB1ConnectionString; OleDbConnection conn = new...

Hi All, For a urgent work project I need to create an XML file from a c# program. In my access database there is a table called tblparcels. it contains all parcel information. not only the table information needs to be added, 2 fixed fields need to be added. the XML should look like this...

Got it, Properties.Settings.Default.ConnectionString1 Was not correct, It had \10.0.0.1 instead of \\10.0.0.1 Thanks anyway

...a record, it gets deleted. The problem occurs at the second SQL query. the error is: Invalid Argument. selectSQLL = "INSERT INTO table1 SELECT * FROM [MS Access;DATABASE=" + Properties.Settings.Default.ConnectionString1 + ";].[table1]"; //Delete all information from Stores...

I Managed to get everything in the Treeview as I want, But I cannot see if there is something open for a specific store. I have fixed this temporary by only showing the stores which has something OPEN in the treeview and put a extra node with all the stores in it. I cannot figure out that last...

Found it out, Change that part of code to OutstandingTreeviewCalls.Filter = "Store=" + Convert.ToString(comemailasm3.ExecuteScalar()); What I forgot was to say in the command on which field it should filter, which was field "Store". Thanks for the help.

Both is not working for me,.... Still getting the error at this point; (Filter expression '7622' does not evaluate to a Boolean term) outstandingCallsBindingSource1.Filter = Convert.ToString(comemailasm3.ExecuteScalar());

Hey Jason, I am actually including a value, comemailasm3.Parameters.AddWithValue("@name", SqlDbType.VarChar); comemailasm3.Parameters["@name"].Value = e.Node.Text; e.Node.Text is the text which is for the selected node. and the code you provided gave an error in...

...= Convert.ToString(comemailasm3.ExecuteScalar()); connemailasm3.Close(); But an error occurs, Filter expression '7622' does not evaluate to a Boolean term (*where 7622 is the storenumber which is picked up from the database) Any idea what im doing wrong here?

Hey Guys, I have tried looking it up on Google but I cannot find what i'm really looking for, Im hoping someone might point me in the right direction; I have a MS access database with the following tables; tblStores tblTickets tblOrders What I want is a treeview where I can see if there are...

thanks, the field is not called Count offcourse, I just used that to make it more clear, it's all dutch nonsense :-P I had already tried to remove the "" but then access gives "The expression you entered contains an invalid syntax" but I think you are right on the text comparison, as in Text...

Hello, I have got a strange thing in MS Access, When i use the following rule; IIf([Count]>="2","True","False") If Count is 1 it will show "False" = Correct! If Count is 2 trough 9 it will show "True" = Correct! If Count is 10 trough 19 it will show "False" = NOT CORRECT! If Count is 20...

Its a query that already exists in the msaccess database. and yes its already filtering the results. it just needs to give the count of that query. im not using SQL Server form Microsoft but MS Access. when trying to run that in MS Access and let Access advise the performance of this query, it...

...string command1; string cmdCount3 = Properties.Settings.Default.IT4ConnectionString1; command1 = @"SELECT Count(*) FROM OutstandingCalls SELECT Count(*) FROM qryOpenTasks"; OleDbConnection connCount3 = new OleDbConnection(cmdCount3)...

Jason Meckley has posted this in one of my previous treads which is actual something i can try to do, Combine the 3 Get Row Count SQL queries into 1 SQL command. I'll post the results later.

...string selectCount; string cmdCount = Properties.Settings.Default.IT4ConnectionString1; selectCount = "SELECT Count(*) FROM OutstandingCalls"; OleDbConnection connCount = new OleDbConnection(cmdCount); OleDbCommand comCount = new...

...to an HTML file app2.DoCmd.OutputTo(MsAccess.AcOutputObjectType.acOutputReport, report, "HTML (*.html)", fileName, Type.Missing, Type.Missing, Type.Missing); // cleanup...

WOW, Thanks alot, In the datagridviews there isnt lots of calls, but when submitting a ticket, there are ALOT of them..... with this i can just combine them. Ill let you know my findings :)

Thanks for the quick response Jason, Looks like i might go for Option 4, which is exactly what im looking for, gonna try it tonight. to answer your other questions, there is a table named tblTickets, which contains all tickets reported. In the database, there is a query which shows all OPEN...