Search results

I think you have to put the query name in quotes ; Set myqry = CurrentDb.QueryDefs("MQRY") Hope that helps, StepOne

What you need to do now is write an append query to copy the data from workers1 into workers, and from managers1 into managers, etc, etc. You can then delete the linked tables (all those ending in '1'). Cheers, StepOne

Thanks Pat, It does help - but I still hit a problem when one (or both) of the text boxes are blank. If they are both blank I want to select all records - if txtMaxCaseSales is blank I want to select all those where case sales is greater than txtMinCaseSales, and if txtMinCaseSales is blank...

Hello all, I have a query which pulls its criteria from a form. There are about a dozen combo/text boxes on the form, and each one has a corresponding column in the query definition which goes something like this ; [weeklyCaseSales]=[forms]![frmRetailerQuery]![txtWeeklyCaseSales] Or...

Thank for all the replies - very useful stuff. I think that means I had better stick to Access 2000 for the time being then, as I am sure some of the pcs will be running 98 or even 95. Does anyone know, in that case, a good (i.e. cheap !) place to get a copy of Office Developer 2000 ...

Hello everyone, I've been developing simple databases for a couple of people and two things have come up ; 1) One client would like the ability to use the database on multiple pcs without buying a copy of Access for each one 2) I would also like to be able to present a more professional...

Hi there, Why not just create a query that gives you the required answer and then do a Dlookup on the query ? I think that will be a lot easier than what you are trying. Regards, StepOne

Hi there, Not sure where the best place to post this - so I'll try here. I want to create a form which lists all reports in the current database, along with their description, so the user can choose which one to run. This list would be dynamic, so as new reports are added they appear in the...

Hello, Has anyone come across this problem. I have a database where I use a single form (frmPatientDetails) both to Enter new patients and also to View the details for existing patients. I use DoCmd.openform frmPatientDetails, , , , acFormAdd to open the form in data entry mode. When...

Hi Dan - thanks for that - it seems to work, however it causes another problem. After I have counted the records I then open a form using the same SQL criteria, but that does not work with the '%' syntax ! The purpose of this code is to search for retailers (based on URN, town, or postcode). So...

Hi Pat, No, the URN is a text field. I had all this working in DAO, it is just while trying to create an ADO version that it stopped working. Do you have any idea - I'm getting really frustrated by it. Thanks, StepOne

Unfortunately its not that simple. I've tried lots of different SELECT statements, and they all work fine, until I put a LIKE clause in them. In fact I have just noticed that if I use the following SQL ; sqlstring = "select * from tblretailers where [URN] like '95014'" Then ALL the 1300...

Hello all, I am using the following code to count records in an ADO recordset ; Set rs = New ADODB.Recordset rs.ActiveConnection = CurrentProject.Connection rs.CursorType = adOpenKeyset rs.Open sqlstring If rs.recordCount = 0 Then MsgBox "No matching retailers...

In the Footer of the subform, add an unbound textbox and set its data source to be "=sum([<fieldname>])" where <fieldname> is the name of field you wish to subtotal.

Try putting the whole SQL string in quotes.

Hi there - yes, the combo box is bound to a field. The field stores the BNF code, and the user would like to to display the BNF code. The problem is that for the auto-type thing to work on the drug name, the drug name needs to be column 1, and cannot be width zero, which means the drug name is...

Hello - is anyone able to help with the problem above. I've searched everywhere but cannot find a solution. Basically I want to know if auto-complete can be set to work on column 2 of a combo-box, but I want column 1 to appear in the box, so I cannot set its width to 0.

There are dynamic combo box examples in the Sample Code bit I think - or find a post by Mile-o-Phil (he has the link in his message footer). Basically you need to update the rowSource property of the third combo from within the afterupdate event of the Vendor combo, and Group combo. e.g. in...

Hi there, Why not base your form on a query that links the order table with the customer table using customer ID ? When you select a customer all the related fields will fill in automatically. Or you could put a DLOOKUP function in the Name, Address, Town, Postcode etc fields which will pull...

Hi there, I have a combo box displaying 2 columns - drug name and BNF code. The BNF code is the field I want to store and display in the combo box. But the user wants to be able to type the first letter of the drug name to quickly move to the correct entry. As far as I can see, the only way to...