Search results

Have a look at this article: http://www.techrepublic.com/blog/how-do-i/how-do-i-transfer-data-from-a-word-form-to-an-access-database/

Have you tried something like this: Dim oCell As Cell With ActiveDocument.Tables(x) For Each oCell In oTbl.Range.Cells With oCell 'do stuff End With Next oCell End With I have not tested the code but as long as you replace the x it should do...

This one has me stumped at the moment. Of course you nee the information in that table otherwise you would not have received the error but since it appears to be a one time job, consider that time spent on making the code to transfer the data vs. the time needed to enter it manually. One thing...

The easiest would of course be to unmerge the cells. Is the layout fixed or can you make changes?

One option is to use the form fields throughout instead of only for checkboxes. There is also a text variety you can use. It is possible to use VBA to extract the contents of form fields and load it into a table for further processing. Since each form field is individually named, their position...

We are having the same type of discussion in Denmark. For many years this number was considered a secret but in reality it was extremely easy to find out what the number was if you had a little information about the person. As of today, it is possible to buy stuff and borrow money if you just...

A word of warning. Sometimes it is not your system deciding this but rather some server between you and the receivers. Some are set to automatically flag the sender as a spammer and within a day you could end up being banned completely as they exchange this kind of information. Based on...

I have a problem with a pivot table that I am sure can be solved. What i need to do is rather simple if it did not have to be done in a pivot. My data is arranged and shown like this: Date Hours MaxHours 03-11-13 740 792 01-12-13 674 672 01-01-14 568...

You are right about the potential time issue however Sychoangel only wrote dates so I assumed it would only have to deal with dates and not times. If it has to handle that, I would use this one...

You can try this one. It works in excel 2010 but as for the other version I don't know. You might need to replace the ";" with "," as I know this can cause problems depending on your system setup...

What I have done is to import the data into a temporary table. I have an additional field in the table which is a yes/no field. I first run an update query on the temporary table where I mark all existing data with the yes/no field. Afterwards i can then append all data that is not already...

I second Mihails solution. Taking your example I get this: Departure 10 Nov 1700Z from Tokyo. (Tokyo is at the +9 time zone so local departure time is 11 Nov 0200(+9)) Arrival 11 Nov 0500Z in Seattle. (Seattle is at the -8 time zone to local arrival time is 10 Nov 2100 (-8)) Keep in mind that...

If you still have some of the old floppies, try this: http://www.youtube.com/watch?v=FXhS8OQrORE

Whether they are organic or not does not mean anything. Depending on the country of origin, some pesticide, fungicides or other nasties may still be allowed for organic greens. We ahve had several scares with raspberries contaminated with human waste (Yes, exactly that kind of waste). If you...

In Denmark we currently have a major issue with our version of a person identifying number. In reality, this number is just a reference to you in a central database that will uniquely identify you. Unfortunately many public and financial instituions as well as businesses will accept this number...

As I read the code it is first checking to see if there is an data at all (if not isnull) If there is, combine the first and last name where the employeeID is the same as the selected person You may have better luck in following this example...

Using the legacy versions also allows users to use an earlier version of word. The new versions can only be used in 2007+ versions of word.

The beuaty about using teh legacy form fields is that they are not code or anything like that. We have the same IT rules and these go through without problems. Since all the work done by code is from access, the word form should not contain anything that they will stop. If needed, you can...

You are welcome :)

If you use a template that access can pull out you would save a lot of coding. I have attached an example you can look at to see what it would look like. The example is using the legacy form fields. In order for you to be able to fill out the form fileds, the form must be locked. There if no...