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: *

  • Users: wally2321
  • Content: Threads
  • Order by date
  1. wally2321

    Repeated Entries - Fields that can be entered

    Help! I need to be able to have a form that can be filtered and then display multiple entries. What is the best way to do that. I have a form called Implementation which calls table Data Table. I want the data in the table to display multiple times in a form format (all on the same page)...
  2. wally2321

    Printing a report from the form

    Please help!!! I have placed a print icon on my form. When the icon is pressed, it prints a report that I have designed. The problem is it prints all the records in the database. I would like it if the icon is clicked that only the record being displayed in the form is printed. I am not that...
  3. wally2321

    Form Created - Now trying to print

    I have created a form and I have added a print icon which sends a command to print a report I am creating. Unfortunately, when the report prints, it prints all records. I want to only print the record that is being displayed. Should I be doing something different? I basically want the record...
  4. wally2321

    Forms: Saving and creating new records

    HELP! I have used MS Access in the past but only for querries and database design. I have been asked to create a form that will link to a database. I have already started working on the form. Unfortunately, after I enter some test data, I can not get the form to save the data and then allow...
  5. wally2321

    Scrapping vs. reporting production

    Question: Our current environment is 4.6C with Automotive 2.0 solution. Recently we added two non-stock items to a subassembly on a BOM. I found that when I backflush an item in a repetitive environment it ignores the non-stock items (does not show up on the component allocation BOM for the...
  6. wally2321

    Converting a number to a certain format

    I have not used MS Access in a while and I have forgotten a lot of the technical detail. I am currently creating a query using the design function of Access. The query is a "MAKE" query so a new table will be made after running the query. In the source table I have a field value...
  7. wally2321

    Scrapping - Automatically when Backflushing

    I need some help!! Currently we run 4.6C with automotive solution 2.0. I am trying to set it up, so everytime I produce a part, it automatically backflushes a percentage for scrap. So for example: Finished parts produced is 1000 PC Requires Part A - 1000 PC Requires Part B - 1000 PC This...
  8. wally2321

    Posting MS Access Forms to the Web

    Hi! I am thinking about posting a form to a web site. The goal is to have a user post an issue via the web site. My question is pretty basic.. Is it possible to post a form to the web, which updates a database? If so, after creating the form, how do I put the form on the web? Thanks in...
  9. wally2321

    Subtracting two columns

    Please help me! I am trying to create a query subtracting two columns. For example, I have field "Before Value" and field "After Value". How can I find the difference between the two fields. I tried the following: Difference in Value: [Before Value]-[Value After] I...
  10. wally2321

    Rounding - How

    Can some one help me please? I am creating a query using the design feature. The problem is the number I am loading has 8 digits past the decimal whereas I only want two places. The second digit past the decimal should be rounded up or down, depending on the number. Is there a good way to do...
  11. wally2321

    Only selecting one record from multiple records

    I am creating a Make Query using the Design feature of Microsoft Access. I have a simple question that I can not seem to figure out. I am a novice at this, and I am probably asking a simple question. What I want to do is only select a record once. i.e. First column is field names MATERIAL...
  12. wally2321

    Eliminating Duplicates from the query

    Can anyone please help! This is probably an easy question that everyone has an answer for... I hope so.. I am a rookie, so please understand. I created a table with values. This table is called ....FLORENCE - MATERIAL - MAKE - KAUF (PDM). In this table is the field called OLD PART...
  13. wally2321

    Modifying existing VB in Query - Exclude Alpha Characters

    Any help would be great. I have a Query that I need to change that is a result of a new requirement. The query is called MATERIAL - MAKE - KAUF (PDM). This query is a make query, creating the table KAUF - MAKE PDM. In the query I am using the design view, because I am a novice, and find this...
  14. wally2321

    Simple question

    Once again I have a question... I have the following code in my query - NO: IIf(Left([MATERIAL NUMBER],1)="F" Or Left([MATERIAL NUMBER],1)="Z" Or Left([MATERIAL NUMBER],1)="S" Or Left([MATERIAL NUMBER],1)="E",Right([MATERIAL NUMBER],Len([MATERIAL...
  15. wally2321

    Return Value when two values equal

    I apologize if this is a simple question, but I am having a brain cramp. I am trying to create a table using the design feature of the Make Query. In my query I only want to return values if two fields are greater than zero. How can I do that....? Field 1: ROP Field 2: MIN I only want...
  16. wally2321

    Visual Basic Code for a query - Any Help!

    I am trying to create a query using the Design function of the Make query, but I am running into difficulties. I am trying to put a piece of VB code in the field, but I keep receiving errors or wrong data. The field name I am trying to create is Origin Group. Within this field, I would like...
  17. wally2321

    Limiting Selection of querries

    I am trying to create a table from a query using the design feature of the make query function. The following attributes are involved: Source Table: FLORENCE_MATERIALS Destination Table: FLORENCE SCRUBBER - MAKE Reference Tables: X-REF VENDORS , X-REF MILK RUN In the source table there is...
  18. wally2321

    Multiple Table, multiple field query with limiting records

    I am trying to create a table from a query using the design feature of the make query function. The following attributes are involved: Source Table: FLORENCE_MATERIALS Destination Table: FLORENCE SCRUBBER - MAKE Reference Tables: X-REF VENDORS , X-REF MILK RUN In the source table there is...
  19. wally2321

    Make query - Selecting specific values & adding characters

    Everyone: I would like some help please. I am currently trying to create a Microsoft Access "make" query using the design feature. The following holds true for my senario: Source Table: FLORENCE SCRUBBER - MAKE Make Query Name: MAKE - KAUF (PDM) Key field for query: MATERIAL...
  20. wally2321

    Deleting first character based on the character used.

    Everyone: I will try to be very specific relative to my question, but if there are any additional questions, please feel free to post the question. I am trying to create a make query using the Design view of the make query. I am using the following information for my query. Source Table...

Part and Inventory Search

Back
Top