Recent content by khwaja

I used to have a code to close the database itself after certain time. That worked well. But there were instances that this did not happen due to user closing the laptop or db being hung. Then I resorted to using an excellent code by MS which allowed me to shut the database completely. But I...

After checking over night and seeing that file has bloated, I find it quite unprecedented as running of queries was always there but it did not blaot at this rate. could there be any other reason? This file is being access through network drive as well as citrix and we have had some network...

Thanks. There are indeed a couple of queries users are running. That might be an issue.

I have a MDE file which constantly keeps inflating in size. I did not notice this before as I used to republish this with a new copy. But over a period of 3-4 days, the size increases from 16 mb to 30 mb. Is this normal or should I take some steps to prevent this occurrence.

Thanks. I have amended the code since last post and in the light of Cronk's suggestion. It seems to be working OK unless there is further improvement that can be made.

Yes, the passed values are from 4 fields in a table. I changed the if statements as suggested and looks like I have the result I need. However, the suggestion around setting default value to zero is something I need help. Is this set as part of the variable declaration or should I be declaring...

I have 4 fields which have certain dates in it. Each date (regardless of what date it is) signifies the rate of progress. So I have following rate: Survey ordered: 60% Layout Ordered: 30% Signage ordered: 5% Refrigeration ordered: 5% I would like to sum the percentages depending on the dates...

OK thanks.

Thanks a lot for the clarification. I have amended the code and it should only returns text values. And I am using following in the query where there is a calculated field 'SurveyDue. SurveyAlert: get_SurveyStatus([SurveyDue],[surrecvd],[spedateord]) I am still getting the same runtime...

Plog, Thank you so much for being patient and the kind guidance. If I use the function in my query, how would function know which fields it has to relate to in conjunction with variables names? The syntax for function you provided refers to actual field names. In the body of code (the...

Thanks. It is Runtime error '424': Object required. Code stops at: ElseIf SurveyDue < Date And [SurRecvd] Is Not Null And IsNull([SpeDateOrd]) Then

Could you kindly look at what I have got here. It is currently not working as I am getting object required as runtime error.

Many thanks. I will give it a go.

Thanks Spikepl. I tried to change statements as you have described but i still have the same issue. Plog, could you guide me constructing the function. Just a couple of lines will get me going.

I am using a query to feed to report. In this query, I am using following field to provide category statement to serve as report groups. It works fine but I cannot seem to get rid of null records. When I try to exclude null records, I get a parameter prompt for 'survey due'. All other...