Search results

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

Re: autonumber..........aarrggghhh If you have a form where you create the jobs, you can use the DMax function to create an automatically increasing number. You need toset up an extra fiedl to contain the job number. In the forms BeforeInsert vent, enter the following: MyField =...

If you are using a report to display the results there is the option of sorting the students on the marks. You can find this under the group and sort buton.

I think the learning curve is triping everything up. From my own experience Word has a pretty flat learning curve in the beginning It may become steeper but most users will not go there. Excel has a start that is a bit steeper but it soon flattens out again unless you keep using new functions...

Try this: Int(-100 * [Sum(([Category1]="C")*-1/21)) / -100

Just figured out what it was. Always, always, always remember to save a query every time you make a change to it. Otherwise it just gives you funny ideas.

I have tried to implement the suggested solution but without luck. Since I already had the information from tblReportDates available in a query I tried using that. From what I could understand from spelling my way through your module this is what it achieves. Apart from not being in a table, I...

Thank you Recyan, that looks promising. I ill see if I can get it built into my own project.