Search results for query: *

Hi Dhookom, With some help I have managed to get the problem sorted. thank you for your help kind regards, Murtadau Gabier

I am testing it with my own machine at the moment. If I change my permissions within the Employee table to "Coaching Logger" then it allows my access, but if I change myself from "Coaching Logger" to "Administrator" within the Employee table, it ignores that portion of the code and then gives me...

Hi dhookom, Thank you for the advice. I have now tried your bit of code and I get the same result. The code only looks at "Coaching Logger" and ignores whether the User could be an "Administrator". Any thoughts on why this could be happening. kind regards, Murtadau Gabier

Hi Ben, I have tried that, and it still only takes the "Coaching Logger" into consideration. I have even tried removing the portion of DLOOKUP script away before the "Administrator" portion so that it would be "Coaching Logger" And "Administrator" but none of this wants to work. Kind regards...

Hi Guys, I am having a bit of difficulty, I am setting up an error check in my coding where if the User does not match 2 criteria they will not be allowed into the database. Can you please help me, I am pulling my hair out of my head over this. I will show what I currently have below, this...

Hi Everyone, I know this is not a challenging one for you but I am really having some difficulty with this. I am trying to calculate the total time spent on a task but it seems that the SSRS statement I am using =FORMAT(TIMESERIAL(0,0,(sum(Fields!AHT.Value))),"HH:mm:ss") does not go over 24...

Hi guys, sorry for only replying now. Thank you for all the suggestions. We managed to come up with a solution. What we ended up doing was to move the agent loop to the end of the script and we moved the execute before the agent loop ends. so the loop continued running and giving us a new...

Hi guys, So I am close to getting my database up and running. Need a bit of advice on how I can get my form submit macro to loop through 2 listboxes. Let me first break it down. I have some comboboxes and some text fields and 2 listboxes. As is the form works, but only allows for 1 selection...

HI PHV, I was going through each line and saw that. Thank you very much for your help. kind regards, MG

Hi Guys, Have a bit of a problem with a script I am trying to run. I am asking my script to run through a list in the current form but the script cannot recognize the form. the script looks as follows. Form name is "Coaching and Training Logger" Private Sub cmdSubmit_Click() Dim...

Hi guys, This is my first post to Tek-Tips. I am fairly new to the VBA scene. This is my first real app that I am creating in Access. have run into some troubles with my VBA script to submit the info selected on the App form to the table provided. I have 2 list boxes where I need to provide...

Thank you Skip, will be sure to do that.

Hi guys, This is my first post to Tek-Tips. I am fairly new to the VBA scene. This is my first real app that I am creating in Access. have run into some troubles with my VBA script to submit the info selected on the App form to the table provided. I have 2 list boxes where I need to provide...