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

    Linking Paragraphs in Multiple Word Docs

    Thanks a lot for that tip. That's exactly what I needed. Now, I would like to know how I could programmatically open the child documents (more than 100), update the fields, save the documents and close them. Is there any simple way of doing it? Any tips will be really appreciated. Thanks.
  2. owizard

    Linking Paragraphs in Multiple Word Docs

    Hi, Is it possible to link paragraphs in multiple word documents? I would like to link them in such a way that if a paragraph in the master document is updated, the same paragraph is automatically updated in multiple child word documents. I am using office 2003. I need to create one master...
  3. owizard

    Another Calculation Issue

    Hi, Thanks. I tried the first procedure in the After_update box. However, I am a getting a "sub not defined" error whenever I enter values. Do you think that the name of the second procedure should be "UpdateTotals" instead of "UpdateTables"? Thanks a lot.
  4. owizard

    Calculating values in a sub form

    Hi, I have two tables (Say X,Y) in a very simple inventory system. Table X has imported values from an Excel spreadsheet. The fields include Actual_Stock and Ave_Cost. Table Y has Count1, Count2 and Count3 fields. I have a form (D1) with the subform(D1Sub)for entering the values. Both forms...
  5. owizard

    Macro Issues

    Hi, I have a Macro that imports a file from excel and stores the the values in a table (say X). I have a command button for running the Macro on the form, which is connected to the table X. Issues: 1. Whenever I run the Macro, the table gets populated but the form doesn't show the records...
  6. owizard

    Another Calculation Issue

    Sorry for the loose language.MY DBMS knowledge is quite rustic at the moment. Total_Value is a control in the form. It is in the detail section. Counted_Stock, Counted_Value are calculated values. They are not stored in the table. Thanks.
  7. owizard

    Another Calculation Issue

    Hi, I have a form with the following fields. Count1, count2, count3, Counted_Stock, Counted_Value, Ave_Cost Counted_Stock =Nz([Count1])+Nz([Count2])+Nz([Count3]) Counted_Value =[Counted_Stock]*[Ave_Cost] I need to calculate the aggregate counted_Value for all the records in the table...
  8. owizard

    Simple calculation

    Thanks a lot. It worked like a charm.
  9. owizard

    Simple calculation

    Hi, I am really sorry for asking such a simple question. I need to calculate the total of 5 fields in an unbound text box with an expression. c1, c2, c3, c4, c5 My expression in the control source is =[c1]+[c2]+[c3]+[c4]+[c5] I want the text box to have the value of C1, if that is the only...
  10. owizard

    Field level security?

    Hi, Is it possible to implement field level security in a form?In other words, can security be implemented in such a way that only certain users can modify certain fields? Example: Users - A, B Form 1 ------ Fields Date Info1 Info2 Info3 Info4 Is it possible to implement security in...
  11. owizard

    Automatic Date Entry (Date=LastDate+1)??

    Hi AK, You are absolutely right. When I was looking for the solution, the first thing I tried was "Me.date = DLast("[Date]", "[Table1]") + 1" as the default value. It didn't work. Thanks a lot for the solutions. I will inform you, if I find any problems. Cheers.
  12. owizard

    Automatic Date Entry (Date=LastDate+1)??

    Hi, Thanks to all of you for your replies. I have tried AK's solution. It works most of the time. However, there is a problem. After entering a certain number of records, the code mysteriously repeats the same date 3-4 times. For instance, if I start from 20/02/02, the function works normally...
  13. owizard

    Automatic Date Entry (Date=LastDate+1)??

    Hi, This problem probably has a very simple solution. Unfortunately, I couldn't find it. I have a form connected to a Table with Dates and associated info. The Structure is: Date Info1 Info2 Info3 The table already has some records with dates and other info. I want the date to be...

Part and Inventory Search

Back
Top