Recent content by rhounsome

Travis. Your a star. It works well sort of. Can you explain why it sort of needs to be prompted into life to get it working. For me to get it to work I need to check the box go to the previous record and then back to the record I was entering before the value appears. However once I have...

I think I have sorted it. In the Format Field I didn't realise that you can enter your own format so thats exactly what I did. Found it by accident. Got furstrated and Pressed Shift and 4 and hey presto $ came up and then just using the same format as in excel did $#,##00.00 and it works...

This is probably the easiest question to answer if you know where to look but I don't. Working in the UK with Access 2000 I need to set the field in a table to show Dollar $ USD however the only values I have are £ GBP and € as defaults. Now I thought that I could get this to change if I...

I am using a DLookup script in a Form to insert a figure into a field on the form in the event of an office being closed due to regional holidays. It was working fine and I thought everything was fine. The script was as follows If Me.AmericasHoliday = True Then Me.AmericasBacklog =...

Excuse me for my lack of knowledge but what is an INDEX. You are talking to a very Green(NOVICE) Access Programmer. :confused:

I have a form that contains 5 fields and want to ensure that duplicate information is not entered. I am aware that when creating the form you can set Duplicate Records to No but each record has an AutoID which I assume means that even if the information is the same it will not register as a...

Strange Question but how do you go about clearing the list that appears in the replication drop down list when you wish to synchronize and replicate. We have a database which has grown and changed names numerous times. Yes I am aware that this is not good practice but I have gradually learnt...

This is a what does is do question. I had problems with a database I had created and getting it to synchronize possibly due to its size or trying to do it over a network connection (don't know). I found a link regarding this issue and it had something to do with changing the HKEY sections in...

Cheers Graham it works great. Took me a bit of time to work out what everything meant but works exactly like I wanted to. Thanks to all the others for their input.

I hava a finsihed database and upon opening takes a bit of time to open. At present I just have the pointer changing into the egg timer which causes a problem with some of our users. Because nothing seems to happen for a while they think the machine has crashed and try resetting. Can someone...

I have a child form "Status" within a master form "Company". Whilst everything looks fine on the form, it doesn't when you try and print it out. For example I have 10 records in the Company database with the Status form indicating IN PROGRESS and as I mentioned in normal view the IN PROGRESS...

OK this isn't VB Scripting as such but still does the same thing. If you can adpat it it might help. Status: IIf([Company]![Acceptance Date]=#01/01/90#,"In Progress",IIf(Now()>[Company]![Review Date],"Out of Programme",IIf(Now()>[Company]![Review Date]-31,"Review","Active"))) This query...

Create a query that looks up the company details from the name of the company entered. Then make a sub form displaying the address of the information related to the company choosen from this query. Sometimes known as a Master and a Child Form. HTH Russ

I know its going to sound a bit thick but you are stating to just turn off the notification for a period of time to get through an issue. Is this because notification relates to every on screen pop up message?

Thanks for the info. As mentioned being a novice to all this, I guess there is a lot to learn. Still on the append/delete issue. Notification can be turned off on the toolbars on the top, so it never asks but if the user is not aware of this is there anyway to turn it off when the database is...