I have 2 tables that I need to use an INNER JOIN on.
tblEMPLOYEES has FIRSTNAME, LASTNAME, EMPILID, DATETRAINED, DEPT
tblMAIN has EMPILID, OBSERVATIONDATE
In tblMAIN, the EMPILID is not the primary key, and each ID can have several dates. I only want the last date each ID has an Observation, and then to join that with the tblEMPLOYEES data and essentially get a recordset of each employee, and their last...
ewokspy
Last Activity: Oct 22 '08, 02:29 PM
Joined: Sep 6 '07
Location:
-
INNER JOIN and MAX between two tables
-
Breakpoint in Excel VBA not breaking
Working with Excel 2003, I have a worksheet that I programatically generate from another worksheet. On this worksheet are two events, a selection change event and worksheet_chang e event. The selection change event just forces an application.cal culate. The worksheet change is:
...Code:Private Sub Worksheet_Change(ByVal Target As Range) 'Ensure we are connected to code and disable all events/updating If Not StartEvent
-
C# Type of Shutdown
I know how to determine if a user is shutting down Windows, but I don't know how to determine whether they initiated a shutdown, a restart, or a logoff. I'm using the WndProc to determine that system is shutting down, and using .NET 2003. Thanks. -
It doesn't seem to stop the code for the rest of the program. Just the thread that it's working with. I use the Main thread to force the bubble thread to become active when they use a specific function, and I would love to resynch the thread upon windows shutdown, but I have no forms that are active to sniff the Wndproc for shutdown messages, since I noticed that winproc won't return anything if the form isn't active.... -
I was sure that was only for .NET 2.0, I'm using studio 2003, so it's only 1.1 for me.
Regardless I will rephrase and say I don't see the code in my closing events being executed upon shutdown. I put a method to create a txt file and log the event but it never executed until after the bubble was no longer waiting....Leave a comment:
-
The question is where do I call that? I have tried logging what events were called in my program during shutdown but I cannot find a place to put that code. The close methods and dispose methods don't get called when system is shutting down it seems. The for is hidden so I can't active montior the system messsages. Is there a specific place in the code I can put this where it will run as the first thing the program does when trying to shut down?Leave a comment:
-
C# Form Timer and Form Visibility vs. Threading and .Set
I have a C# program in 2003 that creates a reminder bubble (windows form) to remind a user to pick up their printout. The bubbles show up fine, and they have 2 buttons, a yes and a snooze. The yes resynchs the thread. The snooze puts the bubble to sleep for 5 minutes.
Originally my event handler code for the snooze button pointed to the following method:
...Code:public void SnoozeForm(int minutes) { //VAR -
C# dataadapter.Update Syntax error
When I perform an Update using a dataadapter I am getting an error stating there is a syntax error in UPDATE command.
Here is the Update Command that is in the adapter:
UPDATE PAPrintJobs SET (Threaded = ?, PickedUp = ? ) WHERE ( Id = ? AND Owner = ? AND SubmittedDate = ? AND SubmittedTime = ? );
Can anyone spot the error? I'm pretty sure I have verified all column names match, the table name is correct... -
I wrote code to run each query manually rather than using the Update command. If I'm not mistaken, the only difference between these two methods in function is Update will accept changes to the dataset, and this won't. Other than that both loop through each changed row and perform the appropriate SQL statement to each row. Why the parameter statement I wrote isn't working is beyond me since the new one is.Leave a comment:
-
Neither. I cycled through all the values and there are no blanks and no nulls.Leave a comment:
-
C# talking to Access: Missing Parameters
When running the Update method of a data adapter I get the following OledbException : "No value given for one or more required parameters."
In this situation I am strictly inserting rows into a dataset, then updating the source. I only use an insert command which is:
"INSERT INTO PAPrintJobs ( Id, Copies, Printer, Computer, Owner, Document, SubmittedDate, SubmittedTime, JobStatus, TotalPages, Cost, Threaded,... -
C# Uninstall Shortcut and Command Line Arguments
I am trying to add an uninstall shortcut to the user's program directory upon installation of my application. I utilized the following website:
Adding Uninstall Shortcut
And then conformed the code to C# in this manner:
...Code:static void CheckUninstall() { string[] arguments = System.Environment.GetCommandLineArgs(); char[] delimiter = new char['=']; foreach(string argument -
That was what I was looking for. :)...Leave a comment:
-
Emulating Find/FindNext in C# via OleDB connection
Is there a function to search, say a datareader or the like, for a particular record in a returned query? Like I want to see if there is a record with an ID # of X and USer ID of Y, rather than looping through.
If not in oledb, in ADOX perhaps or another model?
Right now I'm looping through the entire recordset, but that's not very fast. -
Using the MS Access Object model in C#
Is there any reason why I should not use the Access object model to manipulate an access database in C#? I've done a lot of VBA coding so I can move through that easier, but instinct says I should ask before I start to try and do it. I've added the reference to my project and can see the methods, but I'm wary there has to be some catch. -
I put it into my dispose method, but still not capturing that message. I added a message box to the dispose method of that form, and never saw it pop up at all.Leave a comment:
-
C# and WndProc, Getting closing code to run
I have read up a bit on WndProc. and I have the below in my code. But I have two issues. One it seems that the code only runs while the form is running code, so if I have the form on standby, hidden in the system tray, this function is never called. So I never run the shutdown code. How can I get this to run if the system is shutting down, and then how do I stop the system shutdown, long enough to run my methods?
...Code:protected override
-
My search fu was obviously weak this time around.
Thank you, that solved all of my icon problems. :DLeave a comment:
-
Icon Trouble in C#
I am having 2 seperate concerns regarding icons in C#.NET 2003
I have an icon that I created in VS. Easily enough I can attach this to a form or system tray object, etc. But if I take the icon and attach it to the system tray icon, it shows up just fine. But the (same) icon I attach to the form doesn't show up correctly, instead looking like the default icon picture. Any idea why this would happen?
Secondly, how does... -
<Nevermind. Brain fart.>Leave a comment:
No activity results to display
Leave a comment: