Search results

Hi Jesss, Need some answers from you before a good answer is possible: Your form containing the drop downs is called? What is the name of 1st drop down? What will the 1st drop down select? Is the 1st drop down "bound column" an auto ID? The same answers are needed for Drop down2 Are your tables...

Check this out:http://www.databaseanswers.org/data_models/ There are many, many options here. As for your task, I would say that (At the bottom right section of this page), nr 73 Worksheets, should give you a good basis.

Hi Kev, That's what makes this Forum so great. Glad to have been able to help you.

Hi, The solution should be changing the join property. In the Query design view 2x click on the join to display join properties. You now have 3 options. To my opinion you need the 2nd option.

I know what you're talking about, I ran into exactly the same problem a while back. Could not find the reason, so for each query that I could not select, I created a table and an append query that sends the query results to that table. Whenever I need the results, I first go to the database and...

you have set up far too small margins left and right (to compensate for your landscape size). this is not possible. This in combination with your margin settings and the paper size does not work, does not match. Innept = lacking sense or reason : foolish?

On this forum, go to "Search" and enter "Password" (because you want info about password) , then select "Go". You will find a lot of information on this issue that has been handled before.

The (landscape size) you have set up for this report does not match the paper size in your printer, which you have defined in Page set-up.

The user gives him/herself a report grade per section, and adjusts it as he/she goes along. It could be an enchouragement to learn, and eventually to upgrade ones report figure, but mainly it should serve as a reference for the person who is trying to help out.

I like you initiative. Got to (on this forum): Video tutorials,Forms;Creating a main form and sub form using the Form Wizard. This would be how you set up TblCardiologist (Main form) + TblServices (Sub form) and (as an extra Subform) TblFacility. Look and learn and try it out in practice. The...

Problem: Very often the knowledge of a user is unclear in the first post. I often do not know at which level to reply (Later it becomes clear). Solution: Would it not be easy for the person replying to the post, to directly see the level of knowledge (Access for example) of the requestor? This...

Incorrect "Bound column" assigned? This should be a unique value, and more often than not, an autoID

Hi, Ok then, if works fine for you then that's great, but this would be my next suggestion: 1:tblServicesCardiologist and TblServices are the same thing, so you could bring it back to 1 table? 2: For the same reason TblServicesConditions could also be deleted.... and relate TblConditions with...

Can't be done in a form as far as I know. You'll get 1 different picture per row. Row 1.... Picture 1 Row 2.... Picture 2 Row 3... Picture 3

Regarding your question about duplicates. Like you said, you get duplicates since 1 cardiologist may be in multiple facilities (which is correct). To solve this you can make a report based on the query, and there you will group by Cardiologist and Country.

I see quite a lot of setup problems. 1: Do not relate 2 Autonumbers. 2: You should have 1 Autonumber per table. 3: Don't use the same name "FAC_ID" for autonumber in different tables 4: Make less tables if possible 5: In TblFacilitiesCardiologist why Card_ID? 6: In TblServicesCardiologist why...

If it is the query, then Check this for "Totals query": http://office.microsoft.com/en-us/access-help/count-data-by-using-a-query-HA010096311.aspx

Try a backup version that should be ok on some other PC? Then you know whether it's the PC or the Prog.

If your query resluts also show this, then your Total query is incorrect. Other option is your report is not correctly Grouped / structured. Try this link to learn about grouping your report values...

If you have grouped by procedure type and totalized per procedure type, then what duplicates are you trying to hide in the report? Other details per group? Can you show the results in a reply post and specify what needs to be hidden?