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?

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.

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

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

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

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

I have a query that works fine until I put the following statement in the sql: Sum(Iif(SBL =1,([Totalreg Labor]+[Totalot Labor]/2), ([Totalreg Labor]+[Totalot Labor])) AS [Total Labor], The error I get is "Syntax error(missing operator) in query expression." When clicking ok it highlights the...

I have the following sql statement in a query; Sum(IIf([Workorders].[BCBOE]=True,([Totalreg Labor])+([Totalot Labor])/2), Sum(([Totalreg Labor])+([Totalot Labor])) AS [Total Labor]) I am getting the error Syntac error (missing operator) in query expression. It highlights the AS. I can't find my...

Hi, I have a form with a checkbox. The checkbox field is also a field in a table. I want to run a query that if the checkbox is marked will perform a calculation. (It will take the amount of labor and divide it in half.) Any ideas? Thanks in advance.

I have read several threads on this topic, have put in code on the preview button of the form but I still only get the first selection, what have I missed? From a listbox, the user makes 1 or more selections then click on the preview button which runs a series of queries limited by the...

I have a table with a location field as a text field. I am wanting to sort on the field in accending order but when I do I get results that I am not expecting. Here is what I get: A10A A11A A12A A13A A1A A2A Here is what I hoped for: A1A A2A A10A A11A A12A A13A The field is never more that 4...

I have a field that has a single or a list of entries. When I query the field using Where[batchno] like '*'&[enter no]&'*' The query shows the data for the batchno entered but if the batch no is not the first in the list when I run the report it shows the first batch no in the list, not the one...

In trying to develop an inventory movement system I have items coming in, being transfered to different locations and being sold at almost the same time. How can if keep up with what I have on hand and where it is? I have a single table with item, qty, and location.

In trying to develop an inventory movement system I have items coming in, being transfered to different locations and being sold at almost the same time. How can if keep up with what I have on hand and where it is? I have a single table with item, qty, and location.

I am working on a query in a db that requires me to determine elapsed time. I have the total minutes but when I divide by 60 what I get is the format hh.mmmmmmmm. Even if I set the property of the field to fixed with 1 decimal, when I use the field in another calculation to determine an hourly...