Search results

Hi Everybody !! I am Pawan Joshi from Jaipur, India. I am back here after a long time. I am not a professional programmer and am engaged in a non-IT job. Though Access, Excel and VBA programming are my favourite subjects, still I am a greenhorn in Access. This great forum has given me a lot...

Hi EveryBody! I am struck in a query that would return records of employees who are retiring i On a given Date ii Before a given Date iii Between two given dates. The Structure of the the input table is as below ( I have simplified it for the purpose in hand, actually it is a query based...

Hi EveryBody, I am trying to write the SQL-text of all my queries to a text-file using the following two functions - Sub Query_Print() 'This procedure would write SQL-text of all queries in the current database to a text file Dim db As Database Dim tbl As TableDef Dim qry As...

Hi Everybody! I am puzzling over to convert my Access-2007 database-tables (but not other objects) into Access-2000/Access-2003 database. Can somebody guide me! regards, P K Joshi

Hi Everyone, The query below shows syntax error in FROM clause in Access-2007 - SELECT * FROM q_StationWiseTR_Final UNION SELECT * FROM q_StnPosted_NotFilled_TR-Form ORDER BY SeniorityLevel, StnName, IfWantTransfer DESC , Remark; -- Both the SELECT * has common/same fields. Access does not...