Search results

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

Thanks for the suggestion but I've already set warnings to false for the duration of the code. As I said it's not exactly critical just doesn't look that smart

The message in the message box is "Importing ............." (where the ...... is the image name) From this I am deducing that this has nothing to do with the error generated when the image is not found. Any ideas how I can stop it appearing? My the image is linked not embedded

Hi, I have a form which is used to enter user details. The form has a textbox that holds the name of an image and a picture that displays that image. In the oncurrent even of a form I havethe following code that tries to load an image with the name in the textbox and if this is an error...

Don't worry My first search didn't bring up anything, but a bit more digging about and I found it. If Me.Dirty Then Me.Dirty = False Thanks anyway PS. Thanks pbaldy, didn't see your responce when I first replied. Thanks for your option. Is there any advantage in using that over the...

Hi, This is porbably really simple. I need to force the update of information that has been entered into a form so that it is saved into a table (tblAnnualPT) from a button click. That is the button click does the same as moving away from the record and then moving back. This is because...