Search results

  1. R

    Populate Combo with Fontnames

    Hi, I'm looking to add a user settings functionality to my DB and wanted the user to be able to select which font, backcolor, forecolor Logo .... they want to see on there individual workstations. What I need is to be able to create a combobox with a list of all the fontnames. Searched...
  2. R

    Elance Website

    Hi All, Briefly discussed this in another post. Was wondering if any one here has had any experience of the Elance.com website? Hoping to get myself some Freelance development work and found the site on a search.
  3. R

    Tab Control inside Tab Control

    Hi, I'm trying to put a Tab control inside a page on another Tab Control but it won't work. Is there a way around this without using a subform inside the page?
  4. R

    Using IIF & Like statements in query

    Hi All, Normally I would do this in VBA, but I'm intrigued as to whether I can do it in a query. I'm building an advanced search for my DB and the user can select many option: 1) What field to search in 2) Whether to search the entire field, or Any part of the field 3) Whether to search all...
  5. R

    Custom Message Box

    I recently posted an example for a custom message box. Then realised that it wasn't overly portable. Back to the drawing board and now have this one! Give it a go and let me know what you think. Any suggetsions greatly appreciated. Paste the code into an empty Module. Option Compare Database...
  6. R

    Removing multiple items from multiselect listbox

    Hope someone can help. I have a listbox on a form with letters waiting to be printed. I need to be able to remove multiple items at once using an SQL statement. The main problem is that I need to include multiple columns in the SQL as I loop through the items. What I need is something like...
  7. R

    Free UK Postcode Lookup

    Simple but effective way of turning a postcode into a full address without paying for a subscription. Feel free to use the code, just send a thanks if you like it! Written in Access 2010, but should be fine with 2007.
  8. R

    Custom Msgbox example

    After days of searching for a solution to my problem I decided to tackle it head on and create my own. Why does Access not let you format a msgbox? Never mind, here's my solution for you to use as you wish. This is tested in Access 2010, but should be compatible with 2007 aswell. Rich.
  9. R

    Hello

    Hello everyone. Been Access programming for years now, and only just scraping the surface of this awesome application. For the first time in ages I can say THANKYOU to Microsoft! Happy to help with any queries you all have. And any Freelance work that's hanging around, let me know! :) See...
  10. R

    How to create msgBox with button label Yes(Y) and No(N)

    Slight change of thread, but thought this may be of use. I've been searching all over for a way to customise a msgbox but there doesn't seem to be a solution. I therefore wrote my own. Hope this may be of use to someone. I've only written in options for up to 4 buttons, but the form / code can...
Top Bottom