Search results

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

Is acccess application close event? like thisworkbook.close event? rather before close.. 'm trying to make the event triger the code and maintain in and out from database log.... If anyone has anyidea...please help me out.... Thanks in advance:)

ted, thank you soo much for sharing this code... I have tried all resources and wont/could not make it work transfer data with multiple fields.... !!! 'm still not able to do it :( Coud you please attach on database for someone like me [including me begginer] to debug and learn.... I have...

hi lcook1974, i treid the below code from the link and it error...i'm not sure where 'm doing wrong... "Runtime error 3075" Syntex error (missing operator) in query expression 'Table2 *' Thanks again for helping... Please advice.... Sub SelectIntoX() Dim dbs As Database Dim qdf As...

Linking i think wont be very good just because if users delete data from database1 then data in database2 will also disappear...and database2 is in network drive while database1 is in personal user computer.... "Copy everything into a predesiged empty table" this may work if it can copy the...

Hi, 'm wanting copy the attachment frm one table to another...how can accomplish that... Please help if anyone if possible... Thanks in advance