Search results for query: *

Sorry a couple of more questions. I set the "Allow Filers" field to yes. I set this in the properties of the command icon. Is this the right spot? Additionally, where do I set [Your Field Name]=-1? Sorry but one more question. I want to be able to display more than one record in the form...

It is a yes/no field. So basically I want to sort by that field and only display the yes records. Thanks for the help! Steve

I want one table where I filter to display all open records in a form view. I then want to be able to change the data that is displayed in the list. Any items? I want it displayed as many times as there are open records. And it should be displayed in a form view. Steve

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

Thanks so far with the help, but I am still having problems. I tried the suggested code above and received an error, so I removed the extra comma after acPreview. I now have the following code: Private Sub PrintForm_Click() On Error GoTo Err_PrintForm_Click Dim stDocName As String...

Ok sorry, I went to build event (right click on the printer command icon) which brought up the following code: Private Sub PrintForm_Click() On Error GoTo Err_PrintForm_Click Dim stDocName As String stDocName = "Change Implementation Information Sheet" DoCmd.OpenReport stDocName...

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

Ok. I am sorry but I am still having trouble. I created the form using the design, so I do not know if that makes a difference. I click on the properties of the report itself, but I did not see where it was asking for a source. If I have the report open, what is the best way to find what you...

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

My suggestion would be to look at using LSMW. LSMW is an easy tool that I have much more effective than CATTs. The transaction code is LSMW. You might not have it installed, but it can easily be added for free. Steve

Figured it out.. I am an idiot.. Values were not in the correct format. Sorry

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

Sorry for the confusion... I am using a Make query in the design mode. The table I am creating needs to be limited by the criteria that I am trying to create. In the example: MATERIAL Price Quantity AA 1.00 2 AA 2.00 4 AC...

I should add that I want to eliminate duplicates, and ensure that at least one of the records is there.