Search results

Hi! Everyday I have to generate a report in excel format and I need it to be added to ms access database. I was hoping to do this on a click of a button. Basically, since i have a new data everyday it should be added to the table. Can anyone please point me out the the right direction or maybe...

Hello shutzy!! Everyone of our agent has his/her login id. Whenever they are logged unto a computer the computer username changes to their login id. To get their login Id I use this code ("I know that environ is pretty unstable). I have a list of all their login Id's together with their...

Hi shutzy!! First, Thank you for taking the time to read providing your thoughts on my post! What I meant by the "user login" is the user logged on the computer. I'm not using any login Form where they will enter their password. What I'm trying to do is add to the combo box dropdown the names...

Hello! Whenever a user opens the form then vba gets the user login and add it in the combo box row source, with this the user can only access his/her record. My problem is there are users that needs to be given access to other agents record. So what I am hoping is whenever the user opens the...

Hello ypma, Thank you very much, I just modified a bit the function you made. Me.txtbxMinutes = Format([txtbxMinutes] \ 60, "00") & ":" & Format([txtbxMinutes] Mod 60, "00") & ":00" What I do is just type the number in the Me.txtbxMinutes for example 63, it will then be formatted to 01:03:00...

Hi - I need help,i have a textbox that I put in minutes as whole number. What i want is to put in AfterUpdate Event to convert that whole number to hh:mm.... Thank you Hudas

Hi - Can anyone tell me what is this icon for found on the Navigation portion of Ms Access? Thank you hudas

Hello, I need help in creating a query using vba. I have a form with FROM and TO textboxes(Formatted as Short Date)....What I'm hoping is: 1. When I put a date in FROM textbox...the query should show records from the date selected onward. 2. When I put a date in TO textbox...the query should...

Hi - I research online and found this code, also here in this forum, i can't attach the link becuase its saying that im not allowed until i get 10 post. Option Explicit Private Declare Function GetClassNameA Lib "user32" ( _ ByVal hwnd As Long, _ ByVal lpClassName As String, _...

Hi CJ_London, Is it ok if I add this code even though I have a criteria in the query? Will there be a problem? Thanks,Hudas

Hello! I have a form with two textbox , txtFrom and txtTo that is populated with a date from a date picker. What I'm hoping the query will is this: 1. When there is no entry on both txtFrom and txtTo it should show all records. 2. When there is no entry in txtFrom and there is entry in txtTo...

Thank you! pbaldy, missinglinq and magster!!

Sorry, pbaldy...I forgot to say that I need it in VBA....I think this should be in Modules & VBA section... How do I transfer this post their?

Solved: Change back color of all textbox at the same time Hi - Is their a way to change the back color of a textbox at the same time? because i have almost 50 textbox and I want to code each textbox and change the back color becuase its just to many. Using VBA Thank you

Hello Everyone, I am Hudas from Philippines, I am new to MS Access. Hoping that you can help me with my MS Access questions. I'm happy to be a member of this forum. Thank you Hudas