Recent content by pedie

CJ_London, thanks for helping it is working now....

CJ_London. thanks again for correcting me there. Since is is late now and 'll try this tomorrow. and post back. Good night!

thanks again CJ_London! the current query I have applies filter and check if users exist in table1. however if i want to add table1 additional fields to the query it stops to work. Is there a way to link and return additional fields from table1 corresponding to table 1 users records but only for...

This sql is giving the desired result. Is this query going to be slow with more data? Please advice. SELECT Table2.users, Table2.mydate FROM Table2 WHERE (((Table2.users) In (SELECT Table1.users FROM Table1 GROUP BY Table1.users, Table1.mydate HAVING (((Table1.mydate)=#1/1/2013#)))) AND...

Hi CJ_London, thanks for quick reply. I have two sample table table1 ID users mydate 1 user1 1/1/2013 2 user2 1/1/2013 3 user3 1/1/2013 4 user4 1/1/2013 5 user5 1/1/2013 6 user1 1/1/2013 7 user2 1/1/2013 8 user3 1/1/2013 9 user4 1/1/2013 10 user5 1/1/2013 table2 ID users mydate 1 user1...

Hi Everyone! How to return data from table1 only if table key matches table2 key. I tried this but doesnt return me the data i want. SELECT A.* FROM tbA AS A INNER JOIN tbB AS B ON A.[ keyfld] = B.[keyfld]; Regards, Pedie

Mark, thanks again for the usefull advice!!

Hi, can someone help me to Loop and add names to combobox in FrontViewFr. I want to find enrivon("Username") in table_EmpInfo, Emp_Ids field. if found then my next critiria x will be Manager_ID in Manager_ID field, now i want to loop through/maybe some sql etc then add name to my combo which are...

Hi Ted, i really do need your help with the Multi-Value thing you posted/shared... 'http://www.access-programmers.co.uk/forums/showthread.php?p=1087112#post1087112' I have 3 Fields Table and want to transfer all the attachment in the records to different databse same kind of table... I have...

spikepl, thanks for helping out still wont work....i read the instructions still dont know but it still wont work for me and the link you attached below is different...

I exactly tried this way nothing happend when i close my form... It did not disable my form from being closed/by clicking on X.... Thanks again Private Declare Function apiEnableMenuItem Lib "user32" Alias _ "EnableMenuItem" (ByVal hMenu As Long, ByVal wIDEnableMenuItem As Long, _...

Hi, one more small problem... I tried this way and tried trigerring code on unload the code runs and does not end....and then the access file stops responding....everytime i close the database.. Please advice Thanks again Private Sub Form_Unload(Cancel As Integer) Call LogMeOut End Sub Sub...

Hi please help me with vba to prevent ACCESS 2007 Form from Closing Though X but only through Exit button. Thanks

lagbolt, thats perfect thanks alot!!! What if i want to unhide at anyppoint of time?

Thanks for the idea.... I tried this way form does not get hidden... Option Compare Database Option Explicit Private Sub Form_Close() 'close activity? End Sub Private Sub Form_Load()'start up form Me.Visible = False 'DoCmd.Close DoCmd.OpenForm "Login Dialog" End Sub