Recent content by Kango

Alt F11 brings up the code window with the menus, but i still can't get the normal menus up ? Would be very grateful for some pointers. Kango

Yes, this is a genuine copy of Access, (office pro 2000) All the other apps Word Excel Powerpoint Outlook work fine, it's just Microsoft Access ! I am opening a MDB file . Any Ideas ? Kango

no still don't get the menus !

Hi, I have installed Access XP still the same problem , but opens ok in safe mode, which is no good, Access 2000 is completely blank, Access XP is also blank, but if you hold down the Ctrl key it opens in safe mode with the menus? any bright ideas! Kango

Hi Ryan, Looked at the thread tried all what was suggested , still no luck. holding shift key does not work either. Any ideas ?

Hi People, I was woundering if some could point me in the right direction? when open any database the menus (File , Edit View etc ..) have all gone, i just get a blank screen, not sure what is going on,even the toolbar is gone. any ideas, i have tried to reinstall Access 2000 but still the...

thanks... Hi there, Thanks for that, it worked ......... Very appreciated.... Kango

Hi People, I have some code running the following SQL statement. rst.Open "SELECT tblDaysOff.VacDate, 11 AS Colr, tblDaysOff.staffid " & _ "FROM tblDaysOff WHERE (((tblDaysOff.staffid=" & Chr(39) & Me.cmbEmpName.Column(1) & Chr(39) & ") AND " & _ "(Year([vacdate])= " & Chr(39) &...

Hey, Thanks for the speedy reply. Work's fantastically ! Much Appreciated !!!

Hi All I have a table with names of machine parts ( which have been imported from another db) only problem is some records have '*" at the end which i want to delete. How can i search for and '*' and then delete it from the string so for example: Record 1 = 'Bolts*' Should be 'Bolts' Record 2...

Problem!! Hi Rich, The tables are created in the fly. So i wanted to use the form textbox as validation can this be done? Thanks

Hi People, How can I limit the number of characters to be inputted into a text box to 8 eg:abcdefg8 . The field will be a mix of integers and letters. Would be grateful for your help on this one !!! Thanks

Hey! Thanks for doing that. I am just using the code now, will hopefully work!!! Thanks Again!!!

Hi All, How do i through Vba count the number of controls that are in my subform?. I am sure this is easier then it sounds? Thanks

Ok will give it a shot!!! Thanks!!!