Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Husameddin
  • Content: Threads
  • Order by date
  1. Husameddin

    How to prevent the user from writing in a SubForm

    Hello everyone I created subforms from queries so that the queries will appear in the subform, the problem is that I am afraid that the user might write something in the subform and that might affect the queries and the form will give the wrong result or miss up the database and thequeries, so...
  2. Husameddin

    How to search for the first part of post code using parameter Query

    hello guys I am using Access office 2000 and I want to set up a parameter query to search for the first part of any post code, the post code is written like (W2 4JL) and I want when I enter the first part of the post code (W2) be able to get the whole post code, I want to use parameter and I...
  3. Husameddin

    can anyone explain this VBA code to me please

    Hello everyone Can anyone explain this VBA code to me please? Function GiveColour(Years As Integer, Rank As Integer) As String Select Case Years Case Is>25 If Rank=12 Than Answer=”Blue” Else: answer=”Black” End If Case Is>15 If Rank<21 Than Answer=”white”...
  4. Husameddin

    Error Message in access says someone uses the database,and no one does

    Whenever I want to update my database I can’t save any changes to it and I got this message &quot;you don’t have exclusive access to the data base at this time&quot;.or you can't save. anther user has the file open and i must have exclusive access to the file Anther icon appears in the desktop...
  5. Husameddin

    Error Message in access says someone uses the database,and no one does

    Whenever I want to update my database I can’t save any changes to it and I got this message &quot;you don’t have exclusive access to the data base at this time&quot;.or you can't save. anther user has the file open and i must have exclusive access to the file Anther icon appears in the desktop...
  6. Husameddin

    Problem with IF, False. VBA code (Access).

    I am using Access and this VBA code Cancel = False If ([Type] <> &quot;Cruiser&quot;) Then MsgBox &quot;Error You can only use Centaur Or Cruiser in this Route” End If i want the code to give error message if the user enter Cruiser or Centaur i tried with (Or) but did not work. i used the (,)...
  7. Husameddin

    How to link 2 dates, if I enter one date the other appears

    I want to create a form of bus maintenance record, and this record must indicate clearly the date of the last and next service inspection, I have table of the maintenance schedules and I know for example that bus A must be serviced once every month, so I want when I put the date of the last...
  8. Husameddin

    How to link 2 dates, if I enter one date the other appears?

    I want to create a maintenance record for buses (for example). for some buses the maintenance is once every month and some is once every fortnight. What I want is, when I enter the last date that the bus was serviced, the next maintenance date appears automatically. Please help me

Part and Inventory Search

Back
Top