Recent content by cloverdog

Thank you Majp for your time in getting this working and MH for highlighting my error. It is working perfectly now and I have learned something new:) Best regards Cloverdog

Thank you for your reply. I have added those changes and it is nearly there. The only problem is on clicking CboManufacturer in the Master form I get the following message: Microsoft Office Access can't find the macro 'Me.' The macro doesn't exist... and I notice CboModel...

I have a requirement to develop a database that has a Master form with a combo box and a detail form with a second combo box. This arrangement reflects the one to many relationship of the tables underlying the forms. I have been trying to understand the mechanics of combo boxes in making this...

Thank you for your response. Yes I am using VBA for MS Access and did try placing a simple Sendkeys but this didn't run until after manually pressing the <OK> button on the window opened by Autodialler.

I have a button on an Access2003 database that calls autodialler to make a call to the number held in the text field of a form using: Application.Run "utility.wlib_AutoDial", strPhoneNum It works well but Autodialler then presents a window (or as I see it a nag) entitled “AutoDialler” showing...

Worked a treat. Thank you dhookom

Please could anyone help modify a query for a report. Currently the query shows a list of payments due for the coming month by accessing a payments table with a parent of tblContract with a parent of tblCustomer. It shows each client, their bank (.NC field) , PaymentDue and uses the...

Hello Thank you all for your help. I finally got the query working and in case anyone else wants it the simplified version is: SELECT tblCustomer.[Post Code], tblCustomer.CustomerID FROM tblCustomer WHERE (((tblCustomer.CustomerID)=(SELECT Max(Temp.[CustomerID]) FROM tblCustomer as Temp WHERE...

Thank you but I tried this. It only returns 1 record but I need one record for every postcode.

I have a simple query which I am using to retrieve the first record found for each post code from a customer database. It doesn’t matter which of say 5 records for a postcode is returned but it must return one and only one. I have tried using the first() function but I am either using it...

I managed to do it using subqueries. For anyone else who may be looking here it is: SELECT Sum(Mysum) AS MyTot FROM (SELECT tblPayments2006.PaymentDue, tblPayments2006.Amount AS MySum FROM tblPayments2006 WHERE (((tblPayments2006.PaymentDue)>=#6/1/2012# And...

Hello. I need to return the SUM of sales between two dates and save them into a variable. I have a query that returns all the sales but I can’t see how to get it to sum them all up and return a single cell with the value of all the sales ie 5,756.34 instead of a long column of values. I have...

Sorted it! Thank you Lameid and Fumei for your posts. I hate to say it but, being in a hurry, I pasted code from an MS help example. Something which should not be done. All I needed to do was set the boolean parameter in AppActivate to False. Setting it to FALSE tells the calling...

Thank you Lameid. I came to the same conclusion but really wanted to know if there was something I was missing. I have tried swapping Firefox for Internet Explorer with the same result (ie not being able to switch back to Word). There are times when it is very useful to be able to switch...

I have written a small routine in VBA originally using MS Word VBA but now in Access VBA. The sub( ) is triggered by a Button on a form. It Opens ‘Word’ and ‘Firefox’ copies the initial web page and pastes it into ‘Word’. It works but for one thing. Once started it runs down as far as...