Search results

Hmmm... How about using an UPDATE query to populate the fields that you want to calculate? You'll have to do this again everytime you add a new record and everytime one of the fields change. That's why we said it would be more advisable to perform the calcultations on the form itself and not...

It's also hard for us to see what you mean exactly without showing us the database :P If I get it right, the value is calculated by summing 4 other values that are also present in your query? You might still want to consider calculating the field directly in your query and simply displaying...

In reply to your PM: I agree with battenberg's sollution :)

Basically requery refreshes the data that's been "queried" from your tables. While doing this, it uses the most up-to-date info available in your form/tables.

I would solve this as such: Make a form in which you add a new user. On that form, add a button that opens a second form, on which you add a computer. Then you can use your current form to display all that info and add the licences. Hope this helps.

Okay, having a look now.

Can I have a looksee at your database? Thx!

Just off the top of my hand, haven't tested it... Try me.requery GL

Anyway, like I always say: Show me the problem and then i'll fix it. Please post your database. ^^

Heh, sounds familiar... And they always claim that there's no difference and that it's probably Access' fault. Anyway, can't tell you how to fix it, start searching I would say :(

First you do: Me.date_issued.Value = Null and then the validation kicks in (beforeupdate) Private Sub Form_BeforeUpdate(Cancel As Integer) Dim blnValidation As Boolean Dim strValidate As String If IsNull(Me.date_issued) Or Me.date_issued = "" Then blnValidate = True strValidate = strValidate...

You could change the combobox-settings to Multiple, that way one can select multiple items from the box by keeping the Ctrl-button pressed in.

Brrr *confused* Can I have a look at your database?

WoW ftw :) It is a social life killer though... Oh well ;)

Hi, First question: I sincerely hope the salary-field is numeric in nature, else this won't work (change Field1 with your fieldname ofc): Private Sub Field1_LostFocus() If Me.Field1.Value > 100000 Then MsgBox "Warning! The salary is above $ 100,000!", vbCritical, "Warning! High salary!"...

<-- Clueless... Sorry :o

I'm afraid that invisible form backgrounds isn't yet a part of Access up to today. Maybe some VB-wizard can help you with some good custom coding? My advice though: Let your users use the clock in their windows taskbar. ;)

Hello, I think that first line should be like this: If [Forms]![AUTHORISE]![quserid] = "ADMIN" Then This is if the forum in question is still opened ofcourse.

Yep, above sollution will work provided that the /xxxx is always 4 characters. If not, you'll get faulty results. Use this code to be absolutely sure: LocNo: [Field 2] & Mid([Field 1];InStr(1;[Field 1];"/")+1;Len([Field 1])-InStr(1;[Field 1];"/"))

LoL it probably would :)