Search results

  1. C

    Continuous Form - Visible Property Label

    I have a form that prompts the user for a production date that will display the reworks on a part-by-part basis. If the rework % is greater than 1% than a label is displayed (Called Troubleshoot) and a Command Button (Called: TroubleshootForm) is also displayed which when clicked takes you into...
  2. C

    Time Stamp Procedure

    After a thorough investigation, I have now decided on the software and related hardware necessary to implement barcoding into our database. The actual barcode will be read by numerous pen scanners within the factory and be directly linked to the backend database on the server by keyboard wedge...
  3. C

    Barcoding

    I am entering another phase of our program and the bosses want to add barcoding capabilities to it. Basically what they want is at the start of the production line, they want someone to swipe the barcode on the production report attached to the container(which would be the lot number of the...
  4. C

    Null Calculation

    I have a subform which has a listing for additional costs if required. The user inputs the detail and the amount. This is a continuous form, based upon a ConcernID. I have a total in the form footer which gives an overall additional cost total. This total is then transferred to the main...
  5. C

    Field Flashing

    I would like a field inside a form to display its contents by flashing. I know that a forms property can be set using a timer, but has anyone applied a timer to a field. Thanks
  6. C

    Total Expression on Subform

    I have a form which is in a tab layout form. (6 separate but related subforms) On one of the subforms, I have listed various item totals, which are then summarized with a grand total in the form footer. On another subform within the same, I would like to be able to bring this total over to be...
  7. C

    Sorting

    I have a query with a Date Field. There are many entries for each date within in query, based upon a Production ID field. My query groups all the calculations into one line per date for each distinct calculation. The date field is set to sort asending. My report when run off the same query...
  8. C

    Date Selection List Box

    I have many reports in my database that are selected according to the month and year. I have used different criteria in setting up the selection processes for the user, such as date dialog boxes splitting the month and year and 'from and to' selections. I would like to standardize the...
  9. C

    Reports - Multiple Column

    I am having trouble getting my report to read correctly. I am trying to show our 4 production lines, with 3 shifts each daily sales. The problem I am facing is that the the main field names are "Machine" with 4 options and "Shift" with 3 options. I have tried a crosstab query, but it will only...
Top Bottom