Search options (Page 1 of 2)

Hi.
I have a table "Transfers" in a project that uses another table, "Accounts" in a relationship twice as a lookup. So I end up with fields in Transfers of id_Accounts and id_Accounts1. No problem to show all the data in a tablegrid by using two calculated fields. But if I want to do a more detailed search say between two dates I'm unable to use the calculated fields in a SQL Query. So can any one help with a work around.
Thanks
Terry

Hi,
I have a project that has a table that records the locations of a trip (Tripnum, Country, Location) and I want to have another table that is a summary of the first in recording Country, Location and the number of visits. Is this possible and if so can the summary table feed of the first. Meaning as the data is saved in the first table the second is  added at the same time ie before or after saving. Thanks for any help
Terry

Hi,
I remember seeing an example of selecting multi dates using a MonthCalendar and transfer the start and end date to 2 DateTimePickers on the same form and saved to the database. I checked the forum but can't find it.

Cheers
Terry

Hi,
I have a table with 2 fields Name and Type. I want to use Name in a combo box but have it order by or index by Type. Is this possible. Thanks for any help.
Cheers from Down Under

Hi,
Like most projects my single account with a running balance has grown into one with multiple accounts. I have a table called Accounts and one called Transactions that is linked to Accounts. If I use the calculated field method that Derek assisted me with the results are wrong once you add a second account and have two or more transactions on the same date. Any help would be appreciated.

Cheers Terry

Hi,
I'm working on a simple project that has a petty cash module. The table has date, details deposit, withdraw and balance fields, sorted on date order. I'm able to keep the correct account balance if claims are entered in the correct date order. But if an entry is made after the current date the balance field is no longer showing the correct sequence for the total balance. Put another way, how can you adjust the balance when an entry is made out of order - apart from doing it manually. Thanks for any help or advice.

Cheers terry

Hi,
Is it possible in Fast Reports using an on before print event  to change the font color based on the data. For example 'Flight' would be clRed and 'Cruise' would clBlue and so on up to say 6 different possible differnt colors. So far all I can do is change it only on one condition .

begin
if Copy(<Report."TableName.FieldName">,1,1)='F' then
ReportActionItemsType.Font.Color:= clRed
else
ReportActionItemsType.Font.Color:=clBlack;
end;

Any help would be appreciated. Thanks

Hi Dmitry,
Thank you for your answers to my previous question. This time I would like to know is it possible to sort the Child records in the Treeview control after say adding a new record  or even at form show.
Thanks Terry

I'm using MVD 4 and in my current project  I get a error message telling me the form I want to open (to add a new record) is either disabled or invisible. I click OK on the dialog and the form I want opens. Any ideas

Thanks Terry