Search results

I have a query in my database, based on that I made Pivot table and then Pivot Chart View. I have added data labels but once I close and reopen query or filter based on page field labels are disappeared.

can you please guide me then how to add page field kind of thing in access chart similar to excel

Dear Expert Friends, In my database I have some reports which are generate based on queries and each report take input from the user such as year before it generates. for example: performance of an employee during 2016. I would like to show the same on charts. if someone wants to see the...

why when we add input mask in properties of field on the form it is not showing calendar???

How to set input mask for this type of date / time format : 14/Jul/16 12:35 I want to change it on a form level.

Req_date_time is a field which capture task receiving request date and time (such as time stamp) once we receive the task we process and obtain risk approval i.e. risk_app_date therefore, risk_app_date must not be less than req_date_time and this is what I am trying to achieve but on the...

I don't know why in the below code if the risk approval date is on same day as req_date_time it is showing my message that you cannot put less than req_date_time Private Sub Risk_app_date_LostFocus() If Me.Risk_app_date >= Now() Then MsgBox "You cannot put future date"...

yes I tried on another workstation... it worked over there... I create a new file from there and so far ok...

this bloody hell access... makes my day hell... what if there is application crash issue?? what to do?

what shall I do ? I have created another database it is working fine but the one which is corrupted it's not working at all I restarted my pc also

see the screenshot, I am seriously tired of this database corrupt issue. the only thing I did is compact and repair and after that this crap happens

I can only open this worst database that's it.. seriously... I put 4 hours to do changes and all gone in trash... yesterday also same happened. neither I can export from this database or open a new database and import. this mainly is happening because of forms

dear I am using it only on my pc that's it, it's not on network yet.

Hi friends - I don't know what is the problem, whenever I compact and repair an access database and reopen after that the database get corrupt. any idea why this issue happens

attached is the report design, appreciate your help JHB. additionally, I don't know the year and quarter showing numeric number

Dear JHD - group is in the report.. I am not sure how to do grouping in query. see the screenshots that's how I did query

Dear friends, I have a report where I want to represent data by year and quarter within that and within that the type of request and then I want to identify whether task is met or not met. attached is the sample report. I don't know why it is repeating the met and not met and not grouping...

Sorry Sneuberg, I am not expert user but yet your question shows me a path that we can make accde file of front-end directly which I was not aware of. many thanks

how to do that update in front-end only? if I make accde file from original access file it will contain tables also.

Dear friends, hope this message will find you all to the best of your health. I have a database which is split (database on server and front-end file on each user workstations), I would like to know if I want to update front-end only and do not want to split database again, is it...