Recent content by illuzioner

hey all, is there a way to make my buttons round or another shape or change the shape of other objects? thnx! lou

hmmmm, that's interesting. i've never used multi-edit, so i just downloaded their demo and i'm trying it out. i did a search for 'emacs' within the program, but it comes up blank. how do you put it into 'emacs' mode? thnx again! lou

hey folks, is there a way to use emacs w/ builder? i like the editing capabilities and c++ formatting of emacs better than the builder text editor, but i still want everything else in the builder developement environment. thnx a bunch lou

Hi, I have a table that has an autonumber field and many relationships with other tables, but it is the 'primary' table. I need to add an entry where I need to make the autonumber field a specific value. How can I add to an entry to my table and get around the autonumber thing? The field is...

Thank you for this answer. I will play around with it to see if I can make it work for my exact table. This helps a lot. Best, Lou

Okay, here is what the table (tblCurrent) looks like: PID IDate CurVal 1 3/15/2002 5 1 3/20/2002 11 1 3/20/2002 7 2 3/25/2002 4 1 3/25/2002 8 2 3/30/2002 9 1 4/15/2002 12 2 4/15/2002 6 grouping by PID, I am trying to calculate the difference in CurVal between a record and the previous...

Hi, what is the SQL syntax to do a self-join of a table to itself where the left table (tblLeft) pairs with the table on the right (tblRight) when tblRight.Date = Max(tblRight.Date) where tblRight.date < tblLeft.Date tblLeft and tblRight are the same table. I'm guessing this is a Left Join...

Hi, Thanks for answering. Unfortunately this only locks the controls -- which are already locked. I'm trying to prevent the user from changing the current record to a different record -- not the values in the record, but changing which record is current. thanks, Lou

Hi, Is there any way to disable record selection in the details section of a continuous form without turning its visibility off? I want to prevent the user from changing the current record, but I still want to show the all the records (in the details section) and make the current record...

Hi, I want to prevent the user from changing the current record, but I still want to show the all the records and make the current record editable (in header). I will do this in &quot;Edit Mode&quot; where the user shouldn't be able to change records and must press a button to get out of that...

Hi, Is there any way to disable record selection in the details section of a continuous form without turning its visibility off? thanks, Lou

Hi, How do I 'select' the record selector in the details section (or whatever is really selected)? I have a form set up as a continuous form with all the records in the details section. In the header I have a tab control (with a subform on each page) that flips pages depending on the record...

Hi Math, try: SELECT DISTINCTROW tblPrices.ID, tblPrices.EntryDate, tblPrices.Price FROM tblPrices WHERE (((tblPrices.EntryDate)=DMax(&quot;[EntryDate] &quot;,&quot;tblPrices&quot;,&quot;[ID]=&quot; & [tblPrices]![ID]))); Regards, Lou

Hi Bob, >. . sounds like you are creating two select queries for >reporting. Is this correct? Yes, 2 select queries: 1) to select all assets' prices on a sepcific date: ________________________________________________________ SELECT tblAssets.MainSecID, tblAssets.AssetName, tblPrices.SecID...

Hi, I have two tables, one with a list of assets and one with a list of prices, setup like this: tblAssets and tblPrices --------- -------- ------------------------------ MainSecID ...(other fields) SecID PricingDate Price ^^^^ ^^^...