Search results

Hi I am a teacher trying to develop a access database programme to create lesson plans record and forecast etc...for myself and department. I think some of it a bit over my head but i am trying my best but this part got me stuck any help would be much appreciated. I have a form...

I got through by using cross tab to get the information in the order to plot it....my problem was the master and child links to get the data to be dynamic...but i think it got through....it working so far still testing. thanks for the help.

ok i used your first suggestion and added the two fields ear and score...but now i am having the problem of mapping my data for the chart as i will need to get the following information to plot Frequency Against series one Right Ear Score and seires 2 Left Ear Score but i am trying a few...

thanks for the information...but is there any other way to go about it using union queries and then cross tab for instance

Hi I have search very hard and tried almost every transpose sql queries but i not getting it so i am asking for some help here. This is my Table AdioDTlID MMID DOAudioData Frequency RightEar LeftEar 1 20 04-Apr-10 0.50 10...

Even though harsh....with a after thought a very sensible idea...Thats eaxtly what i would doo...thanks a million and great effort on your part....

Thats cool good work, I might end up using this method thanks for the hard work. You said their are other methods, you mind elaborating a bit i will do the research and see if it is more profitable

Any body think they can help me with this problem, or offer a differend direction would be greatful....

if you know how via vb lay it on me

so any suggestions on how to open the patient details main form from the patient list main ensuring you goto specified patient

I will hide the comid's after i just using it for development purposes

I just keep it in their so that i can ensure the relationships are present and not lost during development

Yes that is what i will do

if i used the open args how am i getting open form patients Details main from the patients list main to open for the specified patient and also open the same said form as a new form. I am not that great at access programming

No I don;t need to hold the history under the old company and yes it will transfer all the old records to the new company

I trying to carry the COMID through all the records because each patient is linked to that company and only that company if that patient changes to other company I will used a transfer macro to move that patient to that said company

No Luck DCB

Ok so i got the save and New to work by adding by link between Master and Child fields in the PAtients Details Main Form

i was trying a lot of things soo it not working properly but the closest i got was if you used the Patients Details button it would open the Patient Details Form but it only bring up the last record that the onFocus record. Also if I click Save and New on the PAtients Details record it not...

Open Main Form Click on a Company Then click Patient List here is where i have my problem now When i click on the MMID for to edit each patient i want it to open the form Patient Details Main linking the COMID and MMID When i click on New Patient I want it to add to the current COMID using the...