Search results

Have you considered a subform to record the varying details of each inspection? Depending on what and how you are recording the data it might be a better way.

I think I would make so you get an error if you try to show a report that does not fulfil the criteria. Even better would be to not allow the user to select a report that dos not fulfil the criteria. As for the title you can make a text box and set it to lookup the valus you need using dlookup...

Sorry for not getting back earlier. This is the SQL view cut down to the essential: SELECT (Min(IIf([tblPSC].[NumberOfObservations]>1,0,100)) AS PSCPerformance, VesselMasterData.VesselName FROM VesselMasterData INNER JOIN tblPSC ON VesselMasterData.VesselID = tblPSC.VesselID GROUP BY...

That might be the source of the problem. Does anyone have an overview of where you must use which characters to avoid getting into this sort of problem?

I know number is reserved but shortened the full name of the field as it is not really relevant. What I find strange is that Performance: (IIf([tbl].[someNumber]>0,0,100)) is not the same as Performance: (IIf([tbl].[someNumber]>0,0,100)) The first is what is being displayed in the query. The...

Does anyone know why access insists on throwing a syntax error when I enter the following in query: Performance: (IIf([tbl].[Number]>0,0,100))? After rooting around I ended up doing this by mistake: Performance: (IIf([tbl].[Number]>0 ,0 ,100)) Then it works however it is still being displayed...

Hi NewShoes While I am not able tooffer anything on the actual mechincs of the combobox I know I would make it a bit differently if I could. While I agree that removing "old" years is a good thing, perhaps you could do this in the query by setting the oldest year to current year minus...

Well I tried the first solution and stumbled as it turned out the combobox insisted on supplying the ID number of the group instead of the text I wanted it to pass on. I then decided that using the CamelCase version of the group as the primary key should solve that problem. Testing it with a...

That sounds like a simple and neat solution. I will try it out and let you know how it goes.

I am working on creating a dashboard for selecting various parameters and then viewing the results. While I can create a dashboard for each main group I am working with I thought that perhaps you could use a combobox to provide the input for which queries it needs to run to get the desired...

Something called "Better Place" is rolling out both charging stations and battery changing stations in Denmark. Once they have a good coverage of battery changing stations it might not be so bad with an electric car. They claim it takes less than 5 minutes to change the battery on their cars.

In Denmark they have made a housetyp they call energy-plus. Instead of the normal insulation they beefed it up to nearly twice the requirement. Add in a ground heating unit (Not sure what the english word is for this thing) and 6 kW of solar panels on the roof (max allowed) and you end up with a...

Simon I did include the fact that it was a split database in the original post. If you know how to un-split a database please let me know how this can be done. I am not sure what you mean by "Form Icons". With regards to the continuous forms I have had some trouble with those before and gave...

I have finally completed my first database from scratch and so far it seems to be doing its job. I would like to invite you to give me some critique on it as I am sure I have made some things that could be improved or should never have been in the first place. The sample database is only in...

Depending on how exact you need it and how complex your form is you should be able to crate a report with the information filled in. Another alternative could be to design the form you need as a report and print a blank as pdf template if you need to fill it in by hand as well. I have had...

I am a bit curious on this with the shared drive for attachments. How does it handle attachments having the same name? I have been using a program that stored attachments in a shared drive but it could not handle attachments having the same name and would just overwrite the previous version...

I think I am getting the picture but will need to think a bit on it. It does sound similar to my first thought of using an append query to record the score of each question for a participant.

So now I have been trying to figure out how to make a continous form that will actually show more than one record all day and must admit I am still missing something. The only difference I can see so far is that I do not have a table of possible responses. I think this should be ok since I am...

Good morning Gina Yep, thats what I did. While not exactly what I wanted in the first go it seems to be a step in the right direction.

You know Gina I am starting to feel a bit silly. I don't know where I got the impression that continuous forms was a button to press but I know I spend a long time looking for such a thing. Now its just to get it working the right way...