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
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...
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...
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
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!
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
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...
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...
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
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...
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...
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???
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.