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

    Charts Continue to Sum

    The 2 fields are called [COMBINE] and [CH 236]. COMBINE is the date stamp of when the data was pulled and CH 236 is the data points we are reading. When looking in the data sheet, the data looks good, but for some reason the graph is horrible. See below for the SQL. SELECT Table1.Combine...
  2. JBuckley2000

    Charts Continue to Sum

    I went into the row source and got rid of the sum total - even with the sum total there, the data was still showing up correctly in the data table. Once I get out of the query and data table, the chart is completely messed up and it does not extract the data correctly.
  3. JBuckley2000

    Charts Continue to Sum

    Hello, I looked up previous posts stating as to how to stop data tables from summing up similar items once the chart wizard was completed. I have done so and it shows each record by itself in table form, but when I go to print preview for the chart, the data is still summed up by days - my...
  4. JBuckley2000

    Word 97 - Creating If Then Statement for Auto-Form

    Hey all, I am busy setting up an autoform in Word 97 for an easy to use template I want to create at work. I never really used Word for something as functional, but I want to this time. I created a form which has a drop down list at the top. When a user chooses either of the choices in the...
  5. JBuckley2000

    .LWP File - What is this?

    Thanks for the info - it will definitely help me out in the future...better late than never! JSF Jason Facey jfacey@lithonia.com
  6. JBuckley2000

    Natural Log Calculation

    This might be an easy question for most, but I was needing to calulate sigma for a graph in Access and I was needing to find the natural log for defects. How would I write the natural log in the query to solve for sigma? Thanks! JSF Jason Facey jfacey@lithonia.com
  7. JBuckley2000

    .LWP File - What is this?

    Does anyone know what a *.LWP file is? Is this maybe a Lotus WordPro file? It has been years since I have seen this file extension so I wasn't sure. If it is a WordPro file, is there anyway to convert it to Microsoft Word? I am trying to help out a friend who has data she wants to hold on to...
  8. JBuckley2000

    Excel - Auto Fill and Auto Sort List

    Hello everyone, I am trying to do some ranking of tasks and setting priorities for when incoming shipments need to be paid. I want my columns to automatically change sorting preferences when I change the priority - let's same Shipment1 can be ranked lower than Shipement8. I want to put a...
  9. JBuckley2000

    Input Form and Edit Form

    Good morning all, Seems like a pretty basic question, but I am having problems - I want to use an input form as an edit form also and I can't get it to work. I want to be able to use a field to call out existing records within a saved table. If the field value doesn't exist in the current...
  10. JBuckley2000

    Appending data from a report to a history table

    SOrry to write again Kyle, but some problems still came up for me - this is what is in the module: Option Compare Database Option Explicit ___________________________________________________________ Private Sub Report_Close() End Sub...
  11. JBuckley2000

    Appending data from a report to a history table

    A history table because I want to be able to pull the part numbers from the part number table then save whatever ticket information in a production history table. Sometimes the user will have to add new parts to the part table and it wouldn't make sense to also have the production data included...
  12. JBuckley2000

    Appending data from a report to a history table

    Hey again Kyle, I put the code in just as you have it written, but this error message comes up along with the expression you gave me to fix: Compile Error: Label Not Defined The part of the module that is highlighted to fix is: Resume Exit_Report_Close Is this because the report runs off of...
  13. JBuckley2000

    Appending data from a report to a history table

    Ok, ok, disregard the last post. I was putting the history table into the append query, when all I really needed to include was the Ticket Query that report runs off of. Now I am going to try and finish the rest of it...sorry about me being a moron, Kyle. JSF Jason Facey jfacey@lithonia.com
  14. JBuckley2000

    Appending data from a report to a history table

    Hey Kyle, I think I understand where you are coming from, but I am having problems writing the append query. I set it up so that when I run the Ticket Query which the report uses, the information will be appended to the history table. My problem is, for some reason, when I run the append, I...
  15. JBuckley2000

    Appending data from a report to a history table

    Hello, I am having a problem with saving records in a production history table. As of now, I have created a database which uses a report (PrintTickets) to print out certain production tickets once a product is made. I am wanting to track the tickets that are printed out each day, but I am...
  16. JBuckley2000

    Programming Using Mod Command

    Hey Jack, That would work perfectly and I can see where that would be helpful, but I am needing to take the remainder number to be printed on the last ticket...so we can print the move ticket and have the correct number of parts on it. I need the order quantity on each ticket. Thanks! JSF...
  17. JBuckley2000

    Programming Using Mod Command

    Hello, I am having a problem creating a module that will help my ticket database print tickets. On the current table, I have a list of every single part I need to print tickets for. For each part, I have a column for the stack quanty (stackqty) that is allowed on each pallet. I want the...
  18. JBuckley2000

    Using a Combo Box

    Hello, I have a slight problem. First of all I have a data table which has all of my part numbers and their relative information (part description, quantity, unit of measure, how many per pallet, etc.). What I want to do is create a form in which a user can choose the part number, then the...
  19. JBuckley2000

    Using a Record Table on a Form

    Hello all, I have a small problem in saving some data into a new table. What I have now is a table that has all part numbers located. I want to use a form I have created to pull up these records so that I can print them out to a ticket with all of the info. I can do this. My problem is that...
  20. JBuckley2000

    Monarch

    Hello, Well the problem I was having was defining fields and then exporting them into Access. If you help me with this, I would be good to go. I know how to use the alpha and numeric functions to set up the model also. Hope this is enough info. Thanks, JSF Jason Facey jfacey@lithonia.com

Part and Inventory Search

Back
Top