Search results

Dear All, I just tried to share my database to another PC where I put my database in shared folder but when I tried to open same database from another PC message popup like "could not lock file". Any idea? Appreciate your response.:confused:

Thanks James, I can redesign the table but how to design? as I have 6 values need to show on a different dates. Please advise.:confused:

Thanks James & DCrake but I need to update values every week which I am updating in simple Query. It's not a crosstab query. Please see attached table structure. Please advise. Is there any way to count values directly from query to form??

Dear All, Please help me out re the attachment. I have a query with Name "PSBD Processor Query" and I want to show the value of Query in the main form. Is there any way to make it possible??:confused: Looking for your favorable response as always. Thanks in advance.

Dear All, Please help me out re the attachment. I have a query with Name "PSBD Processor Query" and I want to show the value of Query in the main form. Is there any way to make it possible??:confused: Looking for your favorable response as always. Thanks in advance.

What are the things required to prepare Risk Assessment database. Also please do let me know if there is any sample for the same. Appreciated.:p

Try to do like this, DateDiff("m",[StartDate],[EndDate])/365

Yes Khalid now its working as I missed out "then" :D Thank you guys for your help as always. Appreciated.

Hi David, I tried somhow like this but didn't work. Private Sub Form_Load() If Date() >= #3/29/2010# MsgBox "Your License for this product has expired", vbCritical + vbOKOnly, "Access Denied" DoCmd.Quit End If End Sub Please advise.

Hi David, How to set the AllowByPassKey to False? Please advise. Totally confused.:confused:

Hi DCrake, This is my own database and it will not take me anywhere to legal action please don't take it serious. I am just looking for a help from you guys if you have something. My intention is to know only if there is any code for that one. Do you have something? :p

Hi Dcrake I just want to disable my database while I am leaving :p, for that reason only I am asking the same. Khalid it's not that matter :D If you guys have something (magic code) please do let me know.

Thanks Ghudson & Access guy, my concern is do we have any code from which we can corrupt the database after some periods? Please advise.

Hi Is there any code which can deactivate whole database after certain period (like after 1 month / or 6 months). Please advise.

DCrake thanks a lot but I don't have an Idea how to do that. Please advise.

Hi I have a time sheet database (attached) I just want to design report like report (attachment report). I tried a lot but unable to do that. I just want to show those ID no's only in report who was entered as "N" and "OT" in attendance field. Please advise. Looking for your favourable...

Hi thank you very much for the response. I got it but I have more than 80 different sites like DIFC. As per the statment it will filter DIFC only. So what about other sites which is in my sites list? how to put if statement for all sites. I want to check for all sites whatever I have in my...

Thanks for the response but I am having more than 80 sites so how to put those whole sites in if statement. Please advise.:confused:

Thanks for the quick response. I know the Dcount function but there are more than 80 sites so how to put an If statement for all 80 sites. Please advise.

I have an employee Database with me with so many fields where there is one field name by sites containing more than 50 sites (drop down list) and I have a approved manpower numbers for each sites like eg. DIFC sites 50 manpower. I am feeding each employee record in database and allocating them...