Search results

  1. A

    stupid question - Dates in form...

    mtairhead check the value of control source of the textbox...it should be =Date() i.: controlsource=Date() I'd seen what you write here as "Date ()"...no space between the word date and ()... Even you dont add or edit a record... this will automatically displayed on your form once it...
  2. A

    Form with Combobox to search record

    Hope this one will help..See attached sample file
  3. A

    Refresh or requery problem

    Since you wrote that each item in no 2 is totalled, why not put the me.parent.form3.refresh on the code (which is no2) where calculation is made. You can do this after each item total is computed. i.e: nQuantity * nPrice me!parent.form3.refresh
  4. A

    RFT Problem and Subform data entry

    It think your zip file has been using RAR...I dont have the software to extract it... Can you use Winzip??? Sorry !!!
  5. A

    Triggering Yes/No message box based on date

    What field you are referring in your table...
  6. A

    Form with Combobox to search record

    dim mySQL as string dim r as dao.recordset Procedure txtProdID_OnExit() mySQL = "Select fldProdId, fldProdName, fldQuantity From <tblName> Where fldProdID =" & me!txtProdID set r = currentdb().openrecordset(mysql,dbopendynaset) if r.recordcount > 0 then...
  7. A

    Refresh query results

    I've looked on your database and you are opening a query base on your criteria. The thing I can suggest is that put this query in a subform and have a subform property to display it as Datasheet. If you dont want to do this, you have to create procedure to determine if the query is open or...
  8. A

    “type key word here” search

    All you have to do is create a text box for the word to search for. And then create a Procecure that will look for such as SQL statement...
  9. A

    Recordset not updateable?

    Are you using a query as a recordsource to the form or in your table structure most of your fields have default value... If possible can you attached your database (erase all important data)
  10. A

    Code to count records

    You can also use the recordset clone i.e : dim as rst as dao.recordset set rst = me.recordsetclone msgbox rst.recordcount
  11. A

    Recordset not updateable?

    Did you set or change the Alllow Edits, Allow Deletion on the form Properties ?
  12. A

    Refresh query results

    Can you post your DB so we can look at it and figure out the problem ? Thanks
  13. A

    Help with Next button

    Are you saying that, when you press the next button, your drop down value will be the next record on your table? I am getting this right ?
  14. A

    Report actually prints differently to Print Preview

    Can you post your DB ?
  15. A

    field box height

    Have you tried using FORMAT ---> SIZE on the toolbar...
  16. A

    Running Report from Customised Menu

    Can you post your db (as ZIP so we can see what is worng with your DB ? I tried to do an example of your problem and it works fine with me...
  17. A

    Option Group

    On the After Update Event of the Option group, you have to test the value of option group. You can use SELECT statement or IF. i.e: Select Case Frame0 Case 1:..... case 2:..... End Select
  18. A

    RFT Problem and Subform data entry

    Can you post your DB ?
  19. A

    Option Group

    You can use an Option Group wizard....
  20. A

    Creating a "Save As" dialog box

    Hope the attahed file will help you
Back
Top Bottom