Search results

It is due to the nature of the Crosstab feature. The Crosstab uses your data for column heading (for Access column heading is a field name) which means that he field names change. For me, I am not concerned if any other forms are open I just need to find my form for the reason stated above...

Hi Rain: Thanks for sticking with me. As to your questions: Although there are other forms that I have designed for this application, frmGLSum is the only form that would be in effect at this time. The frmGLSum which is the Crosstab Query is not used or connected to any other form. So just...

Ok, I am missing something in my understanding of your solution or my level of understanding Access does not match your level of understanding.. I understand the creating the criteria part but I do not understand how the form information is dynamically passed back to a query that the query that...

As in define a criteria in the query? Well the criteria needs to change based on the selection the user makes from the list box. Thanks

Hi: I have a form bound to a Crosstab Query. The form has a list box from which the user can select the items to be displayed. With code I then set the filter to this selected item. However, the form displays all records returned by the Query. I have used Debug.Print me.filter to verify that...

Hi: The bound controls are not causing me a problem. I can make them visible and the values display as expected. It is the unbound control which is not displaying the value and only if I use code to set the unbound control to visible. So if I start with the unbound control visible then the...

Hi: Thanks for the tip, and yes, that would handle any nulls which may creep into the data. That change however, still does not address the problem I am having. Thanks

Hi: Just to be clear, the formula calculates properly and displays properly. It is only when I set the control to not visible and then use VBA code to set the control to visible that I cannot see the results of the calculations. When my VBA code sets .visible= true the control displays but the...

Hi: The control is not bound to the table and the source is a formula using controls which are bound to a table. Thanks

Hi: On a form I have designed I have an unbound field which calculates a result from various table fields. The bound fields and the one unbound field are all set to visible = false until the user has entered some information. Using vba, when the conditions has been met then I set all bound...

Hi: You are, if I understand you correctly, suggesting summary field for OnHand, Transferred, Added, and Adjustment in the new table? Would this be summaries to date or for the current day? Thanks

Hi: Thanks for the response. Just to be clear, the stock table is not an inventory table. The main purpose of the stock table is to track quantity on hand and to determine if physical quantity matches (it seldom will) expected quantity. The historical sales data will be in the imported...

Hi:: I started my project several month back to relearn Access after being away from Access for many years. One of my original question was about storing a calculated value and after some discussion I decided to store the value. Now I need to revisit this decision. I receive, after the...

When you say "...imports its not picking up the data..." what do you mean. Did your import show you data and then there was an error and no data was entered into your table. Are you familiar withe the File Import on the menu? As you go through the File Import steps you should see the data...

Hi: My first guess would be the validation rule on the Postal Code field is the real bug bearer. If you make a copy of the (customer_register) table for testing purposes then you can append just the Postal Code and AccNo fields to test and then fix the live system as necessary. In...

Hi: I am creating a table to store perpetual inventory information. Just to be clear, I am not managing the inventory but rather recording what has taken place. On a daily basis, I import several text files which provide information on what was sold, including product, total quantity, and total...

Hi: You are correct in that the sales information is historical and should not be changed. However, the physical count or the delivery count could have been entered incorrectly and after reviewing the reports the error was detected. (A paper trail is maintained on the physical count and the...

Hi: Thanks for the response. Yes, I should have included Sales Date, Product Id, and Sales Id are all part of the Stock table. You are suggesting I calculate the closing count for each product as I update the table and store the calculated count with each record? I had thought of that and...

Hi: In the A2003 database I am developing I need to calculate/store a end inventory count. First some background. The database is a historical collections using daily imported sales data with the primary purpose of analyzing the sales that have taken place and then reconciling the sales data...

Hi: When you are blind it is hard to see the trees when you are standing in the forest. I have been fairly fixated on adding unbound rows to the form and then populating the rows with recordset data that I missed the really easy fix. vbaInet finally forced me to open my eyes and the solution...