Search results

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

I don't know if modal forms behave the same way as regular forms but I have had problems if I did not open the new form first and then close the old form. It seemed to loose the next action when the form was closed.

Solved the problem like this: Stored the intermediate results in a table that will only contain the data I am woking with. Made a couple of update queries to add the required parameters to each record in order for the main calculation to take place. Used an update query to calculate the amount...

Let me start from the bottom. The IIF group is shown in the attachment as a flowchart. I think that is the best way to visualise what it does. The data comes as a query with the following fields: Employee_No (Number) PersonName (Text) Rank (Text) VesselName (Text) StartPeriod (Date) EndPeriod...

Possibly, but I can't figure out how to make the iif's simpler. It bassically is if you fulfill, this, this, this and this, then that, if one is not fulfilled, then this other one. Do you have a suggestion on how to do it? I could possibly get rid of the DLookUp but I am not sure how to do it.

I have been working for a while on getting a rather complicated calculation working right but after getting it to work I have been hitting the wall with a head that feels like a pinball ball. The following calculation works for calculating the amount for each line for [IncentiveAmount] in the...

Don't worry about not knowing much about Access yet, that will come as you try to solve the problems you meet along the way. To be honest I was at the exactly same place as you a year ago. The first thing anyone getting to know Access needs to know is that the data structure and what the user...

First you need to look at your data and figure out how it is all related. Once you got a good mental map try to draw it on a piece of paper or a handy wall or whiteboard. From what you have shown so far I am guessing you need to split it into several tables to get a good design. Don't worry...

If the primary key is the same, you should be able to use an update query to add that data to the primary record. If there is no primary key in some of the data, how do you figure out where it belongs? You should be able to use that logic to build an update query that put the data in right place.

If you need to add new records you should be able to use an append query. If the records consists of both old and new records you need to figure out which records to add. I solved a similar problem by using an extra field in the import table. The exta field is a yes/no type. With an update...

As I recall you can display an attachment as a picture. Might that not be a simpler way of achieving the goal?

Glad to have sparked an idea :)

Have you tried to use the "group by" option? If you activate the "totals" function you get the option to group the results. I believe this should give you what you are looking for.

Sadly there is not really such a thing as "safe" browsing. Indeed just by coming here you can get a virus through the commercials. You don't need to click anything, just coming to page is enough for it to infect. You might get around if you use a text-only browser but then you loose a lot of...