Search:

Type: Posts; User: Quasar6

Page 1 of 13 1 2 3 4

Search: Search took 0.02 seconds.

  1. (Access 2007) Running a Parameter Query Several Times at Once

    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...
  2. Replies
    3
    Views
    2,023

    Re: Realtime Database Queue [SQL]

    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...
  3. Replies
    30
    Views
    2,866

    Re: What is the best way to quit your job?

    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.
  4. Thread: W. T. F

    by Quasar6
    Replies
    43
    Views
    3,718

    Re: W. T. F

    D.T.E

    ("Double-you, Tee, Eff")
  5. Replies
    3
    Views
    2,023

    Realtime Database Queue [SQL]

    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...
  6. Thread: [VB.Net] Pong

    by Quasar6
    Replies
    3
    Views
    33,366

    Re: [VB.Net] Pong

    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...
  7. 2.0 [RESOLVED] Preventing OutOfMemoryExceptions

    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...
  8. Re: Irregular OleDbException: Cannot open database

    Thanks guys. I'll look into upsizing the database to an SQL server and see what I can achieve that way.
  9. [RESOLVED] Irregular OleDbException: Cannot open database

    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...
  10. Replies
    5
    Views
    1,655

    Re: Inserting Large Amounts of Data

    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
  11. Replies
    5
    Views
    1,655

    Re: Inserting Large Amounts of Data

    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...
  12. Replies
    5
    Views
    1,655

    [RESOLVED] Inserting Large Amounts of Data

    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...
  13. Replies
    1
    Views
    507

    Re: Data Bindings lost during Fill

    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...
  14. Replies
    1
    Views
    507

    Data Bindings lost during Fill

    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.
    ...
  15. Replies
    8
    Views
    4,376

    Re: OleDB - 64 bit compatability

    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,...
  16. Replies
    8
    Views
    4,376

    Re: OleDB - 64 bit compatability

    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...
  17. Replies
    8
    Views
    4,376

    OleDB - 64 bit compatability

    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...
  18. Replies
    6
    Views
    1,285

    2.0 Re: [RESOLVED] String-Number Sorting

    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...
  19. Replies
    6
    Views
    1,285

    2.0 Re: String-Number Sorting

    Thanks! You're a lifesaver, jmcilhinney! :)

    Resolved.
  20. Replies
    6
    Views
    1,285

    2.0 Re: String-Number Sorting

    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...
  21. Replies
    6
    Views
    1,285

    2.0 [RESOLVED] String-Number Sorting

    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
  22. Replies
    1
    Views
    467

    Per record metadata (Access)

    (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...
  23. Replies
    6
    Views
    2,879

    Re: [RESOLVED] DBConcurrencyException - Access

    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...
  24. Replies
    6
    Views
    2,879

    Re: DBConcurrencyException - Access

    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")....
  25. Replies
    6
    Views
    2,879

    Re: DBConcurrencyException - Access

    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
  26. Replies
    6
    Views
    2,879

    Re: DBConcurrencyException - Access

    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...
  27. Replies
    6
    Views
    2,879

    [RESOLVED] DBConcurrencyException - Access

    :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...
  28. Replies
    1
    Views
    903

    Negative Autonumbers in Query Fill?

    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...
  29. Replies
    2
    Views
    536

    Re: Complex SQL Filter

    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...
  30. Replies
    2
    Views
    536

    [RESOLVED] Complex SQL Filter

    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...
  31. Replies
    0
    Views
    595

    2.0 VSDesigner Error

    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...
  32. Replies
    0
    Views
    462

    No data appearing in viewer

    [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...
  33. Replies
    7
    Views
    1,005

    VS 2005 Re: Outlook Email Alert

    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...
  34. Replies
    1
    Views
    1,554

    Adding a signature in Outlook

    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...
  35. Re: [Access Queries] Extracting part of a string

    Thanks Anhn. Problem solved.
  36. [RESOLVED] [Access Queries] Extracting part of a string

    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...
  37. Replies
    5
    Views
    1,572

    Re: Changing Data in Selected Rows

    Thanks jmc, after establishing out how to work with DataRowViews and incorporating them with my existing functions, that seems to work.

    Cheers!
  38. Replies
    5
    Views
    1,572

    [RESOLVED] Changing Data in Selected Rows

    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...
  39. Replies
    38
    Views
    1,307

    Re: What did you buy this holiday?

    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.
  40. Replies
    4
    Views
    549

    Re: Vanished Data

    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...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width