Recent content by grnegsndhm

Is there a way to put a Generated report into a Tab on a custom form. The idea is to give a summary of inforamtion from an admin tab presented a tab.

I am using Continuous forms. I have a command button that is enabled upon a change of an element in a row. However, when in continous forms when one command button is enabled they are all enabled. Is there a way to only enable the button for one row? Thanks sam.

Open up the form in Design View Right click the left corner of the form (see a black square) and select properties Go to teh Events Tab Go to the Event "On Current" and click the "..." to the right of the text area on that line Select Code Builder Okay. Here is where you will put then meat...

Use DLOOKUP if its in a table Dim varX as Variant varX = DLOOKUP("Field", "Table", "Field = '" & frmText1 & "'") if isnull(varX) then msgbox("what you thinking yo") Exit Sub end if

If its in a database table you could use VLOOKUP Dim varX Variant varX = DLOOKUP("FIELD", "TABLE", "FIELD = '" & frmText1 & "'") if isNull(varX) then msgbox("what you thinking yo") exit_sub end if

Onload of the form you could set all the elements to enabled = false if the Shipped field is < than now()?

You can use the '----ADD TO BEGINING OF SUB---- On Error GoTo On_Error_Action2 'form element null If IsNull(frmText1) Or frmText = "" Then On_Error_Action1 End If '---BEFORE END OF SUB-------- Exit_Now: Exit Sub On_Error_Action1: MsgBox "In Sufficient...

Just and Idea. You can store the queries in a query table and use DLOOKUP to retrieve the text of those queries. IE TableQry Fields: QueryName Fields: QuerySQL Query A | SELECT * FROM YO Query B | SELECT * from B WHERE B.ID = 'XIDINX' VarSQL = DLOOKUP(QuerySQL, TableQry, QueryName =...

Okay. I am trying to build a form where I could get information like this but also editable. It can be either bound or unbound with enough information to update the records. I could do this several other ways but would prefer it just like it is below. Any ideas is greatly appreciated...

You can use several combo boxes to do this. In the query for the Combo box build in the where clause the path to said combo box. condition = combo.column(1) 'Requery' each subsequant combo box when a its parent information changes. This will refresh each combo boxes contents. Hope this helps

Did you verify that you do not have the two ID's inverted at some point in the Qry or the Code?

Hmm. Have you looked into writing the query dynamically? You could use the QueryDef Object to write the SQL behind the scenes so that you do not need. Will need to import the Microsoft DAO library in VB referances. 'Help' should have more information on applying this in VB.

Need to rank the person by the sales column and show their ranking as a number not just ordering by: Input Record: Person Sales Sally 500 Fred 400 John 600 Output of Query Person Rank Sally 2 Fred 3 John 1

Try and update statment similair to this to update your rows update [table] a set a.field1 = (select b.field1 from TableX b where b.key1 = a.key1 and b.key2 = a.key2) You may need to add in some null logic if some fields will not have a value?: IIf(IsNull([b.field1])=0, b.field1, " ")

I would like the have a query where a persons rank amonst a group is returned by the evaluation a column. Name Sales Rank Jill 500 2 Bill 501 1 John 399 3 Ideas?