Recent content by Ravensleach

Thanks kvj, I will keep it in the old format until all users have the same version ... which could be never ... appreciate your input.

Hi I have an .mdb database created in Access 2000. The backend is on a networked server and we have customized frontends. Users are currently using Access 2003 but I am about to start using Access 2010 (new computer) and the main other user will remain with 2003 for the time being. There...

Thanks jpadie, you are a star

I'm trying to list an array and where the date field is less than 10 days ago, flag the record as "new". Can anyone tell me why this isn't working? <? $query = "SELECT date, name FROM tbl_onepagers WHERE fktheme = $id OR fktheme2 = $id OR fktheme3 = $id OR fktheme4 = $id OR fktheme5 = $id OR...

Works great, thank you so much Vacunita. Just have to get rid of the $ now!

Here's the code: $data = mysql_query("SELECT boat_name, charter, shared_cabin, child, single_cabin FROM boats INNER JOIN cost2009 ON boats.boat_ID = cost2009.BoatIDfk") /* try to replace 0 with contact us, otherwise $value on charter, shared_cabin_child_single_cabin */ or...

I have a query which produces a list of products and prices (four price fields for different versions of the same product). Prices are type DECIMAL field. Where there is no known price it has the value 0. When printing to the page I would like to replace these 0 values as "<a...

It was a network permissions issue.

Thanks jkl0. I checked all that and all seems well, with the underlying query showing results, but the form is still a complete blank. Maybe Access2007 uses a different code library for reference? I did make the db in Access 2000 so it must be due for a change. Here is the Visual Basic for...

I created a small database which is on our internal server, in Access 2000. A colleague has Access 2007 with Vista OS and at first couldn't get into the database at all. I made her her own front end by using the original forms, importing the queries, modules, macros, etc and linking to the...

I am struggling with this too and found this: http://www.lebans.com/richtext.htm#ResizingCode I haven't tried it yet because my client is thousands of miles away with no tech support on the spot, but I'd be interested to know if it can solve the problem in a non-distributed db

Hi Aceman1 Thanks for your reply. It took out the extra commas, but it also took out the whole of the Address field too!! Weird because I can see the logic of your code ... tried both lines separately, but same effect. Result: 1984 BEAR, Pooh, S10 4JP. Tel: 01284-56789; 09876-54321(Work).

Hi PHV Tried it instead of the strAddress = rsHBData.Fields("Address") line of code and as well as it, but still the same result - double commas :-(

Ok, thanks, here it is THIS IS WHAT IT LOOKS LIKE NOW 1984 BEAR, Pooh, 410 Main Street, , Someplace, , Newtown, , Sheffie S10 4JP. Tel: 01284-56789; 09876-54321(Work). 1990 A BELL, Tinker, 1 High Street, , Anytown, , Somewhere, , Preston, , Lancash PR2 0EH. 1958 BROWN,A., 1 High Street, ...

Ok that didn't work. Is there any way to send you a zip file? Thanks