Search results

Dear All, I have a database which I have divided into front end for multiple users and backend (I.e database) on a shared server. This shared server is managed by IT team and the folder where I have database we have read and write permissions. we are around 10 users of this shared database...

Dear Expert friends, i have developed one application for my friend using ms access 2010 and on windows 7 Professional platform. When i sent it to my friend he couldn't open it due to the following error (see attachment also) "The database cannot be opened because the VBA project contained in...

Dear All, i have a query which is getting generated (byBusno) and i have a form (ByBusNo) where there is a drop-down and showing bus number based on the query. i dont know why in drop down duplicate numbers are appearing plus when the report (Routeinfo-busno) is generated it is not getting...

Dear Expert friends, i am working on a database and would like to give this to someone in executable format, i want to know how to make such an executable file. Also what if the user will not have ms access installed on PC. Note: this database will be utilised by multiple users, i am planning...

dear friends - if i want to change the color of a text box to light grey based on when someone click save let's say .. how do we write the color combination in vba code

how to check in ms access vba whether a date is between 2 dates

Bro - you are simply access genius ...

Dear Arnelgp, thanks for your support to make these 4 queries, how i can show this as one record because there is repetitions also

True I am not interested to save expiry .. I just want user to know that the id/passport/license .. whenever one of it will be expiring in coming one month the user should be notified

Dear Friends, I have one table where i have multiple expiry fields, i would like to see the records which will be expiring in coming one month. So for example, in one record i have all these different dates if one of the date is even falling in the criteria (i.e. expiring in one month) the...

Dear Expert friends, i would like to ask one question, I have multiple dates in one table and i would like to check if one of the date is going to expire in a month then only the query will show the result. Can someone please advise how to do that.

Yes .... Resolved ... many thanks mates

dear please accept my sincere apologies, i am in rush and plus newbie in that. yes you are right the report is RouteInfo-Area and the form name is ReportByArea. I want to select the area from the form ReportByArea (there is a drop down), but the report is not filtering the record based on...

I am trying to filter one report using a combo box on form, however, the report is showing as blank can someone please help urgently i am attaching database also. please let me know what mistake i am doing i have seen videos uploaded for the same with them it's working, i dont know i am doing...

Resolved just now ... here is the way Between date() and dateadd ("m",2, date ())

How can I do this in access query... sql view is completely different

Dear All, I have a date in the table which is a future date i.e. "Next_Review_Date", this table contains several records. What I would like to show is that only the records which are due in upcoming 2 months. For example: an item is due for review on 28-August-2017, it should appear in the...

Minty bro resolved - actually I overlooked one thing. I had some data existing so what was happening the date let's say is mentioned 01/01/2016 the moment I click on the calendar I was selecting 15/08/2016 and didn't notice the month... offcourse system will not then tell me it's a future date...

well I have use validation rule and validation text for now... God knows why it's not working

no it didn't work... I am really shocked. I did the same thing on another form but I don't know why in specific on this form it's not working