Search results

  1. D

    combo box to return a valve in a different field

    Thats a better way. I stand corrected. Once again another learning experience on this informative sight. [This message has been edited by DJBummy (edited 08-27-2001).]
  2. D

    Query -> Report (help!)

    Let me make sure I understand. Are you using the form to select the criteria for the query? What is the name of the query? Will the same fields be used for every report? [This message has been edited by DJBummy (edited 08-26-2001).]
  3. D

    combo box to return a valve in a different field

    Create a form using the item table as your record source. Use the combo box wizard. 1. Look up values in a table or query 2. Select your Items table 3. Highlight the Item Description field and click the > to move it to the selected fields 4. Click next until you get to Remember this value for...
  4. D

    Query -> Report (help!)

    I think this is what you want. Create a report based on the query that you create on the form. Then on the form put a command button that opens the report after you populate the query. D.J.
  5. D

    Vertical scrollbar only if needed

    The only thing I can tell you is too go to the mainform design view and click and drag the vertical size of your subform until the scroll bar doesn't show in form view. I have something simular and I have the scroll bar set to vertical only and then I had to tweak the sizing of the subform until...
  6. D

    Headers and Detail Secton

    I think this may be your problem. Check the properties for the Details Section and make sure the Force New Page is set to None. D.J.
  7. D

    Page Numbers

    I appologize. I misunderstood your question. If I remember correctly I had tried what you are trying a while ago. At that time I was unable to find the solution as well. But that was before I was using this forum. Someone on here will know what to do I'm sure. Once again I'm sorry for the...
  8. D

    delete record problem

    Is your database attributes set to read only? I could be mistaken but I think if the query is an updateable recordset you can delete records from there. If I'm wrong appologies in advance. D.J.
  9. D

    Printer Parameter Dates on Report

    Put an unbound text box on your report with this as control source. ="Report begins on" & [Start Date] & " and ends on " & [End Date] Hope this helps D.J.
  10. D

    Page Numbers

    Put a text box in the Page Header of your report with this as the control source. = "This is Page " & [Page] & " of " & [Pages]& " in this report." D.J.
  11. D

    goto nextrecord when it is currently lastrecord

    You could have a button on your form with this procedure in the on click event. Option Compare Database Option Explicit Dim Message as String Dim DialogType as Integer Dim Title as String Dim Response as Integer Private Sub cmdNext_Click() Message = "Last Record" & Chr(13) & "Click OK to...
  12. D

    While a form is open......

    Seems to me you should only have to use the DoCmd.SelectObject acForm, "SearchForm" before going back to the SearchForm [This message has been edited by DJBummy (edited 08-21-2001).]
  13. D

    Want to change table's key field to autonumber

    Just a friendly reminder! Back up your database before changing the field. Probably won't matter but I have had instances when changing field data types and was very sorry I did not make a copy of database. DJ [This message has been edited by DJBummy (edited 08-21-2001).]
  14. D

    Printing gridlines in Address Query

    A query is the object you use to gather the information from your tables. The report uses the query to print or view that information. You can use a table or a query to create a report. Once the report is created you can then change the appearence and other things as you please. On the left side...
  15. D

    Printing gridlines in Address Query

    Hi Patti Fellow Steeler fan here. Got to agree with Al on this. If you are keeping track of address why not just create a report and you can print however you like. D.J.
  16. D

    Using a Calendar control to update the current form

    Hi I have a Calendar Form called frmLab_Daily_Calendar and the Calendar control is named ocxDaily_Calendar. I use this procedure to open a form based on the users selection of a particular date. There may be more steps than I need but it works well for my purposes. Create an unboud text box on...
  17. D

    Macro for a previous button

    Hi Shawny To be honest the best way is to use code instead of a macro. You can use the command button wizard to create the button if you wish. Using code is much more versatile than the macros. Here is an example. Option Compare Database Option Explicit Dim Message As String Dim DialogType As...
  18. D

    set focus to next record after before update

    Which control is the first one in the tab order? You should be able to add this line to your code. DoCmd.GoToControl "The Name Of The Control That is First"
  19. D

    Queries That Ue look Up Values ?

    This may be a round about way of doing this but it works. Create a new query called lets say qryFavFruit. In the criteria row of the FavFruit field enter this [Forms]![frmFavFruitChoice]![cmbFavFruit]. Create a popup form called frmFavFruitChoice with just a drop down box on it called...
  20. D

    Finding times greater than an entered value

    Beware of the "h" format. In my test of the query it was omitting records that had a difference of 3 hrs and 4 mins. It was treating the difference as if it was a 3. I changed the "h" to "General Date" and the criteria to >#03:00# and the results were better. I think I may have edited the post...
Back
Top Bottom