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.
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...
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.
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...
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...
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.
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...
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...
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...
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.
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.