Search results for query: *

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...

This(last post's first) query seems to work fine sometimes, but then it gets down suddenly. This is seen as wrong records. Searching the records is done by typing serienumbers into a form. From this form the report gets the information of what kinda serienumbers it has to deal with. And each...

Thanks for correcting! So there were 5 fields! Man, am I lost(?). I have five fields in a table, of course(!), there are something near 500 records what of course(probably) isn't necessary detail. I've got more than one of those queries, but this is the most used one. (Notice (or ignore)...

Good evening everybody! I'm currently having a little problem with queries. I have 5 records in a table. 4 text records and one date. I made a query with these information. Date record can be sorted out with newest information easily, just setting its Total to MAX. But that's the point...

Hello everybody! Refering to the title, I'd like to ask you a question about sorting records by date. This is the situation: I have a form with many of fields. The form has one subform, and this subform even has another form in it. Now the information on this FIRST subform are pretty messed...

Okay, this another thing is now solved too, with this kind of a code: Private sub Command1_Click() Dim ID as Variant ID = Shell("hh.exe H:\Project\HelpFile.chm", vbMaximizedFocus) End sub Original solution of this was found at here...