Recent content by Hakello

:banghead: duh. Sorry, I guess that was pretty obvious :( Thats what you get when someone asks to change something you made ages ago... Well, at least you made some teachers pretty happy :) You are right about the debugging, I'll take a better look myself next time, its just that I am a little...

I made the following vba command to save a pdf for every student in a particular group. However, when executing the code the loop stops halfway the second iteration and I'm not sure why. I added some debugging msgboxes and it dies the second time it gets to DoCmd.OutputTo acReport, stRap, "PDF...

Thank you JHB, that does work, but now when results are filtered all records with Null values show up as well :p I tried something with Nz() before but I guess I eh, well tried to compare the filters to null instead of the value because it works now :o Thanks for helping me think again...

Hello everyone, I have a form in which users can enter data in several textboxes to filter the listbox below it, this works great except for the fact that when a record lacks certain data it doesn't show up Basicly there are 4 filters, one for the name/id which works great, as the entries...

I tried to catch it there, but the error was given even before the (bound) form would close, in fact as soon as the field in question lost focus it fired this error. This was solved by setting the allow ZLS to yes and then catching it on beforeUpdate I kinda figured it would be Null when a...

This works! So simple yet so brilliant :D Now I can incercept zero length strings on unload/button click without access bothering me! Ah yes sorry, I mixed up, my original example was about students but I already solved that by making it unbound, so I used another example in my third post which...

Hm? I don't really understand, why would you assume it is not required? I allow users to edit the data they entered, but there needs to be a certain minimum of information for the record to be usefull, thus the code (PK) is required. I could change it to have an autoincrement PK and make the...

Ok thanks, always good to know, going to add some checking code to some beforeUpdates! My main problem however was that when a required field is left empty it fires a "You must enter a value in the ... field" and I'm having issues with catching it. Catching runtime errors works great (like when...

I...hadn't actually tried using and empty variable as I simply assumed it would give an error, thanks :o

Hello, I currently have a bound form that adds a new student, however, I've decided I don't like bound forms as weird stuff can happen (like when the user exits in another way than I anticipated) so I'm making an unbound form which will add the student when a button is clicked. I already have...

-EDIT- Solved - see first post

Thanks Eugin, I think I came across that site while googling before and its indeed very(!) usefull but I still get errors :P Following the matrix, I take the 'not in these forms' for filtering sub1 and get the following code: Forms!POP_Cijferinvoer!POP_CijferinvoerSUB.Form.Filter =...

I'm sorry, but I can't figure out how this is supposed to work even though there are tons of threads on this already :banghead: I have a NAV form where someone can select 3 values from comboboxes. By clicking a button (which checks if all values have been filled) you open up a triple layered...

You are right Jdraw, this would solve my problem, but it woud also require more user actions per edit than the current system, something I wish to keep to a minimum. After all thats why I'm building this thing in the first place ;) Everything works fine already, its just that I find it ugly to...

Thank you Gizmo, maybe I don't understand you correctly but I don't believe I have duplicate -records-. I'll explain better, I have a form which shows a [Student]s information with a subform that shows all his [Result]s. These [Result]s are coupled to a [Test] which is coupled to a [Subject]...