Search results for query: *

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...

Hi Jim I did what you advised and that has sorted the error. A new one has popped out which says Run-time error 2342 A RunSQL action requires an argument consisting of an SQL Statement. What's this one Jim? In the meanwhile, there is good news in that Jay's solution has been sorted and is...

Hi Jim While it appears like there is no space between them in the error message, in the actual code there was space. This is exactly how the code is in the application. Private Sub Command0_Click() Dim strSq As String m_strName = "" DoCmd.OpenForm "form2", , , , , acDialog...

Hi Jim & Jay I am obviously dealing with two geniuses. Unfortunately I am having difficulty in both the suggestions. I did warn you I was a bit thick. Jim's solution It works to the point of letting me select in the combo box and if no selection is made the message box works okay. But if I made...

Hi Jim Have tried but am running into a compile error message when I click on the button in Form1. This is the code I have in the code for the on click for the button in form1. Option Compare Database Option Explicit Public m_strName As String Private Sub Command0_Click() Dim strSq As String...

Hi Jim Many thanks. I am trying it and hopefully it should be okay. I'll let you know how I get on in the near future. regards Vijay