Search results

Quick question, you're not using forms in this database, are you?

Is this what you are trying to do? Also, I renamed Students to tblStudents (good practice, that!). And made a Forename/Surname field for your Students. Otherwise, what do you do when you get two Smiths? But, then, two John Smiths....?:eek:

It was suggested in this thread that I post up a user class that I mentioned. So, while my own is tailored to my database and much more complex, dealing with permissions, user levels, etc I've made a small example that can show what can be done. So the User class. All it does is load your...

Psst! Learn to give your control's descriptive names, preferable with a prefix. Such as cboMarking, cboStyle, txtStatus, and so on. If you come back to this database in future, you'll read your code and wonder where the hell - or even what! - Combo68 is all about.

Anyway, what code do you have just now? Or is it the case that your table design has the Required property flagged, and that's your issue?

A more detailed overview of what you're trying to do, I think. So, if I can understand this: ...you have several controls on a form that require information be entered into them. However, if the person clicks a button to close the form, you want to forget that these fields are required and...

Your Access's in-built help will describe and provide examples for how DoCmd.TransferText works.

to done, still needs processing, or awaiting approval First, what are your rules on how this is determined? I see someone's understanding being that you have three folders. However, no confirmation from yourself as to whether this person's understanding is correct or not. Either way, you're...

I'm with Frothingslosh here. No need for an extra function. Format([WithdrawalDate], "mmmm") would do what's needed display-wise.

What am I not seeing in your maths? Example 1: Requested = 53, Received = 53, Rejected = 1 [Requested] - [Received] + [Rejected] Expected result = -1 Therefore, obviously [Requested] - ([Received] + [Rejected]) 53 - (53 + 1) 53 - 54 = -1 Example 2: "if I increase the qtyrecd to 60 I...

Okay, not sure how you managed to miss it when you replied to it and quoted it in full. But, anyway, glad it's working.

So what part of my update doesnt' work? Did you even try it? See picture, using your 126 example.

=IIf([Parts booked into stores].[Form]![Passed]="Rejected" Or "part rejected",[Parts booked into stores].[Form]![text23],"0") You need to be explicit here. =IIf([Parts booked into stores].[Form]![Passed]="Rejected" Or [Parts booked into stores].[Form]![Passed]="part rejected",[Parts booked...

You are being inconsistent. So, are we now saying, that we need formulas for: 0-100, 101-200, and 201+ rather than 0-100, 101-300, and 301+ which is what your initial request was?

Browsing another thread, I've just seen a link to this page http://allenbrowne.com/appaudit.html

This? Public Function GetValue(ByVal dblValue As Double) As Double If dblValue > 100 Then GetValue = 100 * 5.79 dblValue = dblValue - 100 Else GetValue = dblValue * 5.79 Exit Function End If If dblValue > 100 Then GetValue = GetValue +...

Another point to consider is why do we even have an IIf() here? If Text28 (that name!!!!!) is equal to 0 then qtyreqd - (qtyrecd + Text28) will still be qtyreqd - qtyrecd as qtyrecd + Text28, where Text28 = 0, is just qtyrecd.

Okay let's look at this: =IIf([text28]=0,[qtyreqd]-[qtyrecd],[qtyreqd]-[qtyrecd]+[text28]) Where Text28 =1, qryreqd = 53 and qtyrecd = 53 So: =IIf(1=0,53-53,53-53+1) So, 1 does not equal 0, therefore we are looking at 53-53+1. So, 53-53 = 0 and then +1 = 1. If you want -1, then it's an...

It's going to take a lot of coding, most likely in a Class Module, to create some sort of in-app audit trail. First things first, is how it was possible to delete records. Do users have direct access to the tables? If so, nip that in the bud. On my tables I add fields for DateCreated...

Multiply it b -1.