Search results

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

Hi Gina I tried to figure out what is going on in the questionnaire response section but it seems I am completely missing something. I am baffled by the fact that when I look in the design view, I only see a single line but in the form view I see all the lines for that subject. Looking closer...

Good afternoon. I am struggling to get a data entry form to work the way I want it. Basically I have a number of questions that have been answered by a number of participants. Still being new with access I have set up the tables and relationships as I believe they should be. I have attached a...

Just today I learned something about using networks to link FE and BE. Apparently if you use the UNC path it improves the connection speed. In my case between Denmark and India. Search wikipedia for the explanation as I can't insert a link yet. I am sure some of the gurus in here can shed more...

I hope Irene will not be too bad when she hits you After thinking on how you solved your problem, I think I have a way of solving mine. By arranging the tables as set out below, do you think it would work? Table for inspection type: Autonumber (PK) Inspection type (Could this serve as the...

From the relationships it also seems complicated.... In some way it seems similar to what I am trying to do so I will see if there is something I can learn from thinking on it.

Since I am at the level of an apprentices apprentice that sounds quite complicated. Would you mind enlightening my a bit on how you cracked such a nut?

More or less. I initially thought the title of the subchapter could serve to differentiate the subchapters but since the same title can occur more than once in the same chapter that idea is out. The problem occurs when we receive the observations. They are just listed by the number and it would...