Recent content by IpeXeuS

Hello guys, This was exactly what I was looking for, but tell me genious mates is there way to add year and month values from text fields to that difference between two dates?

Hello mates, :cool: I'm a bit confused with date codes. What I'm try to complish here is that how to add years and months from separate fields to text box, where's difference between two dates as an years and months? So basicly first I read year and month values from text boxes to a integer and...

Ok, but if there's some values in list and you dont need them anymore (in this case person group for example), what you would do, cause you can't delete them if foreign key is set to not null and they're in use? Do I need to go every single person through and select another group and after that...

Erm, I'm not quite sure now what you guys trying to say? I'm about to delete value from group list for example, but you say I'm not deleting anything. Now I'm confused tbh. :confused:

I've database where's lots of person details and they all are in certain group and when I remove some value from group list, it will automatically removed from person details as well. So, should I use that Allen Browne's cascade-to-null code in this case or what do you suggest? :)

Ok guys, thanks for your advices, you were great. =P

Hello, I'm using Allen Brownes very helpful cascade-to-null relations (http://allenbrowne.com/ser-64.html) code in my database project, but there comes problems whit a foreign key and null values, cause foreign key shouldn't be null. Is there anyone else using this method with relational...

I tryied that solution u suggest last one and that error message what I mention earlier is gone, but now there coming this error message when I'll try to close that database connection, what I opened when form opened: Object variable or with block variable not set

Ok mate, I'll give it a try and report here how did it go, ok. :)

Hi there, :cool: I've a bit problem with connecting to my backend database on server. I've a form that read's backend path to hidden text field with openargs in onload event. Then I've "OpenBackEnd True" code when form opens and "OpenBackEnd False" when form closes. I use code below: Public...

Ok, thanks for your tips. But I don't have any popup forms, cause everything is in one form, but theres lot's of subforms init. That message for other users would be great. So, where should I start this process?

Hi there, :) I've one problem with multiuser environment application. Ok, theres about 5 users occasionally using my application and what I try to complish here is that when user opens specific record for editing, then it's locked from other users and they will receive a message about it. If...

Like I said before, I load each control source on form's load event. But hey, now I can see new record line, but it's locked or disabled somehow and I don't know how?

Hello there, I've this weird thing again and it's about adding a new record. Ok, I just added this feature that form loads controls sources dynamically on load event. Controlsource fields doesn't contain anything now cause I moved those source datas to controls tag property field. Here's a...

Thank's for your tip, but what happens then when user hits enter to add new line to larger memo textarea for notes? :confused: