Recent content by 0200050

Hi drrocket5292, i've noticed MS Access applications freezing when they're achieving the size of 20 MB. Compact and repair helped to sort this out. Sometimes I've also noticed MS Access apps having strange way not always making connection to tables, and at these times apps have crashed...

Thank you very much sleipnir, that was the trick to make the thing run. Yeah, I prefer the shorter too, but this time my curiosity took over and made me ask you guys. Best greetings, -0200050- Finland

It could be due to a wrong executable path in your MySQL service. I had similar problem, MySQL server was stucked, because of newer version installation. Executable path in MySQL service pointed to totally a wrong place. It now may point to a wrong path. To a path, where is nothing in it...

Hi everybody, I am very proudly presenting this error of mine. You bet. I have a this kinda code, which does the job on my other machine(PHP 5.0.2 and Apache 1.3.33 and MySQL 3.2.53) but it doesn't work at all with this other machine of mine, that has PHP 5.0.3, Apache 1.3.33 and MySQL 3.2.53...

Ok. This strange problem was occuring because of too much AllowEdits/Deletions/Additions confusing MS Access. I removed now all of them, and it works. So, I have to only type better organized protection. -0200050-

Thanks PHV for quick reply! Yeah, this linking should be working fine, both, 1. subform, and 2. subform are connected together with same ID:s. I tried to change the relations, but they seem to be ok already. It does like this when malfunctioning: the Cancel = True only back ups the...

And yes, in addition to this, I hadn't this problem while using the Access's own record browsers (But I still need custom buttons, because the form needs some protection) -0200050-

Hello there, I have a little databasesystem, that is 98 % ready. Only this one thing is annoying me out. Lets go for it. I have a subform with custom browsing buttons(add new rec, go last, go first, go previous, go next). This subform has also subform, but it doesn't have any browsing...

Hi there, Yes, I'm using individual days.. User needs to select an interval, so if there is no individual days, this won't work nicely(as I see it). And the benefit of this all, what I'm driving after... That's ONLY an outlook issue, but let me show: Product ScrewDriver Model...

Yeah, tried to use it before already... The fact is, When we use the date there with it, There comes too many amounts. And these amounts I'd like to calculate at a query ready for a report. Sparepart Amount Product FixinDay Saw 3 Chair 1.9.2004 Saw 4...

Good evening there! My question may not sound simple. I've been thinking this situation I'm having with my prog all day long. Well, anyway, let's get onto it. First, this is how program should function: "User types two dates to a form" - A query receives to dates, and determines the right...

Wow, thank you THWatson! I modified it a bit, and it works pretty well. Actually I only need the CurrentRecord-property, so I use only that. The sorting thing is still on to me, but I try to solve it out myself. -0200050-

The very best evening everybody! Instead of what topic is all about I have actually a problem with sorting SUBFORM's data. I would like to sort that data from MAINFORM. This is what i've tried to do to solve out this one: For the main form: Me.Subform.Form.OrderBy = "FixingDate ASC"...

Thank you for your help! I managed to solve this problem out now. I just did two queries(both had same ID, hadn't tried out that before), and typed some criterias(MAX and LAST), and it amazingly seemed to work out. I'm currently still getting on SQL, and I think I need to learn it lot more. It...

Yeah, I am looking for a solution how to find the latest dates by using the serienumber input. This example of yours is very clear! Thank you very much of it! :) I made it look like this: SELECT * FROM Korjaus_Taulu WHERE (((Korjaus_Taulu.KorjausPvm)=(SELECT MAX(KorjausPvm) FROM...