Search results

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?

Well I did it myself. I just changed the listbox to a value list and purged and rewrote the list box with the new query data. If anyone has another way let all know.

Hey, Okay. so I changed the query def of a query tied to a list box on my current form. When I attempt to requery the list it does not refresh with the change in the sql that was made through the query def methods. Only when I close down the form and reopen it does it show the results of the...

thanks. I look for the code. any ideas as to the location? Even if not accepted it would be nice to achieve away this code.

event the oncurrent event of the FROM should have the code to apply the text box value to the cbo or list: sub frmForm1_oncurrent cboValue = txtBoxValue end sub If that does not work check to see if you can find another event property of hte form or from a button that will allow you to have...

Field Names You have a select and then a dynamic field name being pulled? If you do not have field named "u54gp4pMoh..." in table notes then you should be selecting the value of the column? If you want to pull in that value as a note then: "insert into tbl (fld) values ('" & note & "')"...