Search results for query: *

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?

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

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.

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

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

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

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.

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

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?

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

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

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

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

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

Got it, Thanks.

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

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

I had the following query sql working correctly: SELECT Workorders.WorkorderID, Workorders.[Date:], Workorders.[Customer:], Workorders.[Signal Locations:], Workorders.[School Flashers:], Workorders.[Flasher Locations:], Sum(([workorders empdetails]![Emp 1...

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

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