Search:
Type: Posts; User: Quasar6
Search:
Search took 0.02 seconds.
-
Hello all,
I have a Parameter Query in Access that retrieves the most recent records for each PartID up to a particular date. So, as an example, there may be a record with the PartID number...
-
The date-time idea is a good one: I was going to set up a boolean for each connected user within the "Users" table of the database, but date-time is so much more elegant.
Any idea if a 1x1 table...
-
For some reason the combination of words "vomiting enthusastially" cracks me up. I just keep getting this mental image of Random Employee #472 grinning happily while projectile vomiting.
-
D.T.E
("Double-you, Tee, Eff")
-
Hello all,
A recent project of mine requires a real-time view of a data queue so the user can see, with a lag of preferably no more than 3 seconds, what all the users connected to the SQL Server...
-
The collision is being detected, you're just not acting on it, see:
If ball.Location.X < playerPaddle.Right And ball.Location.X > playerPaddle.Left Then
'Checks that the balls Y position is...
-
Hello all,
I'm loading a particulary large database (access 2003, oledb) into a few seperate DataGridViews in my program (64,000 records in one table, 120,000 records in another, each record with...
-
Thanks guys. I'll look into upsizing the database to an SQL server and see what I can achieve that way.
-
Hey all,
Using C# 2008, an Access 2003 *.mdb database, and a Microsoft.Jet.OLEDB.4.0 connection.
I am building a program that monitors and queues tasks ultimately for around 40 users on the...
-
Hah, that's brilliant! Not knowing that, I've been using Insert for batch saving. Re-working it will vastly improve performance on those functions. Thanks Jmc, I really do owe you. :D
-
Jmcilhinney wins. Thanks man, I owe you many alcoholic beverages. I replaced my TableAdapter.Insert() with a Table.AddTableRow() and followed the process up with an Update, and it's running many...
-
Hi all,
[.NET 3.5, Visual Studio C# 2008, OleDb connection, Access 2003]
As part of a database synchronisation program, I need to delete all the data in one table and replace it with the data...
-
Ah, I've found a workaround, so this no longer has the urgency it did. I need an emoticon for "slowly coming down from the heights of frustration."
Long story short: I cleared the databindings...
-
Hi all.
I'm having a rather irritating problem that I haven't been able to trace. I've been using a Table Adapter to fill out a Datagridview and DataBindings to fill out a number of labels.
...
-
Hey guys. I found an alternative (and rediculously simple) solution here: Simply compile for x86 instead of the default "Any CPU."
Oddly enough, I'm having no trouble running it on 32-bit systems,...
-
Thanks Si. I gathered that the Jet.OLEDB.4.0 provider wasn't installed, but I didn't know where to go from there.
I've changed my Data provider and connection string over to ACE, and now get a...
-
Hi all.
[C# 2008 Pro] [MS Access 2003 *.mdb] [OleDB Connection]
I have built a database-interface program for my employer which works fine on 32 bit systems (including Vista 32 bit), but I need...
-
Whoops, apparently not. I forgot to mention that I'm using a Datagridview bound to an access 2003 database. You may kick me now.
After building a sortCompare function which didn't work, I found...
-
Thanks! You're a lifesaver, jmcilhinney! :)
Resolved.
-
Thanks jmc. That solved that problem! :D
I've got a similar problem in a datagridview now, as well. Often, a string column will be filled entirely with numbers (but still needs to have the...
-
I need to sort a list of strings, which contain numbers and letters.
When I perform a sort, I get patterns not dissimilar to those below:
1-A
10-A
11-A
...
19-A
-
(C# pro 2008, Access *.mdb file & an OleDb Connection)
Hello. :)
As part of a 2 database synchronisation program, I need to be able to detect the most recent/important changes.
~ Is it...
-
Okay, thanks for all your help, JMC. I found the problem: I had added an extra column to the database and dataset and not updated the MainSQLFilter string to match. In my defence, a concurrency error...
-
I tried putting an EndEdit() and Update() after every change. It happens on the very first row, when I attempt to blank out the cell (previously, the cell (a text cell) contained the value "1405")....
-
What do you mean by "try to save one record at a time"? Call update after each change?
Is there anything else you can give me? I'm at my wits end here... :o
-
In short, I took the whatever-I-can-get-to-work approach to filtering the database. What I do is create a string like this:
MainSQLFilter = @"SELECT ID,Field1, Field2, Field3, Field4, etc...
-
:wave:
(Using C# Professional 2008 and an Access 2003 *.mdb database)
I'm getting a fairly standard concurrency violation...
... when I attempt to update my table adapter (built in the...
-
Hi all. I'm experiencing a very weird situation regarding one of my SQL queries being fed into my C# app via a DataTable.
Short version is: I have a query which gathers information from two...
-
Thanks for the suggestion Psyrus. I tried messing about with that format, as well as several other things (using the Last() function, and I tried subqueries as well), but never quite managed to...
-
I'm just after any thoughts or idea's about how I could approach this problem. It's got me stumped, but then again, I'm not an SQL wizard. :o
My table records the history of individual items as...
-
Hi everyone.
I'm using VS Pro 2008, C#. The project on which I'm having trouble was upgraded from a C# 2005 Express project, at which point the following error started occuring.
I'm connecting...
-
[VS2008 Pro, C#, Access 2003, OleDB database, Crystal Reports]
Hi all.
I'm new to Crystal reports, and trying to set up a simple report viewer. I've connected to the database, created a crystal...
-
Haven't checked this, but if you reference the Microsoft.Office.Interop.Outlook library, create an Outlook.Application object in your code and handle the "NewMail" event, it looks like that should do...
-
Hi all. Simple question, with (most likely) a complex answer.
I'm generating an E-mail with Visual Studio 2005, via the Outlook Interop library. My employers want the company signature added to it...
-
Thanks Anhn. Problem solved.
-
I'm messing around with a database here which stores timestamps as strings, with the users initials followed by a date and a time. Heres an example:
"JS 07-Oct-08 4:54:13 PM"
It's a stupid...
-
Thanks jmc, after establishing out how to work with DataRowViews and incorporating them with my existing functions, that seems to work.
Cheers!
-
This has turned out to be more complex than expected. I'm throwing it out there in case anyone has had to deal with a similar situation in the past.
The short version: I need to loop through the...
-
Bah, Humbug.
Alien Santa will provide.
And Mendhak: I shudder to think what type of hug requires "a considerable expenditure of energy". But I'm glad to see you're being Green. And amphibious.
-
Thanks guys.
Your suggestions helped me find the problem: the only DELETE statement has a WHERE (ID = ?) clause, but I was using a FillBy statement to filter the table and gather the records for...
|
Click Here to Expand Forum to Full Width
|