Search results

Can you clarify something for me. You made a form(not subform, a form) using the form wizard? And this form has no Record Source?

This means that your variable strFieldList contains nothing. The 'Build Field List' section of your code is not working correctly.

If you wan't to make this query easier and your database more like a database than a spreadsheet then do a search for normalization. If you want to struggle on this way then you will need to write a monster of a WHERE clause with more brackets than a TV store. You will need to take all of the...

Type ?strFieldList not ?strListField. What you are doing is asking what value is stored in your strFieldList variable.

So you have a table with a field called Recd Date 1, a field called Recd Date 2, a field called Recd Date 3 and a field called Recd Date 4?

When in Debug mode press Ctrl+G This will bring up the immediate window. In this window type this: ?strFieldList press enter and what does it give you?

Here is how I would solve this problem. I would do one of the following: a) Take a big stick to the person who wants to change the ID of a record. b) Quit my job. Both would probably involve a financial penalty but needs must.

It creates the SQL to get the data from the table(s) which you requested in the wizard. It places said SQL in the Record Source property of the form.

The record source when the form loads will need to be blank (or have a where clause like 'WHERE ID = 0') to stop anything showing. Try putting this code in your Form Load event ' Update the record source Me.frmsubClients.Form.RecordSource = "" ' Requery the subform Me.frmsubClients.Requery

It depends how you are going about it. Does your search alter and run a query that you have created? or does it run some code that alters the row source of the subform?

Like i said I dunno about VBA and excel but you might need to include a reference.

I'm off out right now I'll take another look later if nobody else shows you how to do it.

That method wont work because the microsoft help says this about QryDef.Parameters This thread might help you out: http://forums.devarticles.com/microsoft-access-development-49/pass-parameters-from-vba-to-query-62367.html

So you want all houses and the site and phase details where available? Does this work? SELECT tblSite.Site_No, tblPhase.Phase_No, tblSite.Name, tblHouse.* FROM tblHouse LEFT JOIN (tblPhase INNER JOIN tblSite ON tblPhase.Site_No = tblSite.Site_No) ON tblHouse.Phase_No = tblPhase.Phase_No;

I would have gone down a similar rout. Why do you select the TOP 2 when you only want the one value?

Well I know nothing about working with Excell because I avoid it like the plague but these 2 lines seem a bit odd. Set objXL = GetObject(, "Excel.Application") Set objXL = GetObject("C:\Form1.xls") Have you tried this instead. Set objXL = GetObject("C:\Form1.xls", "Excel.Application")...

If you take out 'On Error Resume Next' then you might get an error.

Write a query SELECT YourTable.YourField, (YourTable.SizeNumber & "-" & YourTable.ProductNumber) As YourNumber FROM YourTable Now make a new form and set the record source to be the above query. That should work fine. If thats what you have already tried then I am stumped cos it works for me.

I don't think there is anything else I can suggest without knowing your table structure and the results you are trying to arrive at.

Ok well how do you decide which record to show if 2 records have duplicate policy numbers? For Example YourTable(ID, EmployeeNumber, PolicyNumber) 1, 76, 2222 2, 82, 2222 3, 43, 2222 4, 22, 2223 What would you want your query results to look like? You say you only want one occurence of each...