Recent content by trksbc

Hi, I have an Access Macro (works in 2003 & 2007) which connects to external servers to download data and execute queries. It takes approximately 25 minutes for running all the pass-through queries and internal queries. When the connection is slow, I get an ODBC call failed error. I increased...

Hi, I have a query which takes an input from the user and gives required details for that quarter, like Week ending date, month, etc. When no quarter is selected, the query result is blank. I want to introduce a validation wherein the user is forced to enter a value, and blank value is not...

Hi Guus2005, Thanks a lot for the solution. This is a small part of Complex MDB which gets data from external servers. The dates in this created query/table are read during macro execution & data is fecthed accordingly. At present I was populating this manually, but now with your help it is...

Hi, Thanks everyone for looking in to this. I think, I have not been able to express my requirement completely in words. Hence I have attached the MDB with required result & current query which I developed. "Required_Table_Current_Qtr" is the required result "Master_Week_Ending" is the...

Hi, I have to create a select query (which I think is a bit complex). I have to retrieve Week, Year and month from a Master table. I find this simple. Apart from this I need to find the starting date of a particular month and last date of the particular month for the respective month. The...