Hello All
Can someone point me in the right direction? I want to write a macro that will insert a text box into a Word document at the current insertion point. Also to format the box, i.e. Font, font size, etc. I can get the box ok but not at the insertion point.
Thanks in advance.
Squiddley1957
Last Activity: May 17 '19, 05:47 PM
Joined: Jun 6 '18
Location:
-
Macro to insert text box at insertion point
-
Hello Rabbit
I'm conscious that this might sound ungrateful - Far from it. I get it that one wouldn't want to affect the integrity of data by removing or altering some part - but I don't see the harm in adding to it; after all data rarely comes ready set with a unique id. -
Thanks Rabbit - I've had a quick look at the first article - vely interlesting. With regard to my database, as I explained, someone who fastened on a name from the original source would search on that. That is why it is important that all versions of the name are retained. I understand that, in principle, it's better to use a temporary field but I don't think that much is gained in time terms - not on a database of this size. Perhaps I will try both...Leave a comment:
-
Thanks for all your helpLeave a comment:
-
I had thought of an aka table but on deep reflection I couldn't see that it would save anything. I would still need the individual names in the main table along with the varying dates of birth etc. I also considered using a soundex approach but, again, that does nothing for the dates of birth. Thanks for your help.Leave a comment:
-
Further..
What this means is that someone who has viewed the source data can find the record on this system. That record includes a unique id added by me. That unique id then permits the viewer to see all of the other records that may refer to the subject - and all of the spelling variants. They can make their mind up if the records refer to the same person.Leave a comment:
-
Hello Twinnyfo
Thanks for your post. The table comprises mainly of historical data drawn in from different sources - this last point is important. An example: James Trip, b1855/James T Trip b1856/James Tripp b1856/James Tripcony b1855/James Thomas Tripconey b1860. They almost certainly refer to the same person but there is no efficient way to prove it. Even if there were it is important to retain the spellings from the different sources....Leave a comment:
-
Sorry. It isn't my wish to take advantage of your kindness. Given the limited size of my database I don't see any great benefit in choosing a temporary against a permanent solution - which is why I would prefer to use Update to populate a field.
The main table is not normalised - but for good reason. There are, in some instances, ten records that probably relate to the same person. The problem is that each record is slightly different in important...Leave a comment:
-
Thank you for this. I think that I get it - but can you please modify the code to include UPDATE. I shall probably use the outcome along with other relevant fields auch as sex, age etc.Leave a comment:
-
Yes the data is in a raw table and the occupation number foreign field will be related to a table containing Farmer, Fisherman, etc. The main table has a field called HouseholdNumber . There is also a field in the main table that numbers the status of the occupants, so the head of household is number 1.
I would like a means of looking at each set of records grouped under household number and applying the occupation number to all of them that...Leave a comment:
-
What sort of loop?
I have a file (70,000 records) in which family members are identified by shared Household Numbers. One person (Head) in each household has an occupation. Let's say Farmer is assigned 1 and Fisherman is assigned 2.
Making an assumption that all members of each household are economically dependent on the Head I want to assign a common value to all. So, if the household number is 375 and the Head's value is 2 then I want all of the other... -
Thanks to everyone. I already have two or three layers of filters but I will take another look. The most annoying thing about the scrillbar is its size - especially if you are a of a certain age.Leave a comment:
-
Ok so no custom scrollbar. Could I use two buttons, one up, one down? Presumably there's code to incrementally move by x amount the continuous subform. Is that feasible?Leave a comment:
-
Custom Scrollbar
I find the default vertical scrollbar to be inadequate for my use (continuous form); it's small and positioned too far to the right of other control buttons. Is there a simple-to-set-up alternative? I thought about an active-x slider control but not sure that this is the right approach. -
Thanks both to twinnyfo and NeoPaLeave a comment:
-
Hello Neopa
I have limited knowledge of coding. When you say that you count a recordset that is already open - is this still the case if the query (underlying the popup) is not running? Is it sufficient that the query exists?Leave a comment:
-
The recordsource will be a query. What form would the coding take?Leave a comment:
-
Further: I'm presuming that, in order to count the number of records on the popup, the popup must be open. This being the case the form visible property could be set to false and the Open Form button merely toggle the visible property? Would this work and/or is there a more elegant alternative?Leave a comment:
-
Popup form guidance
I want to add a facility for users to see associated records (from a related many to many arrangement) on a popup form. Creating the form and syncing should not be a problem but I want the Open Popup Form button on the main form to display the number of records on the popup.
Any guidance would be appreciated. -
I'm using a standalone running Windows10/Access16 but the database was produced in 07. I loked at CreateItem but it seems that you can't attach the email by code. I can't believe that there is no solution to this.Leave a comment:
No activity results to display
Leave a comment: