Search results

I solved it, i needed to rename the textbox to something else other than the fields i was trying to populate it with.... eg this works fine... textbox name = txtAmount =IIf([id_activity_type]="Trading Fees",[am_units_calc],[am_per_unit])

Is it possible to pull back one field in the detail section on a report under certain circumstances and another field at all other times as per the below code? textbox name = am_units_calc =IIf([id_activity_type]="Trading Fees",[am_units_calc],[am_per_unit]) The textbox is currently producing...

When in the report go to "View" then "Sorting and Grouping" and add in any extra fields you require.

OK, I've just realised I was attempting to build the query so that I could use the sql it produced in my code.... and the code version of it pulls back the correct value anyway so I've ditched bothering with the query anymore altogether, hurrah!

I need to take a value from a subform and use it in a query but I don't seem to be able to come up with the correct criteria in the query.... I have so far tried: [Forms].[frm_Matching].[SubMatching].[txtSingleFixedPayer] [Forms].[frm_Matching].[SubMatching].[form].[txtSingleFixedPayer]...

Hi again, The link to the database journal had the right idea, thanks! The code I have now is as follows: SELECT count(*) as nm_record,t.tx_product, t.am_notl FROM tbl_Import t inner join tbl_Import t1 ON t.tx_product >= t1.tx_product GROUP by t.tx_product,t.am_notl ORDER by...

Thats the kind of thing I'd already tried but there isn't an autonumber on the table as I import it into the database and then want to append the autonumber column on to it.... I guess this is what I'd like it to do if I have to do it in VBA: Sub Add_AutoNumber_Field() Dim db As Database Dim...

Hiya, thanks for the reply but is it not possible to do this from within a query and not using vba... ie add an autonumber field to the fields you are selecting? Cheers, j

Hi, Just trying to figure out how I can run a select query on some data I have and how to also include an additional field which has a value counting the number of rows.... eg in the first row there would be the usual results and the new field would have a value of 10001, second row would be...

Thanks for the quick reply. :) I guess this will have to be done in this manner, I was aiming to avoid it, altho it wouldn't require much effort to code I guess. I also recieved this reply in another forum I use which I will check out tomorrow morning when I return to the office...

How can I show the results of a recordset in the same way as you would see if you'd run a select query? eg in my mind it would appear similar to this in code: docmd.openquery rst acviewnormal Thanks, jono

Or here for my cut down version requring only a list box on a form... http://www.access-programmers.co.uk/forums/showthread.php?t=89632

Amazing that of my very few contributions to this site, someone has actually referenced something I've written into another thread I'm writing on! Hope the change default printer procedure works for you! :)

Hi Pat, Hadn't seen your reply until now, apologies! Yep, the the two pass thru queries with a normal Access Select query on top worked fine when I figured it out! Thanks, jono

Hi, I'm trying to run a pass thru query into a sybase server from Access. The query contains multiple selects which Access doesn't appear to like very much. The query works fine when run in Sybase. Is there any way of circumventing this problem? I could split the three selects into three...

I believe it only comes as part of Access, so if you don't have Office Professional which comes with Access on your desktop you won't have it. I did a search in Google and found a link straight away for download from Microsoft... get every user to download the application from here...

I've been stumped with this for ages and keep having to go back to DAO to get around it... I have created a recordset using ADOX, but then how do i put the results into a table that already exists or even just add it to a new one? Its been driving me nuts... I've tried adding a new table to...

If you don't need to see the results of the query then just use: Set qdf = dbs.CreateQueryDef("ParameterQuery", strSql) Set rst = qdf.OpenRecordset If rst.EOF Then Instead of: Set qdf = dbs.CreateQueryDef("ParameterQuery", strSQL) qdf.Execute Set rst = qdf.OpenRecordset If rst.RecordCount <=...

Hi, I am using DAO and seem to have a problem using a pass through query with an ODBC link to a sybase server... If an incorrect ID and PW are entered for the first time into some text boxes I have set up and then the query is run for the first time it will return no results as expected as no...

hmm yes that would appear to make sense :-) I'll give the recordset copying a go now that I've added the ADOX reference in