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!

Register Log in
  • Congratulations derfloh 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. cookie5

    Deleting replica paths from the synchronizing list

    I need to eliminate paths to deleted (dead) replicas from the list of replicas in the synchronize pull down box. I know the list is in the MSysReplicas table but of course you can't remove them from there. Any ideas?
  2. cookie5

    Blank pages in the report

    Thanks, I found the problem to be duh a margin error.
  3. cookie5

    Blank pages in the report

    I have checked keyword and FAQ but found no hint to help me find out why every other page of my report is blank. In sorting and grouping I have it set to keep the whole group together by the date field. I am using Access 97. Thanks in advanced for any clues.
  4. cookie5

    Problem with auto expand on combo box

    Thanks Missionglinq but the result is the same. Any other ideas?
  5. cookie5

    Problem with auto expand on combo box

    I have a combo box on a form that has auto expand and limit to list set to yes. There are over 3,000 items in the list. If I put in w, n, s, or e it correctly displays items that begin with those letters then have a blank (i.e. W 10th St. or N 11th St) but if the item I need is Westwood lane, no...
  6. cookie5

    Group fields for new records in a bound subform?

    I posted something similar to this earlier and with your help was able to work though most of my problems, 1 remains and I'm not sure if it is possible, so here goes. I have form with several subforms. The subform in question has a table as its source. The subform has 2 combo boxes, both BOUND...
  7. cookie5

    Use of combo box question

    Thank you lamid, I'll give it a try. Thanks for sticking with me. I may be trying to do too much with too little knowledge.
  8. cookie5

    Use of combo box question

    Lameid, Thanks, the combo boxes are currently bound to the table, if I make them unbound, how do I populate them with the data from the right record? Thanks
  9. cookie5

    Use of combo box question

    Lameid, Thanks, I WANT to use the combo boxes to both display records already written to the table tblworkorders_parts_detail AND to add new records to the table. Can that happen?
  10. cookie5

    Use of combo box question

    Lameid, The main form is frmWorkorders_Form2. It is the parent.There are several subforms but subworkorders_parts_detail is the subform giving me the problem. The record source for this subform is a table called tblworkorders_parts_detail. There are 2 combo boxes on subworkorders_parts_detail -...
  11. cookie5

    Use of combo box question

    lameid, here is the sql for a query that list all the parts with the category for the part. Is that what you need? SELECT [Parts Category].[Category Name], Parts.PartName FROM Parts INNER JOIN [Parts Category] ON Parts.Catid = [Parts Category].CatID ORDER BY [Parts Category].[Category Name]...
  12. cookie5

    Use of combo box question

    Thanks Lameid & TheAceMan1, Lameid, I changed the where but that did not help. With that it shows the category put leaves the part list blank. TheAceMan1, these are bound combo boxes to a table that has the partid and the category id for each record. At this time the past entered records display...
  13. cookie5

    Use of combo box question

    Hi Lameid & TheAceMan1, I modified and put both combos on the same subform. That works great for records that have already been written to the table. Both the Category and the Partnames are fine.BUT, (isn't there always a but?) If I want to add a new record, I select the category from the...
  14. cookie5

    Use of combo box question

    I have a form called workorders based on a table. The form has a subform with 2 combo boxes on it. The first combo box is the category for the part that is going to be used based on a category table. The second combo box list the parts within that category based on a parts table. I can add a new...
  15. cookie5

    Exporting & importing question

    Got it, Thanks.
  16. cookie5

    Make an object replicable after importing

    How do I make an object(table, query,etc) have a replicable property after I have imported it from another 97 db? When I click on properties replicable is greyed out. thanks
  17. cookie5

    Exporting & importing question

    I have a 97 db that I have made changes to as well as created new tables, queries, forms & reports. I am not attached to the master, so I used the import to a blank database then copied it to a cd to transport to the site. I know that I can import it to the existing db but my problem is that the...
  18. cookie5

    IIF statement error

    ...Workorders.[Signal Locations:], Workorders.[School Flashers:], Workorders.[Flasher Locations:], Sum(([workorders empdetails]![Emp 1 Hours:]*[Employees]![PayRatew/Benefits/IIf([SBL],2,1)) AS [Totalreg Labor], Workorders.[Time Arrived:], Workorders.[Time Completed:], CInt(CDbl(Nz([Time...
  19. cookie5

    another nested if quandry

    P.S. RTAper,RTBper,RTCper,RTDper and RTEper are the results from previous queries. When I run the query with the above sql it shows the percentages EXCEPT when the checkbox for the corresponding per is checked, then it does not show the per and puts nothing in the Totalreg Labor field. I hope...
  20. cookie5

    another nested if quandry

    I had the following sql working correctly: Sum(([workorders empdetails]![Emp 1 Hours:]*[Employees]![PayRatew/Benefits])/IIf([SBL],2,1)) AS [Totalreg Labor], Then I had to add another condition checking for checkboxes RTA, RTB, RTC, RTD, RTE. If one is checked I want to multiply by the...

Part and Inventory Search

Back
Top