Search results

... and I think you missed the meaning of the smilie.

If I flew around the moon and saw purple sheep I would probably check for other symptoms of hypoxia. :D

Could you use the recordset to populate a hidden Listbox, or Combobox, and interrogate that instead? Me.myListBox.Rowsource = myQuery might be easier to code than putting it in an array. ETA: Oh hang on, I'm just re-reading this ... Is this actually looking up, and returning a single...

What good education if you find yourself desperate, without a job for a long time and relying on benefits.

Our food bills might rise ... ... and you might have to travel further to get your groceries, because the food companies may close many of their smaller shops, leaving the massive ones out in the sticks, and make many of their already low paid employees redundant. They could also install even...

The answer to that one may soon be "Do you want to receive any benefits .... or not?" ETA: Benefits risk to jobseekers refusing zero-hours contracts ETA: I've just gone back and added some Wikipedia links to my previous post (3948).

Not that you'd know that from comments on some other UK fora. :D :D Zero hour contracts - (Currently) Exclusive contracts to be on call to a company with no actually guarantee of any work. Workfare - Unpaid work placements for the long term unemployed, described by some as "forced labour" or...

You try this approach. Field value defaulted to 99999 (or any impossible positive number) in the table definition (Not entered) Any negative value below -274 (BeforeUpdate changes to -274 and treated as N/A) Private Sub Form_BeforeUpdate(Cancel as Integer) If Me.yourFlashPointField <-274...

Will there always just be 3 x "/"? If it is the position of the last instance that you require you could use the InStrRev() function. It works in a similar fashion to InStr() but, as the name suggests, in reverse.

If you were to use a negative value then anything below -273 centigrade (absolute zero) would be a reasonable choice. You could then hide / show the control depending on the value. Public Sub yourControl_BeforeUpdate(Cancel as Integer) ' If value is below Absolute Zero then set value to -274...

Re: Is there anyway to restrict users to hide&rearranging the columns in Datasheet vi I think that was a subtle hint that each user should have their own local copy of the front end. Apparently having a shared front end can cause problems, although I have not come across any personally, it has...

If it's just a single field you could try something like ... Private Sub Form_BeforeUpdate(Cancel as Integer) If Len(Me.yourControlName & vbNullString) = 0 Then ' If field has no characters in it MsgBox "Field 'yourControlName' should not be blank", vbInformation + vbOkOnly...

If the Field name and the Control name are both the same, apart from capitalisation, ie bookName / BookName perhaps Access does not know which one to use? Try to qualify your code a bit more, you could try. "[bookName] = " & Chr(34) & Forms("yourFomName").[BookName] & Chr(34) You might even...

This is an interesting discussion, and worth having, but don't forget the original thread is somewhat old ... almost 11 years.

I think these days I would probably use something like Google Maps to locate a building as a new record is input, because you'll probably have a full address, then derive and store the National Grid Reference on the record.

I used to have to geo-code postcodes using the Royal Mail PAF file (Postcode Address File). This might be fine if you want to locate a particular house but if you want to use it on the addresses of things like chemical works the location of the actually postbox might be quite some distance...

A Microsoft bug? :D 12/31/2001 - 53 12/31/2002 - 53 12/31/2003 - 53 12/31/2004 - 53 12/31/2005 - 53 Ooh :eek: 12/31/1916 - 54 12/31/1944 - 54 12/31/1972 - 54 12/31/2000 - 54 12/31/2028 - 54 12/31/2056 - 54 12/31/2084 - 54 12/31/2124 - 54 12/31/2152 - 54 12/31/2180 - 54 12/31/2220 - 54 ...

How to use the Expression Builder, as suggested by namliam, (step by step) (Yes, I know I'm complicating it again but if the OP doesn't know what it is, let alone how to use it ...) The process is more intuitive and less complicated than it looks when written down. 1) Open the form in design...

Depending on what you are inputting, another couple of possibilities: % percent (20%) ^ to the power of (2^3 = 8) Would it be freeform entry or could you apply an input mask to the field?

Is the Back Style property of the Label set to Transparent rather than Normal? If it is set to Transparent then it won't matter what colour you make it you would still see the colour of the form instead.