Search results

Option Compare Database Option Explicit Declare Function apiWNetGetConnection Lib "mpr.dll" Alias "WNetGetConnectionA" _ (ByVal strLocalName As String, ByVal strRemoteName As String, _ ByRef rlngRemoteNameLen As Long) As Long Private Function TrimNull(ByVal strItem As String) As String...

I have password protected the back end of my split database. Works well when I re linked the front end. However, I am unable to change the links UNC using code. Do I have to live with hard directory refs or is there a tweak I need to make to the UNC code I am using. Curently when I use the...

Thanks. Thankfully I never had any issues at the hand of users. It is just some recalcitrant individuals who have some know how and try to link via Excel. If I apply a password to the back end, I am guessing that would be needed before someone links it. If so, does the FE user have to use the...

I have a split database. I have secured the mde sufficiently but I need to secure the back end so that no one could link to tables in it. If I introduce a password to the back end is this going to require those using front end to supply the password? If not then this could be good solution...

Thank you so much to all for kindly responding and contributing. We have a construction team who are required to deliver projects within 8 weeks but obviously things are different with some variation occurring to this norm. So we have a start date and a finish date and I try to calculate the...

Thanks. I think you are referring to this: DateDiff ( interval, date1, date2, [firstdayofweek], [firstweekofyear]) This is great help but how do I treat the week as 5 days starting from Monday and ending Friday?

What is the best way to calculate a week based on Monday - Friday based week?

Thanks a lot for both responses. Yes it does work off Sundays and may not be precise for the kind of calculation I want.

I am calculating number of weeks between start and finish date. Some of the users have questioned the validity of calculation as they are not too sure if this is being calculated as Monday to Friday week or does it work by calculating 7 days. If the latter is true, then I should see a decimal...

I have a 2003 database front end that I publish in 2007 as well. I always have had a small utility in my DB that helped me to automatically close the front end after certain period of inactivity (for maintenance) and it worked well. For some reason this is not working in the Access 2007 mde...

Thanks. It is a MS Access back end. I do take your point that this might denormalised. It is a huge database and not too sure how to deal with this. May be recreate the table altogether.

Thanks. The db is split. And I did recreate the form. By looking at the values in the tblnjury, all seems good because it has only one field (apart from PK and FK) and that too has a handful of records. The only difference however is that in this table there are some values that were added...

I have a safety incident form where we record an incident against a project, sometimes this incident may involve a person and when this happens we record injuries in a sub form. So have one to many relationship between projects to incidents, and incidents to persons and persons to injuries...

This is great. I may still need to refine it. Any issues. i will report but generally it is working well. Cheers

Many thanks for kindly looking into this. Yes the naming convention is quite consistent in terms of spelling. Cheers

I have a complex question. Will try to explain it. I have a query where I have listed stores and various projects that have been completed in that store as well as the date of completion. As part of the projects few things (SOW) were done to the store in its life time. So it is quite possible...

Many thanks for your help. This is all very good. Works. Kind regards

Thanks. I am not using date picker. But having no other recourse, I have created a test version of the db. Took me ages to strip it down for data. Hopefully, you could see the issue I have. In the main form, frmProjectsConstSM, I am trying to capture changes to Completion Date filed...

Thanks. I noticed that I was supposed to be showing Project ID or any other field (I tried a text field too) in the following line in addition to fields I am testing against. That was the only difference between what you have and I have. But it does not work. I don't know if triggering this...

One thing that noticed that I could not even get the sample db work even after the changes you suggested. You managed to see that work. So does this mean that there is something fundamentally wrong regardless of the db I am using? May be the right references?