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!

  • Congratulations IamaSherpa 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: *

  1. sansangtracao

    Why I cannot add an appointment in the MS Outlook Calendar

    This is already driving me mad for a couple of date. Out of the blue Outlook stops to add apointment in the calendar. Can someone help me out as to how I can fix this pronblem? Thanks a lot
  2. sansangtracao

    How to create menu bar from a macro

    I'm kind of new to MS Access, now I'm trying to create a custom menu bar in an Access Application with 5 Menu Items: File, Search, View and Print. I already created a macro named MainMenu with those items. The question is: How can I add the sub-items in each 5 above mentioned main Items? Any...
  3. sansangtracao

    How can I do this sort of relationship?

    Hi traigamer, actually the event can take place only in one city of a country! I managed to put the events to a country but cannot link the cities to that country but the difficult part is that on the report the country is displayed well (with names in text) but the city always appears in...
  4. sansangtracao

    How can I do this sort of relationship?

    I have 3 tables: events, country and city. Several events can take place in a country and in different cities of that country. Question: What kind of relationship I can build here??? Thanks
  5. sansangtracao

    Proper case in a field

    Hi, I'm kinda dumb in the MS Access and trying to put things together. Can you tell me m?e about this?????
  6. sansangtracao

    Proper case in a field

    Please tell me what code to be put on a field that on exit every thing will be in capital case? Thanks very much!
  7. sansangtracao

    How to handle date without alter the sytem date format

    Thank you very much. Here is my solution for now: let it be in the format like this: dd/MM/yyyy on form, but on the report it will be dd/mm/yyyy (since all my employers can somehow understand English) Damn Microsoft anyway!
  8. sansangtracao

    How to handle date without alter the sytem date format

    I tried this code on the AfterUpdate event: Private Sub OrderDate_AfterUpdate() Me.OrderDate = Format(Me.OrderDate, "dd/mm/yyyy") End Sub This still does not work. Please tell me what's wrong with the code? Thanks
  9. sansangtracao

    How to handle date without alter the sytem date format

    Yeah, now I can understand what you guys are trying to explain to me. But what I'm trying to do is this: an user can put in the date as dd/mm/yyyy (1 March, 2007) without MS Access automatically reverse the date back to mm/dd/yyyy (3 January 2007)! And I'm not sure why it always reverses the...
  10. sansangtracao

    How to handle date without alter the sytem date format

    Thanks MajP, can you tell me more about the solution? where do i put this "?format(cdate(39472),"dd/mm/yy")" expression?
  11. sansangtracao

    How to handle date without alter the sytem date format

    Hi, thanks for the helps. Maybe I still have not put the question in a clearer way, here is the problem: I want users to put date in the field [orderdate] in the UK format (dd/mm/yyyy) no matter what their system date would be. I already put in the fomat property of the field the desired format...
  12. sansangtracao

    How to handle date without alter the sytem date format

    Thanks for the tip, however it still does not answer my question, and my question is just what do i put in the 'format' field of the properties of the field so user can put in a date with dd/mm/yyyy format. Thanks
  13. sansangtracao

    How to handle date without alter the sytem date format

    I have a date field which I want to put Date in with other format (dd/mm/yyyy) and I dont want to alter the system date (mm/dd/yyyy). I already put in the property sheet of this field the new format (dd/mm/yyyy). What happened so far is when i put in 01/03/2008 (January 3, 2008) it always comes...
  14. sansangtracao

    How to do this kind of relationship?

    Thanks Dhookom, I did not think of that solution
  15. sansangtracao

    How to do this kind of relationship?

    I have a table with "Employee Name" field, I have another table with "Customer" field. 1 Employee can handle 2 Customer, on the other hand, 2 Employees can share 1 Customer (in a special case). Question: how to handle this problem with table and relationship ? By the way, Employee and Customer...
  16. sansangtracao

    Is this possible with MS Access ?

    Thanks, You guys are wonderful! Now I have some idea how to approach this problem !!! Thanks
  17. sansangtracao

    Is this possible with MS Access ?

    Thanks Zameer, It's still not answered my question. The question is that with quite a large ammount of text (not the format of the texts), how large the Accsess can handle? in one field, i.e "memo" field???
  18. sansangtracao

    Is this possible with MS Access ?

    I'm working for an office with a lot of data to be stored. The problem is the whole data is beiing stored in the form of TEXT which is very difficult to review and to track, therefore I intend to put the texts into several categories and using MS Access to manage. However it is unescapable that...

Part and Inventory Search

Back
Top