Recent content by AndrewB

Bob Many thanks. This has sorted it for me. I didn't need to use the quotes around the field names but did add one line to get my caption names showing the correct names in the datasheet column headers. With Me.Displayed_data.Form .RecordSource = Me.List0.Value .Requery...

Bob Thanks for the offer of help. Here is the DB zipped and attached. It is still being developed so all the test data is bogus. The form in question is called FORM TO RUN SQL 2012-07-17. As I said, the database is still being developed and I promise that won't be the final name for the form!

Bob Thanks for the reply. The List box is being populated by a function and displays tables in the database that are being read from a collection. I don't think it is a cartesian join issue. The number of records in the subform is always correct for the number of records in that table and the...

Hello I have a form which has a listbox containing my tables. From that, I can successfully select a table and click on a button. There is a sub-form that has a recordsource that is set to the selected table. I am able to dynamically change the captions to the correct field names for the...

Thanks for the reply. Yes, I meant a worksheet in an Excel file. Can you reference a worksheet using a number? My code is set up as DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, Tablename, importstring, No, RangeString where the variable RangeString has the spreadsheet name...

I have a facility whereby I import data from Excel spreadsheets into Access using some VBA code. The users have the ability to add new worksheets to their files (seldom used in practice) and I add these new names to my master list, together with some other attributes, and all sheets are...

Bob Thanks for the suggestion. I haven't had a chance to check this out (users are at another location) but will hopefully do so soon and let everyone know.

Can anyone help with this? It will sound weird to you and you probably will think I'm pulling your leg but it is all true! I look after an Access 2000 Database. There is an existing report to which I added two new columns - one shows the results of a text box (where the values are H or S or...

Right - an extra step looks like a good idea. I'll go and apply this to my real DB - not just the Table 1, Table 2 stuff I've been posting here. Thanks again. Andrew

MStef, Thanks for this. Your query shows my problem as it returns one record (where the Table 2 record has XXX in Field f31). I need to output all records from Table 1 together with the Table 2 info where the Field f31 = XXX. I would expect to see the following results...

D'oh! I meant LEFT JOIN. For the other question, yes, it is a criteria of Field 3 = "XXX"

I've been toiling with the issue of WHERE clauses on the "Right" side of Left Joins. I'm aware that you need to use JOIN ON......AND.... rather than JOIN ON....WHERE.... if the WHERE relates to the Right Hand table. I've even got an example in my DB where the above works, but now am struggling...

My STEP3 query is something that references both - but it doesn't work whether I link them or don't link them and whether the join is any of the available options.

Anyone able to help please?

I have a combo box in a form which allows users to select a Client Group. One of the choices in the combo box is ALL. I have some code in a STEP1 query that says SELECT IIf(Forms![Date Picker].[Client Group]="ALL","'SEDP' Or 'LD' Or 'MH'",Forms![Date Picker].[Client Group]) AS Expr1 FROM...