Search results

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

If all parties have word, would it not be possible to use that as the carrier for the data? Word has the option of inserting text fields which you can name and manipulate in various ways. You can also "lock" the form so that you can only fill in the fields you have made.

Not having any idea of how to achieve it I hazard a stab in the dark anyway. Would it be possible to test whether a report has more than one page? If so, run the test after every entry and print out the report if there is more than one page. You would need some way of hiding the new entry and...

That really depends on what kind of risks you are going to work with. I can help out with regards to the maritime world. In addition a bit on work environment although that is most likely governed by national rules where I would not be able to assist much.

In the report you should be able to set the "force new page" to either start the next record on the next page or start the current record on a new page. You can find the setting if you go into design mode on your report. Open the properties for the report and use the dropdown in the properties...

It mostly has to do with the limits put in by the IT guys. While I can make this in access, the rest is off-limits unless they have the full package including manufacturer etc. with hotline and all the bells and whistles.

Thank you for your replies. It will take some time to get through everything but by first glance I think I have much of it in already. Moving it to a SQL server is currently not an option but maybe sometime in the future if the evolution of the database becomes more important.

After getting everything to work in the first place I am now looking at improving the speed of my queries since it takes 5 to 10 seconds to make the final result. As it is today, I have 16 queries that collect and make calculations from a variety of tables for different subjects such as budget...