Recent content by TrollBro

Bubba100 Actially I wasn't using a form (yet) or an input box but just runnung from the module. I think you put me on the right track - I'll give it a shot. Many thanks!

To be more accurate, I should say I have VBA code (DoCmd.OutputTo acOutputReport, stDocName, acFormatSNP, SaveASstr, True) that has the [select id] parameter in the where clause of the datasource (qry) for the rpt (i.e. stDocName)that prompts the user for the ID. Sorry I was confusing in how I...

Hi I have a saved report with a saved qry as the datasource with a [select ID] parameter on the ID field in the qry. I have VBA code that prompts for the ID and exports the SNP report to a folder. I do not want to open and read the report, I just want to generate and save it. However, I want...

Hi, I hope someone can help me with this. I have a table with 26 fields in each record. Is there a way to find the field name in each record that has a specific value? for example, 26 fields named 'a', 'b', ... 'z'. each field has a different numeric value. I want the field name for each...

Hello I want to use DAO to loop through a large file in ascending [date] field sort order, and for each record, evaluate the record's [amount] field. If the [amount] field is null, I want to append the dollar [amount] value from the prior (i.e. most recent prior date) field to the current...

Thanks MajP My example may have been confusing. My tblActivity does not contain a field called desiredRate. DesiredRate would represent the result I am trying to derive, so it would be a filed I create in the qry only. So, Activity table has a [ActivityDate] field and an [EuroAmount] field...

I'm stuck even after looking through other DLookup posts for solutions. I have a table of exchange rates and a table of activity dates. I want to get the exchange rate for each activity date. However, in any given month, not every day will have an exchange rate, and not every day would have...

The AcemAn1 and dhookom Thanks for your suggestions. I couldn't quite figure out how to use your replies - it took me a few days, but now that I think of it, I should create a form with this MsysObjects table as the data source and call the form. right? Thanks!

Hello I have a module in a A.mdb to auto create a new B.mdb and then export a table from the A,mdb to the B.mbd. It works fine with a hard coded table name. I'm trying to figure out how to have a list, populated with tables names from A.mdb, pop up for the user to select the table(s) that...

dhookom - Thanks! this was exactly what I was looking for.

I'm hoping someone can help me. I have a qry with two tables: tblParent (100 records, 5 fields) and tblChild (300 records, 8 fields). I am trying to produce a query that generates a list of the 100 parent records with a 6th parent field that represents the child region value having the highest...

Thanks PHV - this worked perfect right out of the box!

Thanks PHV - I did a direct cut&paste but this generates an error message "syntaxt error in From clause" and I can't figure out what's causing it. any ideas? Thanks

PHV This is the best I could do and seems to give me the correct results. I also used alpha sort (min) player name as a tie breaker (my player values lead with a numeric ranking number - somewhat arbitrary but directionally accurate for my purposes). Not very eloquent, but seems to work so...

Thanks PHV I get an error: enter parameter value b.player Am I missing something? Thanks here is my code: SELECT A.[team], A.[player], A.[Goals], B.[player] AS Captain FROM [testtbl] AS A INNER JOIN ( SELECT [team], Max([Goals]) AS MaxGoals FROM [testtbl] GROUP BY [team] ) AS B ON...