Search results

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!!!

No to be honest i have not. I was thinking about using a query, but the recordset being updated will get quite large overtime, and i was thinking that a query will become slower as the recordset grows. I would imagine the recordset to go over 200000 records. So my thoughts were to use DAO?. But...

Still will not work!!!!! I think i better explain what i am trying to do may be you can just sort the problem - Here goes for the explanation -: I have Db with two tables. a) TblDailyFlightSchedule b) TblDailyFlightPaxHistoryLog The TblDailyFlightSchedule is created from a make...

Sorry tried the fix but it does not work Hi All, I tried putting the Hashes in as suggested, but the criteria does not find the correct records that match. Any ideas on how to build a search criteria that searches for a date and string??? Thanks Kango

Hey!, Thank you very much for doing that, I am just pasting the code in my procedure. It look's like it is going to work. I will post back if i have a problem. Thanks again much appreciated!!! Kango

Hi All , I have the following criteria StrCriteria = "DepartureDate ='" & StrDtConv & "'" & " And " & "FlightNumber ='" & StrCriteriaMatch3 & " '" It does not work because the DepartureDate Is a date field. I think I need to put some #’s around the StrDtConv, bit but I do not know where they...