Recent content by RECrerar

Thanks, I've worked out the Euro sign so that is now working okay. As to how it feeds into the accounting system, that's not really a huge concern as the database is not used directly to calculate any costing but more to report the amount we spent on a project compared to the amount it is...

Hey Gemma, Sorry for the late reply, your responce made me realise that I was being a muppet. I was stuck because I had one instance of the lookup table joined to multiple fields ni the query and I couldn't figure out how to get the right values (hence the look-ups). I've now since changed...

Hi, I'm hoping to revive this old thread as it is exactly what I was about to ask. Basically in my case the value of our contracts can be entered in either sterling or Euros and the currency it is entered in is specified by another field. On the input for the currency selected is either...

Hi, I have my database structured such that I have a a main table in which several fields get their values from a table called tblCodeValues. That is the main table just contains the code ID and the text descriptions of that ID are all contained in a seperate table. Several fields in each...

Hey, Thanks for the links. The first one was perfect and it is all working now. I have the following code: Function BidTasksOK() As Boolean BidTasksOK = True Dim DataValNum As Integer Dim strControlNames As String Dim msg As String DataValNum = DLookup("[SecurityLevel]"...

Hi, I have a bespoke data validation system set up for one of my forms. The data validation defines which controls must be popolated for a project dependant on the project status (which is itself a control). The controls to be checked are variable (i.e someone with admin permissiong could...

Yep, I think I should be able to manage that (hopefully)

huh? Sorry to be slow but firstly what exactly is a network place? Next how would I create one and why would I want to?

Hi, Thanks for the advice. I will get as much completed as possible then before splitting. Is it possible to elaborate a bit on point 2 as I'm really not very hot on this area yet. Is it something I should get on the phone to the IT guys about? I like the your idea of a custom login...

Hello, I am getting there with completing my database and am now thinking of splitting it into a front end and a back end before distributing to users. I've never done this before so I have a few questions. 1. As I said, am almost there with the database, the table structure for example is...

It was quite nice this morning, about 8 degrees (celcius, I don't understand farenheight). Recently it has been quite cold, around around freezing point but nothing a coat and scarf can't deal with. Should be fine to walk around

Just joining in here. I live in London and I wouldn't recommend going from heathrow to Paddington and then into town and it will be much quicker and cheaper to take the tube which will take directly to Covent Garden (very nice) or Picadilly Circus and take about 40 minutes total. I'm not too...

Hi again, How do I disable the mouse wheel for just specific forms? This now also ties in with another form I have that has a combo box in the header that is used to navigate to a specific record. I would like this to be the only way to navigate to a record on the form Regards Robyn

Hi again, It appears I can't do it myself by navigating to regedit and changing the setting there as I get a message box telling me permission denied if I do. I tried your code. I defined RegValue as as string as this wasn't defined and it runs but doesn't do anything, the flickering is...

Well I've found out what it is. I guess this is something I will need to get the IT department people to do. http://www.ammara.com/access_image_faq/access_loading_image_dialog.html