Ah but that i dont want. I want 1 gpk code that could relate to multiple knmpnummer. so every knmpnummer can only relate to 1 gpkcode, not multiple.
thanks!
Ah but that i dont want. I want 1 gpk code that could relate to multiple knmpnummer. so every knmpnummer can only relate to 1 gpkcode, not multiple.
thanks!
Have a look at the updated front-end that I reset to use the old field.
Cheers,
Vlad
Hey Gicu,
thanks for the new front end. i tried to integrate all the new functionality into my own front ent as it has some other adjusments. It mostly works now. i also adapted the overzichtstabel and deleted the gpktable.
The only thing im running into now is the ontstripformulier. i cant get it to work with my newest version. it keeps giving me the error ''barcode does not exist or is not active''
heres my newest frontend: https://drive.google.com/open?id=1nm...xVImK17b7ec-dA
Try this one. Please note that you have missed some code changes in the Geneesmiddelbewerkformulier form as well, I have now corrected both.
Cheers,
Vlad
thanks!
but it still gives the same error?
EDIT : fixed the cb name and the sql still refered to gpk, changed column number and now it works
thanks again!
You're welcome!
So how would i go about making a single backup file that automatically backups when i close the program?Sorry haven't had time to look at it, it is hunting season in my neck of the woods... For the first one I thing you should give it some more thought as the backup copies can pile up quite fast the way you want it. It can be done but you need to think about disk space, naming conventions and general usability. As an alternative you could export the main tables as text files and keep a rolling 5 or 10 copies of each (every time you shot down you replace the oldest set with a new one).
Cheers,
Vlad
i dont need seperate versions of the backups, overwriting the same one is good enough.(as long as i have at least one backup)
Download my free utility and either schedule it (with Windows scheduler) to run sometimes during the night or open it from the unload event of your main form.
http://forestbyte.com/ms-access-util...end-compacter/
Cheers,
Vlad
Ok thanks! will have a look at it and try to put it in the unload form.
i have an issue with the ingevoerd door field in the forms, sometimes it shows up empty and sometimes it only shows a number instead of a initial(which is my main problem now). i cant seem to find the issue in the form. what's causing this?
https://drive.google.com/open?id=1Xo...bxuSDJwEhpLOS8
The issue is caused by the use of the lookup in the table for that field. You are displaying the initials but storing the user id. If you open the table (in the back-end) in design view and change the lookup from combo to textbox and save you will see that the field has a combination of initials and user ids (numeric). You need to remove the lookup in the table and remove the ID column from the combo on the OverzichtstabelListForm form. I have done it for you in the attached (look at the screen shots to see the problem).
Cheers,
Vlad
thanks for the reply!
i can't see your screenshots, they wont extract here and give an error
the forms work now, thanks. Still get an error(instead of the errormessage i want) when the form is empty though.
Im looking through the code you have written and the comments. When you say that i missed those changes does that mean that i still have to change something or that you already fixed it?
error 94 invalid use of null. when i click on the error handler i see that the error is in the line: ''FileName = Me.Geneesmiddel & Me.Id''
When do you get the message, is it in Knop179_Click on the Geneesmiddelbewerkformulier form? Are the Geneesmiddel and Id populated? You can test for them and exit if missing.
Cheers,
Vlad
its the ''opslaan'' button on the geneesmiddelbewerkformulier form (not at a computer now so cant check if its 179).
I have a control to check if there are empty fields in the form. So if i try to save i want it to give an error that there are some empty fields.
So to test the function i left all fields empty on the geneesmiddelbewerkformulier in dataentry mode, when i press the save(opslaan) it gives that error 94.