Search results

Hi Paul Thanks for your swift reply Yes it is calculated from a number "number of years warranty taken" * 365 + Date()

Hi there Forum How to get about to make a form opens a new record when loaded. Really appreciate your help guys. Thanks a lot :)

Hi again jdraw & Paul The warranty is a date/time field. If this is helping to know. Many Thanks

Thanks jdraw & Paul I set up a record to add "wanranty expiry date". I just need a reminder to pop up telling us that this customer has his warranty about to run out so we can approach the customer with a reminder. Many Thanks

Hi there Forum :) Can a Form/Query warn when a date is approaching; like in a pop up or any other behaviour? :o Many thanks

Many thanks CazB. I couldn't find it and I am using Access 2013. It is quite similar to 2010

Hi CazB Many thanks for your reply. I really appreciate it. The only think that I don't know where to find Switchboard.

Hi Alex Hedley This is great. I will do it this way. Many thanks for your help

Hi there everyone I need my Database to have an access/front page that I can use it as an entrance for the user to select where they want to go or what to do after. It's like a page that I supply it with buttons to access all/most the forms in the database. How can I go about this and what is...

Hi CazB :o Sorry, I put my reply to Eugin. Actually I need to thank you both for taking the time to help. :) I do need both fields because we have installations and its then when we put name of the city in the Cities table. Then when need to service what we've installed, we'll need to know...

Hi Eugin Yes, it did work. Many thanks to you

Hi Eugine :) Its actually one ComboBox "City" and the other one is a TextBox. These fields are both from a table called "Cities". I need to select a city from "City" ComboBox and for "Province" to show the matching Province name. Its just a basic one. What is happening now is: When I select...

Thanks very much Paul. It works

Hi there nice forum :cool: The problem I'm facing is like this: I have a table called "Cities" which has only two fields; City & Province. I have connected it in a relationship with another table as "Include ALL records from 'Cities' and only those records from 'tblInstallations' where the...

I have tried the code suggested by Pat Hartman in BeforeUpdate event but it didn't work. Then I changed it to OnCurrent and it didn't have the effect I wanted it to happen. I have a date field set to =Date(), which works fine when I go to it first time, i.e. a fresh record. When I go into it...

Thanks a lot Paul I looked at the details and compared them with what's in the table but couldn't see anything strange. I also designed a query based on the table but didn't work either. I will try to start from scratch hopefully the issue will be solved. Thanks a lot for taking the time to...

Hi Paul Thanks very much for your swift reply. I really appreciate this. I've uploaded two attachments, one for the form that is based on the table which I uploaded a screen shot as well. In the record which has ID Number: 15 and in the "SerialNumber" field, when looking at the form...

Hi there community My form which is based on a table carrying same name doesn't append the full length of the text to one of the fields. I don't know where the mistake is occuring or indeed I don't know if the error is in the table or in the form. The form is showing full length of the text but...

Hi to all I am thrilled to be accepted in this forum of professionals who discuss and help the community of Access users reach their goals in making nicely working and professional databases. I live in the UK, London and work with a company selling products abroad. My role is to set couple...