Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ButchSchweitzer

    Need Multiple Masters in Replication set

    I have been using the Breifcase to help with the tracking. But still only one at a time can work on the database. The Access help talks about managing the Design Masters and they always have an "s" on Master, which would make one think that their can be more than one, they also talk...
  2. ButchSchweitzer

    Need Multiple Masters in Replication set

    There are two of us that are designing on the same database. We have the main master on the network and we each have a laptop that we want to be able to work on the database and then syncronize back to the main master. The replica that we now have on the laptops will not allow changes to the...
  3. ButchSchweitzer

    Labels with variable # of lines

    Setup the label size. Then set up your label report with grouping and use the name of the client as your first group. Turn on the header for the group set repeat section to yes. Put the client name in that section and your cookies in the detail. This should give you and unlimited number of...
  4. ButchSchweitzer

    Random List of people

    You could add a field for yur random number in your table then use a recordset and step through each record and create a random number and store it in the field that you added. This could take a while to run because you have the potential of duplicate numbers, you will have to test the entire...
  5. ButchSchweitzer

    Random List of people

    You could setup a field and make the data type autonumber and set the new values to random. If you set the indexed to Yes(no duplicates) you will be able to sort and never have a duplicating number. Because you already have the table populated copy the structure only to a new table and add the...
  6. ButchSchweitzer

    First time Report!

    I have just writen a database and report that I think will do what you want. I don't know how to send it to you. I am new to this web site. If you are interested. When you respond to this it will let me now by then I will find out how to get it to you the best way. Butch
  7. ButchSchweitzer

    Dropdown Box as Criteria for Report

    What I like to do is to create a table that has the names in it (set it up the way you like it). Use a combo box to get your information, form the table that you created, set limit to list. Include the same name table you created in your report query. Then your field will be available to print...
  8. ButchSchweitzer

    Report fomatting

    I am assuming that your dept list is narrow and long and there is notheing on the rest of the page to the right of the list. You have your report as you want it now, place a subreport on your report then take your dept list field and remove it from the main report and place it on a subreport in...
  9. ButchSchweitzer

    Parameters on a report with sub-reports

    Place your prompt in the main part of the report, as a none printing field, then in each of the subforms use the main form field as the source for their respective fields. Good Luck Butch
  10. ButchSchweitzer

    Insert Date on Report...

    Another way would be to place the a text box on the report where you would like it to print, set the control source to "=[Date Printed]". Every time the report is printed a dialog box will open prompting for "Date Printed" Good luck

Part and Inventory Search

Back
Top