Search results

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

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) &...

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

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

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

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

Setting a Field Sort for a Table???? Hi All, I have a table that is created from a user input form. This all works fine. How can I set the PaxNo field to be sorted first. The example below only creates one field, but actually about 7 fields are created, however i need the first field to be...

looping through a Form and deleting all controls! Hi People, I have a manu form which has a command button. When the button is press it should open a form called FrmBank2 and delete all controls on the form by looping through them. The problem is only 6 controls (textboxes) get deleted and...

Help With Date Criteria!!!!! Hi People, I have a simple date problem, and was hoping for some help please. Basically I have a table with a flight schedule . The flight schedule lists flights operating for a season normally 6 months. The schedule has a StartFlightDate field and an EndFlightDate...