Using Forms | Forum profile

On Sat, 07 Nov 2009 23:58:38 GMT, "User via AccessMonster.com" u36225@uwe wrote: I need a textbox to show the highest value of a column within a table, but exclude the values: 000, 994, 995, 996, 997, 998, and 999 Thanks =DMax("[columnname]", "[tablename]", "[columnname] NOT IN ('000', '994', '995', '996', '997', '998',...

Glad we could help! -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com

One method is to put both queries in a union query and adding another field for criteria from the Option Group. Like this -- SELECT [Fcd] AS [Field1], [Ged] AS [Field2], [Mxy] AS [Field3] FROM Table1 WHERE [Forms]![MyChoice]![Frame4] = 1 UNION ALL SELECT [Sam] AS [Field1], [Bill] AS [Field2], [Joe] AS [Field3] FROM Table2 WHERE [Forms]![MyChoice]![Frame4] = 2; -- Build a little, test a little. "ehops" wrote: Hello all- I...

"DoDev" wrote in message ... aI am trying to make modifications to the the SQL statement underlying a subform. I make changes using the query builder. However, after I make the changes and save the updates my changes just disappear. This happens regardless of what changes I make, e.g. I tried to add new columns, I tried to add new "where" criteria. After making the changes I close the builder and confirm...

Smoki - Choose the SQL View while in query design, and copy/paste the code here. -- Daryl S "Smoki" wrote: Yes, I wanted to say that, maybe I just didn't explain that good. But how to send to you my query? Smoki "Daryl S" wrote: Smoki - Are you saying that when you change one record on the form that it updates multiple records in the database? Please post your query (data source), and indicate which...

Jim Add up a column ... isn't that rather ... spreadsheetly? In a well-normalized relational database table, it might not be so common to add all the values in a field/column for a table. And by the way, the data is in the table, not in the form. If you need to get the sum of all the values in a particular column (e.g., how much did we take in $$ this month?), use a Totals query and use Sum. Good luck! Regards Jeff Boyce Microsoft Access...

Me.Controls("chk" & Right(checkbox.Name,2) & "_Label") -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "night_writer" wrote in message ... I hve a form that has checkboxes for all 50 states. Because individual checks are hard for the user to see, I color the label of the field when the box is checked. When the form is open and a new a box...

I missed that one. You could have put brackets around the field name, but it is better to use a non-reserved word. Allen Browne has a utility for checking such things: http://www.allenbrowne.com/Ap****ueBadWord.html Sklyn wrote: Well, It turns out it is a VERY basic issue.... POSITION is a reserved word.. So i changed all instances to "JobTitle" and it works perfect.. Should have checked that first hey! Thanks people.....

How is your form set up? Is it a form/subform? Does tblSO_Items have the lineno and sono as fields? "Darrell Childress" wrote in message ... The existing record is in a master table called tblSO_Items. This is a table which contains all line items from all Sales Orders. I am NOT adding anything to this table. The relevant fields in this table are Number, sono, and lineno. I am adding a new record to a table called...

SELECT POPIS.Tip_opreme, DKP.Lokacija, POPIS.Soba, POPIS.Opis, POPIS.Verzija_IOS, POPIS.U_upotrebi, POPIS.Serijski_broj, [razliciti tipovi opreme].Tip_opreme FROM [razliciti tipovi opreme] INNER JOIN (DKP INNER JOIN POPIS ON DKP.DKP_ID = POPIS.Lokacija) ON [razliciti tipovi opreme].Tip_opreme = POPIS.Tip_opreme WHERE (((POPIS.Tip_opreme)=[Forms]![Pretraga po tipu opreme]![Tip_opreme])) ORDER BY DKP.Lokacija; If this can help anyhow But I will...