Search results

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).]

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).]

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...

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.

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...

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.

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...

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.

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.

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.

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...

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).]

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).]

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...

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.

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...

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...

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"

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...

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...