
Denaes
Avatar/Signature-
Posts
975 -
Joined
-
Last visited
Content Type
Profiles
Forums
Blogs
Events
Articles
Resources
Downloads
Gallery
Everything posted by Denaes
-
Date/Time Procedural Query Problem with Access
Denaes replied to Denaes's topic in Database / XML / Reporting
-
XP Home "Explorer.exe" memory/proccessor Abuse... Anyone know how to fix this? Long story short, I don't use XP. Even my computers that come with XP I put my win2kpro on. I have a laptop (Dell Inspirion 8500) with 512mb of ram. It's a P4, something like a 2,400mhz (2.4ghz)... I recently had to put XP Home (what came with my laptop) back on the machine because I lost my keycode for win2kpro and becuase I do buisiness work (personal buisiness and for another company) on my machine I don't want to "aquire" a pirated keycode for my win2kpro. my old vendor can't get me my keycode and has no records so far back (win2kpro was an upgrade I purchased with an older computer) and I'm stupid and don't have the paperwork either (lost in a move). Well, now I'm doing the same things I'd do with win2kpro. Play music, web browse, program, video/dvd, accounting, etc. Only now, its slow and unresponsive. I turned off the XP theme (the option of "Best Performance"), and eventually turned off the backup restore option. Currently I'm typing this with IE open (Firefox took too long to open) and Task Manager open to monitor my system resources. Yeah, theres a lot of crap open in the system processes, but who knows what most of it is. Never been a problem in the past. My Explorer.exe is using 163,256k memory and alternating 96-99 CPU % as I type (apparently IE is weaseling away a % or 3 every million cycles). This is really bothering me. I actually restarted this same laptop using win2kpro like once a month, usually resting or hybernating it for journeys. I've had to restart this computer 3 times in the last 4 days to get my memory back. Its also dangerously warm and the CPU fan is constantly on. I have another fan on it, which keeps it cooler, but won't help me if I need to travel with it. Is there something to do be to fix this error? I've been downloading every XP patch MS offers, even really stupid ones, just in case. I know software is getting more memory/cpu intensive, but 256 is the going memory, XP shouldn't be eating up 300mb for running itself and having IE open. So if anyone knows of any links to fixes, or fixes themselves, I'd greatly appreciate it :)
-
Date/Time Procedural Query Problem with Access
Denaes replied to Denaes's topic in Database / XML / Reporting
I still don't know why that wouldn't work, but I found a kind of ghetto workaround. using the SQL Statement: PARAMETERS inStartDate DateTime, inEndDate DateTime; SELECT * FROM Schedule WHERE (((Schedule.BookingDate) Between "inStartDate" And "inEndDate")); I don't know why Access likes to put so many parenthesis around the WHERE criteria, but it does. The '=' just kept throwing errors. Using the Between criteria and using either two dates (or the same date twice) seems to work. It gets done what I need to currently get done, but I'd like to know what the proper way is to do this (or were I went wrong) if anyone knows :) -
Someone here on the boards convinced me that it was better to store time (HH:MM) and Dates (MM/DD/YYYY) as Date/Time format in the database; I had been storing them as Strings. Then I came to a point were I need to evaluate ranges of dates and Text wasn't cutting it. So I switched over to Date/Time formats. So far I've gotten the Insert and Update down pat. I can insert Dates and time just fine. Now I have a very simple Query were I want to pull up all records that have a particular date (eventually I'll need to pull up ranges of record dates). I kept getting Procedure mismatch errors using VB.Net, so I put that down and opened up access. This is the SQL Query : PARAMETERS inQueryDate DateTime; SELECT Schedule.[Date], * FROM Schedule WHERE (((Schedule.[Date])="inQueryDate")); and here is the error it brings up: I tried it with 'like' instead of '=', which threw no error, but produced no results. The date I'm trying to pull up is everything on "5/2/2004", the date is set to "Short Date" so it only is MM/DD/YYYY rather than all that extra stuff. I'm sure it's not a hard issue, just something I'm missing/dont' know. I'll keep looking, but I'm dead tired right now (2:50am here!). Edit: Sorry, wrong forum. I ment to post to the Database Categoy, sorry. Could someone please move it over here? :p
-
I'll take your word on that :D I'm know it works, I'm just trying to figure out why it's better than .ShowDialog and what it does. I don't doubt what he says, I just don't understand it. It seems to act (in practical view to me) just like .ShowDialog did. I know it didn't, but I'm trying to understand how it differs and how/why I can/should use it in the future.
-
I see an array of dates for bolded dates. Is there any such way to instead make certain dates Red and others Green? I need to show users which dates aren't allowed to be chosen (red) and which they have chosen (green). I could do it with bold dates being illegal and a listbox of chosen dates, but thats a waste of space. Any clue on this?
-
So that loads the MainForm as it's own thread and allows the other to keep going (instead of being held up at the .ShowDialog spot) and dispose of the Login and subMain. It works great. I just like to understand how it effects the program :)
-
Sub Main() 'Splash Screen 'Becuase "Splash" is the chosen mode 'it will count down from 5 and dissapear on its own. '"info will cause the splash screen to appear without ' the countdown. Dim Splash As New frmSplash("Splash") Splash.ShowDialog() Application.DoEvents() Splash.Dispose() 'Start up the Login screen Dim Login As New frmLogin Login.ShowDialog() Application.DoEvents() 'Once the Login in finished, it checks for a valid 'user level and user name. If Login.UserLevel <> "" Then 'if there is a user name, it calls the main form. Dim MainForm As New frmMain(Login.UserName, Login.UserLevel) Login.Dispose() 'I had to call this as a dialog to keep the subMain from quitting MainForm.ShowDialog() Else 'No valid user logged in. Probobly canceled out. Login.Dispose() End If 'End of subMain, program is over End Sub Anything glaringly wrong or that I could do better to load my app?
-
Changing Titles and Deleting Posts
Denaes replied to Denaes's topic in Suggestions, Bugs, and Comments
-
The data would have to be on one line each per item (to do it easily). Dim payroll As sPayroll Do While Reader.ReadLine = "***" With payroll .empNum2 = Reader.ReadLine .FICA = Reader.ReadLine .gross = Reader.ReadLine .net = Reader.ReadLine .pDate = Reader.ReadLine .wHolding = Reader.ReadLine End With Loop This is set up for a seperater being: ***. Anything else will stop reading. So the text file has to be formated: Seperator EmployeeNumber FICA Gross NET Date witholding Seperator etc You may have to create funtions to validate the data. You wouldn't want to kill your app by throwing someones name into their gross pay or ID number. Honestly I hope this is just a project. I don't think a textfile is the safest place to hold tax information for employees. I'd at least go with a database that was password protected. In the least I'd write/read to/from a text file in some sort of encrypted form like creating a function to scramble/unscramble the characters in the string.
-
Ok, I just had a problem, asked a quesion, then found the answer a little bit later. I couldn't delete the post. On other forums (VBCity I think) you can change your Title for many reasons. Sometimes you find a better title becuase you didn't know what the question was called at first (thus making it near impossible to do a search on it) or you might want to add "Resolved" next to your Title. Just a helpful suggestion :)
-
This might be what I'm looking to do, but I don't know how to do the loading. How to you prime/run code (causing it to compile) for a form while it's in the background, before the main app has started? Can you start the app in the background and while it's not visible (but still running) open up other not visible forms?
-
I'm not just talking about slow things, but how the first time you do anything in .Net, while it compiles JIT, it's slower. After it's been run once it works fine. The first time you can wait 2-5 seconds for a form to load. Its not that long, but when someone just paid 10,000 to upgrade their program to .Net, they don't want it going slower than the old Delphi/C++ version. After the first time, it only takes a split second to load.
-
I've never used .chm's before in a program, but a quick search in MSDN gave this: It looks like you were just typing in the "paint_brush.htm" and missing the "mspain.chm::/" part. I hope that helps your problem :)
-
-
You know how the first time you run certain things, it runs really slow? Yeah, thats a nice first impression. But after the first time something is used, it works like butta. Is there a way to prime your intensive procedures up front while a splash screen is showing? Maybe open said forms, run certain procedures once in the background while everything is starting up. I mean, heck. .Net (and my app in particular) starts much faster than most regular apps I have which have a splash telling you "loading XXX.dll, XYZ.com, etc" You could just throw up a "Initializing program" message. When it starts up, it would run mad fast.
-
Hmm :confused: I thought I just posted this as a topic, but it's not here. Is there a way (.net code or otherwise) to make a copy of a database and strip away it's data? I could copy and paste the database and delete records, but I have the TableID's (primary key) set to Autonumber. The clints will need to interact with a few of these table ID's and don't want them in the 1000's. In other words, I need the same structure, but a new database, and I have specific records that need to go into the first few TableID's for some tables. Sure, I'm lazy. I could 'remake' the database again. But this would take some time (possibly introducing new errors into the application) and is feasable once, but I'd prefer an automated method for future uses.
-
From DataSet Could have origionated from nothing (you just made it up on the fly), Access, XML or SQL Server. I'm assuming that you have relations and tablenames, columnnames, properties filled out. To: Anything I know XML is possible. Access, Oracle, SQL Server Done in .Net via programming, not an external application (like MS Access, Oracle, SQL Server, etc)
-
I remember writing like 1000 lines of code to create an Access database in vb6. It sucked. I've also seen a method of the dataset is WriteXML, which writes the entire dataset structure to XML. Is there a way to write to Access or another Database? Not even for the data so much as the datastructure. I think that would be swell for errors when a database goes "poof". You can at least start over again.
-
The program I'm using uses the Flexgrid from C1 and two of my own personal controls. When I add my own two controls to the project, their respective .dll is copied to the bin directory. The c1 (which I take it, is registered with .Net) was not automatically copied. The program works fine in the IDE, but when I emailed it to a collegue, it gave .dll errors. I assumed the relevent .dll data was written into the binary exe for the project, because their .dll's arn't in the directory. It turns out that the project will run anywere on my machine becuase the c1 dll's are registered, but when he tried to run it, it would ask for specific .dll's. We had to exchange like 5 emails with me emailing him the dll's it was asking for (because it won't ask for the other 5 until it gets the first). This is a bit silly. The Bin directory is the output directory and should contain all that is needed to run the app short of the .Net framework. Is there an option I'm missing that would copy the dll's over automatically? Or do I have to open up the References and try to hunt everything down by searching on my computer? Currently I don't have a 2nd PC to run these sorts of compatability tests on, and the .Net framework hasn't been ported over to OS X yet, so my other machine is of no help.
-
Programming Method - How are you getting around with it ?
Denaes replied to Arch4ngel's topic in Water Cooler
Writing comments seems like a good idea. Also similar to interfacing, you could create all of the procedures, but none of the code within. [quoteWhen speaking of classes I have a lot of classes, ExtendableProperties and such that I allways re-use... Alex :p I'm scared of this now... after a post here, people are telling me that it's common practice for a company to ask for full rights to your code. I think that would put a dampner on code reuse if you can't reuse the dll's or classes you used to create said program. -
asp.net requires the end user to download dll's? I thought it was all server side. Or is this a special case?
-
When you create a dll (or any program) you have to include its' dependancies with it. When you create a dependancy (like to winforms or whatever) it creates a dependancy, but since the version becomes part of the files name, it knows that you're supposed to reference mscorlib v1.0.5000.0 which is in the CLR (.net framework) 1.1 Do you not have .net framework 1.1? Was the project (PocketImageEditor) started when you hade the framework 1.0? I don't know what the issue on your machine is, but the dll is dependant on CLR 1.1. If you're not using 1.1 you may need to recompile it using 1.0 (or whatever version you're using) so that it references the other version.
-
Ok, after you reference your dll, you've gone over to the References folder in your Solution Explorer and verified that your NameSpace is showing up there? When you type the NamespaceInDll and type a . (dot), does intelisense pick it up?