Recent content by Nvijayk

Hi Just another way perhaps if I understood the requirement. I assume in the query design you would have typed in the criteria box under the Date field ' Between [Start Date] And [End Date]'to apply the parameter. If this is the case, in your report you can, in the header, add 2 text box...

Hi Sorry to butt in. Have you tried switching off the warning message facility by dechecking in the Tools/Options/EditFind? There is a Check box for action query as well. However, I find that even if you turned this off, it still pops up warning messages when the database is operated in Acces...

Hi Jeff Works perfectly.Many many thanks.I opted to make a temp table as I did't fully understand your first option of .dot etc/ loop method. Cheers Vijay

Hi I have a table for enquiries from customers and I populate this through a form.I have a field ( combo getting its values from Categories table) for category of product under enquiry. I have a separate suppliers table with a field for category to query it to get list of suppliers under the...

Hi I used the Packaging wizard to create a package for an application in MS Access. One of the users does not have MS Office or MS Access. The package has been copied in his computer. When he tries to run the setup from the package to install the application, the following message comes up: VB...

Dear Robert Very useful advise indeed!!The backup works fine. Is there a way I can restore the stored data from a command in the form with overwrite facility. That utility I downloaded does not seem to have this facility. Incidentally, the site you suggested have many more useful things of...

Hi My Access runtime application is a very heavy file( 160MB).The database file itself is only 10% of the file.Could someone advise me the way I could install a back up and restore procedure for the users from the Switchboard they can hold just the data in a floppy or a couple and restore in...

Thanks a million Bruce! Shall revert if any problem Regards Vijay

Hi I need to update a field ( TransactionDate)in a row selected by a criteria ( TNo = '4') in a table (tblM)as when there is an update of a control ( StartDate)in a form which populates another table (tblCompanyinfo). I tried this. On the AfterUpdate property of the StartDate control on the...

Hi Josh Many thanks for the response. Incidentally I had already had a look at the help but was still unable to figure out what exactly was to be done in query No.2. I tried a few things but nothing worked. Could you please let me know what exactly I should do in query No.2 in either QBE or SQL...

I have a table and one of its fields( account heads) is populated through a form which has a combobox from which a selection is made. I have a select query (No:1)working on a parameter input by the user. (Which account head?). Whenthe query is run for a particular account head and if the...

Dear BK I have now tried your solution and it works as follows. When an invalid date is entered, it throws a message and if I clicked okay, it then just carries on and allows me to complete the form and save it with the invalid date in the table.I need it to stop me from accepting an invalid...

Kind Attn: Danvlas Many thanks for your response. I tried it and it works fine. However, when there is no date entered, it allows the transaction but does not update the TransactionDate field in the underlying table with the StartDate.If this will be a problem, I would be happy if it will not...

Hi BK Many thanks. I'll try this and hopefully should be ok. I'll come back for advise if I run into some problem. As VB learner, I could have never written this but do understand it generally now that it is written. regards Vijay

I have 2 tables set up.The first table has among many,2 fields,one for 'Start Date' and the other 'End Date'.This is populated by Form 1. The other table 2 has many fields and one field is 'Transaction Date'.This is populated by form 2.I would like to achieve 2 things. 1.When the user inputs a...