Recent content by KAsad

Thank you for your suggestions. There was a peice of code hiding in a function, which was reconnection to wrong DB. I have cleared that line and it works fine now. Thank you

I have changed it to SQL and it is a little bit better. Basically, the database is on DB server and application on App server and there are 5 users. I think that I have to work on optimising the queries now:rolleyes: Thank you

Hi I have an Application based on Access database but it is too slow. If I switch it SQL database, does it improve the speed? Can I have only SQL database or does it keep the Access Database and creates a SQL version and keep data in both? Thank you

Anybody can help me please?:banghead:

It is a very simple database with a few tabless. I have a mdb which contains all tables lets name it as {kati Files.mdb}, then I have another mdb named {kati.mdb} which has link to the tables in {kati Files.mdb} and it also has all forms, query and processes. The files on server are {kati...

I have 2 copy because one should be on live server for clients to use it and one I have in my local PC as I am continuously changing the forms, process.... So I develop forms in my PC and then transfer it to the live one. Hope it makes sense Thank you

Hi I am new in MS ACCESS coding. I have an application works based on ACCESS database. I have 2 copy of the application, one localy in my PC and one in anoher server. If I log in to my local PC, then log out and log in to server copy, it still looks for my local database. I can not understand...

Thanks a lot. It works if I copy the SQL query to the form as you have said. It is very odd!! Again thank you

When I run the query, I get the pop up which asks for the value of [Forms]![....] and when I put the details, it works fine. So I was assuming when I click on GO button in first page which calls teh second page, the value of [Forms...] are still somewhere in memory and by using the [Forms]...

Thank you for your reply The form is open and the query is a separate query that I have created in query wizrd and then attached it to form as datasource

Pass data from a Form to another form Hi I have a form which I ask user for date from, date to, and Pratice. Then I want to pass them to second form which is based on a query. I want to use the items from the first form to filter the query for the second form like this SELECT DISTINCT...

Pass data from a Form to another form Hi I have a form which I ask user for date from, date to, and Pratice. Then I want to pass them to second form which is based on a query. I want to use the items from the first form to filter the query for the second form like this SELECT DISTINCT...

It is only one form which shows all timesheets. In each line, I have timesheet ID, date and I need to show a delivery month which is based on a calendar. If the timesheet date is 01/05/2012, then the delivery will be May if it is 29/05/12 then the delivery will be June.

Yes, I have checked the link but I have missed the point that I have to put # for date field. Now I have changed it to =DLookUp(" [CALENDAR]![FIN_MONTH] ","[CALENDAR]","[CALENDAR]![FIN_YEAR] = " & DatePart("yyyy",[Forms]![frmFinanceCheckTimesheet]![TIME_DATE]) & " AND [CALENDAR]![FIN_START]...

Thank you , I have changed it to this =DLookUp(" [CALENDAR]![FIN_MONTH] ","[CALENDAR]","[CALENDAR]![FIN_START] <= " & [Forms]![frmFinanceCheckTimesheet]![TIME_DATE] & " AND [CALENDAR]![FIN_YEAR] = " & DatePart("yyyy",[Forms]![frmFinanceCheckTimesheet]![TIME_DATE])) but it does not return any...