Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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