Search results

Hi teh1 Have you tried using the function IsNull() instead? eg: If IsNull([Forms]![frmDupes]![Temporary_InvoiceNum)Then goto etc hth Helena

Hi kbrooks Display the account number on the form and use Access built-in search facility to search for the account number. You could also use this to search for any fields displayed on the form eg surname etc. A quick way of bring the search facility up is Ctrl+F. HTH Helena

Hi Splity This may be a bit of a simplistic answer but have you though of having the email recipient names in a pull down list with it's limit to list property set to no. Then the user can only pick a name from the list and it will always be correct. HTH Helena

It now works!

Thanks Jon - I will now give that a go. Robert - I looked at the date I was passing in - its directly from a date field in a table so I was definitely passing a date to the function. Interestingly the dates where days and months cannot be confused work, it's just the ones where days and...

Thanks for that Robert, I will check it out. Helena

Hello I hope this is an easy one and that I'm just having a momentary relapse of brain cells... I have the following very simple piece of code: Public Function BankHol(BHDate As Date) As Boolean Dim X As Variant X = DLookup("[BH_Date]", "[T_BankHolidays]", "[BH_Date] = " & "#" & BHDate &...

Hi PEASLET You could try joining the old workgroup c:\windows\system\system.mdw before opening the file. This may let you in through the "back door". hth Helena PS You can tell I've been bored at work today!

Hi PEASLET Try looking up SendObject in Access help - or searching for email in the forum archives there are lots of mails on this topic. hth Helena [This message has been edited by helena (edited 05-15-2001).]

Hi aziz I have found code that shows what objects are in a given collection, and to delete an object from a collection - in the Access DAO help. Search for: TableDef Object, TableDefs Collection Summary and then goto Name and then choose DAO example: ************************** This example uses...

See my reply in tables section...

Hi Alex The only thing I can say about them is they are very noisy so make sure you get the quietest one you can. Other than that you can treat them like any other printer. Helena

Hi Kaspi You could try putting this in your code before the form is opened: DoCmd.OpenForm "F_DataSheet", acDesign, , , , acHidden Forms![F_DataSheet]![Your-column-name].ColumnWidth = 500 DoCmd.Save acForm, "F_DataSheet" DoCmd.Close acForm, "F_DataSheet"...

Thanks for that bob, this is the answer. I have used this code to find out what groups the current user is in, then appended those group names to a table which is linked to a menu structure table, in other words depending what groups a user belongs to they will see different menu items in a...

Is there a function similar to CurrentUser() that will return what group the current user belongs to? If not, has anyone used their code to return the group name? Thanks in advance Helena