Search results

Hi Colin, That certainly is a great tool. I've modified it to work on 64 bit access too. Hope it'll be of help to anyone. :) :) Regards, Margarit

Hi Arnel, Thank You for your help, I did find another solution though for that with a big help from Peter Hibbs on Uttesaccess. I've created a Yearly view as well and Peter is helping to make it as look good as possible and do my job. :) This is the file just in case someone could find it...

Hi all, I'm working on a booking system for my employer for some Chambers (Heat & Cold). I found this database on www.utteraccess.com from Peter Hibbs which is very useful to me, and I need to filter it by Chamber. I've added a dropdown but I find it a bit difficult now to filter the calendar...

Hi All, I fount a piece of code for adding Trusted Locations via Code and did a few edits. Hope it will come handy to someone. Option Compare Database Option Explicit 'Reading from the Registry: 'reads the value for the registry key i_RegKey 'if the key cannot be found, the return value is...

Thank You for the appreciation. As I mentioned on the link I'm just an amateur that loves this stuff. I'm nothing compared to you. I'm just a self taught person. But I'm pleased you are happy with my job. I'd be more than happy to have a look through your 'new issues' :) Regards, Margarit I'd...

Hi, I think this is an extra bit for 64 bit that could be handy : Option Compare Database Option Explicit Private mlngIcon As Long Private mstrHeading As String Private mstrMessage As String Private Const APP_SYSTRAY_ID = 999 Private Const NOTIFYICON_VERSION = &H3 Private Const NIF_MESSAGE...

Hi Colin, I am sure that you just didn't have the time to work on that because I'm not a professional (I'm just a newbie that likes MS Access Programming) and you are much more than that. I figured it out how to fix that issue after a couple of hours digging. Would you mind to check this code...

That's a functional code I used to use on 64bit Option Compare Database Option Explicit #If VBA7 Then Private Declare PtrSafe Function CallNextHookEx Lib "user32" (ByVal hHook As LongPtr, ByVal ncode As Long, ByVal wParam As LongPtr, lParam As Any) As Long Private Declare PtrSafe Function...

hi, have you tried the OnTimer event of form? I have used once something like this: I may be wrong but you could give it a try..

That's not the point really. The management doesn't want the back end users to make any changes because of policy restrictions during the project work. But all projects are different from each other so someone sometimes may need to add an extra Field or Command. That's all I could think of for...

Thank You JHB, That's a great Help. When the database is locked I haven't tried it but I thing it should be fine because it opens the form in Design View to make the changes. But that's another step of the process for me. Until then we'll see, Thanks a Lot . :)

Because later on during the work we may need to add an extra field or control so we can do it via code... because we're not supposed to make changes and the database will be locked

Hi Everyone, I'm trying to built up a Form where I can create Controls for other forms. Now, I managed to do this but I cannot figure out how to change the "Control Source" or the Control that I created. Can You please help me with that? Here's the Code of Command Click And a sample Database...

Thank You for the response. :) I figured it out . it should have been..

Hi everyone, I'm trying to add a button to a Form for disabling the ShortcutMenu of all forms. Is it any chance I can Realize this? I've gotten so far with the code for opening all the forms but I cannot finish it. Thank You..

Fixed it. Didn't check the Join Properties in the query. Thanks a lot. Marking Thread as SOLVED!!! :)

Hi Arnel, you just saved my life. :) :) :) Thank You very much. On the Test File the code works perfectly as I'd like it to be but when I'm trying it on my File it won't work. Am I doing something wrong?

Hi, If this is a possibility can you please explain how can I do it? Because I find it a bit difficult.. Thank you.

Hi, Thank you for your help but I'm getting the error that's attached to the photo. i'm sorry if I didn't explain very well but I'd like in the txtboxes to have the Operator Name only once. I'm so sorry to disturb you but I really need to do this. Is it any way or anything like lookup for all...

Hi, I have at least 2 users for each report. So they are inputing data. And all the data on the report appear with their initial names in each row. I want to have their names appeared on the report header in 2 different txtboxes. They are inputing at least 100 rows per report so their name will...