Search results

I just wanted to let you know ive figured it out when it comes to manually adjust the 2 axes of a graph. I made 3 textboxes for each axis. 1. For giving the minimum scale 2. For giving the maximum scale 3. For giving the size of "steps" taken to get to max scale. So lets say the minimum...

I just remembered, i had made an Excel file a couple years ago which had the possibility to manually change the scale of the axes. Luckily i was able to find it (i think), and even though its VBA code is in Excel format id like to paste it. This is the VBA code of a form within Excel, where...

Good Morning, I have a mainform with a couple of subforms, and i can switch through them using tabs. On one subform, i made a chart . Which works fine. Also added a button to refresh that chart if changes has been made (on other subforms). What i would like to do now is to give the user...

Nevermind.. Ive decided to keep the button, instead of letting it update automatically.

Good morning, First i'd like to thank everyone who helped me in the past. All Databases and its features are Live now, and no complaints yet. I am working on yet an other database though, and i cant seem to figure this out. Ive created a form with 4 subforms. 1st one is to display the...

I think ive got it! I used If Not Screen.ActiveControl.OldValue = Empty Then strReason = InputBox("Wat is de reden voor deze wijziging? (Max 40 tekens)") And it seems to work just fine.. I would like to thank everyone who took their time to help me out, and had the patience. Thanks...

Aahh got ya... Sounds logical ;) Ill give it a shot. Thanks m8. update : Get a syntax error at 'me' and 'NewRecord' :confused:

Hmm.. The data in the required fields are protected though, so the user can not change them. All the protected fields are displayed in the header of the form. And in the body ull find other fields that our employees in the lab have to put in, according to their test results. The code...

Currently i am trying several methods to get this to work.. My next 'method' : If Screen.ActiveControl.OldValue = Empty then ELSE strReason=InputBox("txt") update: Still no luck.. It keeps showting the InputBox ..

Here is the link http://www.access-programmers.co.uk/forums/showthread.php?t=196053

Ok, then i would like to opologize for double posting. I guess ill look into those properties. Thanks.

To be honest, yes i have asked the same question in the VBA thread. But unfortunately no one has replied to my post since the 16th, and i am getting desperate when it comes to this 'problem'.. I just dont get why it cant be fixed by a simple check that checks if the...

Good Afternoon, Ive added a new function to my database which logs the changes made using forms and saves it to a table 'Audit'. (The function is being called in the BeforeUpdate event.) Everything works just fine, but theres just one thing i cant seem to figure out. When a change is...

I tried this: If IsNull(Screen.ActiveControl.Value) = False Then strReason = InputBox("Reden voor wijziging? (Max 40 tekens)") End If But it still asked for a reason when i entered data into an empty record.

Well, at the moment there is no Afterupdate Event.. Theres only a before update event, which calls the function TrackChanges() ..

ooh i was close ;) Thanks m8 !

Good afternoon, I just added a new function to my database, that basically keeps track of all the changes made in the database using forms. It works great! But theres just one thing i would like to add, with the code below, i get the message strReason, every time i enter data using the form...

I went through the post u made earlier about remotely kicking people from the database, and i tested it myself just for giggles, and it works great. I was wondering if its possible to run the no activity timer after a certain time. Lets say, 17:00 o 'clock.. Ive tried the ifstatement If...

Cheers m8! Allready have the 'no activity form' rdy, just need to implement the fOSUsername() = Loginname of securedworkgroup part. Thanks a lot!

Ooh thats a pretty good idea actually.. Thanks, and ill have a look. So all i need to do is add the fOSUsername()=loginname to the autoexec, and eventually add the "no activity" event ?