Recent content by bally3

Am trying to import records from my Access tables into MySQL database but keeps stating cannot find files as only looking for csv files?:banghead: Any ideas why?

Hiya Dave Yes it is just over the 2Gb mark, does that present a problem? Have taken info into new tables etc and have compacted and repaired on two occasions, still did not work. Pulling hair out at moment. Thanks for info. Best Regards Ian

Hiya Have large database of companies, over 3.7 million but when trying to paste new records into table get error message now stating "unrecognised database format........etc etc." Have original table linked but have tried both ways of pasting records and all without success and am now at...

Hiya You have read all post? I do not mean just changing colour on form etc as know how to do that but change when certain conditions alerted such as trying to gain entry to club when fees not paid etc. So still know how, if so then please send info and I will be friend for life. Best...

Have only used this when changing form colour for different types of forms for id purposes etc - did not know about the run time change so will have look at this. Many thanks Ian

Hiya I have found best way is to have tick box inserted into each customer form and then just tick ones that you want to print. If you look further down these posts you will see that one new member has even sent in some code that enables all boxes to be checked or unchecked (have not tested...

Hiya Is it possible to change background colour of form if member has not paid fees for gym or sports etc so that staff can identify who has and has not paid and so restrict entry? Am in middle of developing dbase for gym but client has now requested that members forms change colour when...

Hiya Access2000 and am running XP Home. Nothing else on that line and one above and all controls are set to CanShrink = Yes, with CanGrow = No Stumped and grumpy Ian

Nope - have tried that as well as Chr(13) etc, nothing works and blank line appears in some letters. Thanks for help anyways Best Regards Ian

Bob Saw your post re Can Shrink etc and can confirm does not work as I have same problem and have just posted. Standard report just prints out and leaves empty line between one part of address and Town i.e Insulation Components Whatever Street Wherever Alley Sheffield S1 3NN Cannot...

Hiya guys - new to this so bear with me - have report which has 3 address fields as well as Town, sometimes address 3 is blank, sometimes not, depends on length of address. How do I make report shrink the empty line as have tried Can Shrink as well as Chr(13) and Chr(10) etc without any joy...