Search results

Guys Thanks a million, I used Bobs code, works treat. Many thanks for your help.:D

Thanks guys, I shall give your examples a go now. Hopefuly I shall have only one message show no matter how many flags are triggered. I will let you know how it goes.

Hi All, Is it possible to have just one instance of this message box fire when one or all or any number of the flags are triggered. At the moment if 2 flags are set then 2 messgage boxes appear,if 3 then 3 messages etc. My code at the moment is below to trigger the message box, hope I make my...

anyone gat any ideas on this http://www.access-programmers.co.uk/forums/showthread.php?t=126470

thanks Shadow,Ruralguy had a look at it for me but could not get it fixed either( many thanks to him):) so I ended up using a backup and redoing a weeks work (still doing a weeks work) I did try to import into a new db but it still produced the same behaviour..! :confused:

Thanks Bob

Is it possible to fill an unbound text box in a seperate form with some text "Warning.HIGH RISK" on the click event of a checkbox on a different form?

Hi everyone, does anyone know how to remove the little replication icons next to the db objects when a replica is converted back to a design master. I know there is a way cos i've seen it here before but I can't find it searching. Thanks.

thanks for the suggestions, but I have hit a bad problem which needs to be sorted out before I can procede with this utility, see my other thread that happened last night (oh my god).http://www.access-programmers.co.uk/forums/showthread.php?t=126364

Thanks guys, I am in way over my head at your decompile suggestion. i built the db on a wing and a prayer, to be honest I dont know how I got it to this stage not withstanding the fantastic examples and helpm of this forum, but its been doing what I want for 12 months and I have comercial ideas...

Thanks Roy, I will try what you suggest and get back, I am beginning to panic!

hi rural, thanks for replying. I did what you suggest but it has not mamde any difference. I am using 2003, i compact and repair on occasion but i have not decompiled, the db is not split. I would be extremeley gratefull for further advice on this. Last night I was trying to do an update query...

After working great for 12 months my db has suddenly stopped working tonight! after opening on to the first form and clicking off any field I get "Invalid Data Format" error message pop up and transfered to the code windows. Access then tells me it does not recognise the code and shuts down ...

hi Melanie, I tried that but I dont know how to get the update to automatically find the table in the remote db on the click of the update button on the form in the db sent in the email. It all needs to be automatic for the remote user as they have no experience with MS Access.

Hi, I am just about to install a database on another computer 300 miles away. The db has an expiry table which prevents access when a certain date is reached. Is it possible to update that table via an update on CD or email sent to that person with a new date so they can continue using the db...

What I find utterly amazing is how people seem to make things look so easy. How on earth do you learn this stuff? I am fairly new to database concepts and am having to fumble my way around using this forum and reading books the size of the bible. The db I am working on has taken me 7 months so...

Thanks for the reply Sprocket and your help. KeithG supplied the following SQL which works and is simple. SELECT Left([Postcode],4) AS Code, Count([FieldName]) As CountPostCodes FROM tbl_Customer_Details GROUP BY Left(tbl_Customer_Details.PostCode,4); [FieldName]= Name of the field the...

I can't thank you enough KeithG, it worked perfectly. Again Thanks very very much. What a wonderfull place this is.:D

Not sure what you mean KeithG, can you elaborate or show me please thank you for your quick reply

Hi All, Can anyone help me count postcode instances. I have a query that looks at my customers table (tbl_Customer_Details) post code field (PostCode), at the moment I have got it to strip out the right side of the postcode leaving me the left district side eg. HG12 8EN becomes HG12. I would...