Search results for query: *

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 ^^^^ ^^^...

Hi Schof, Thanks for the reply. I haven't had an opportunity to implement it, but I will check it out. Thanks again. Lou

Okay, I think I figured it out. I use the full form declaration on the sub call too. Thanks again for the help. Lou

Thank you Jeremy, How do I actually call another form's events? I tried doing a call to its name after changing its declaration from Private to Public, but it still wasn't recognized. I'd like to try this way before I start moving tons of code and changing everything to refer to the proper...

Hi, Is it possible to trigger events on other forms (other than open the form)? I have 2 forms that are already open, and when the user presses a button on one form I need to jump to another form and do some stuff. I was able to change the value of a toggle button on another form, but changing...

Great, thanks. I have found VB help very difficult to navigate and it usually doesn't give me complete responses. Thanks again. Lou