Search results

what do you mean? i dont think it makes a difference doing the (.Field) bit i tried using it and still got the same error!

ignore that last one.... open access tools--> analyze--> documnter--> pick your table or what ever you want the structure of!! thanks anyway!:o

simple question but i have never been able to do this.... All i want to do is go into design view and print out the table structure! Help! Thanks in advance Lyns

Private Sub SelectDrugs_Click() Reset_Text Dim Ref As Integer Dim MyRS As DAO.Recordset Dim MySearch As String Set MyRS = CurrentDb.OpenRecordset("his2", dbOpenDynaset) Ref = Me.SelectDrugs.Column(0) MySearch = "[Ref]=" & Ref MyRS.FindFirst MySearch...

:(

:( Im with you! This is a nightmare, I don’t even know if the rest of my tables are correct. I have 4 separate tables for my drug form frequency and strength. Use cascading combos based on a qry that shows all the different combinations of the drugs. Is that wrong too??:( Know what I don’t...

file is too big even when ziped! :(

I'll try the dummy thing. Table structure...in ARTScriptmaster I store the scripts so in the ARTScript form each combo box has a field in the table, there can be more than 1 drug with corresponding form, frequency and strength, hence drug1 form1 ect and drug2 form2 etc. I now know this was a...

hey there guy's! I've been trying to do this for ages and got so far now i dont have a clue! I have posted about this before but its kinda different so ill start over. THE STORY I need to be able to get the history of prescriptions for each patient, to do this i have a button on the create...

that'll be it then! TA! :rolleyes: can't wait till friday:)

this is a crazzzy question but i just cant work it out...monday morning feelin on a tuesday i think.... i have used one of those tab control things and all i need to do is in the on click event of a Yes/No field in the first tab make it go to the second tab!!!! eg. the yes no box is OnART if...

your a star*! might have another wee question in a min if i cant work it out. TA! thanks cheers for helping! :D in the words of Arny ... i'll be back!!! :rolleyes: :D

TA! getting there eh! thanks a million for helping. hopefuly i only have one problem left! run time error 2450 cant find the form ARTScript in a macro expression or visual basic code. i forgot how to fix this...my form is called ARTScript spelt the same too. :( chances are this isnt going...

MyRS.Find MySearch method or data member not found?????? got the DAO bit working i think i selected the wrong one in references.

so should the end bit work to fill out the text boxes on another form????? i tried to do the DAO.Recordset but it didnt like that either ... invalid argument keeps coming up! :(

Seems to be something wrong with Set MyRS = CurrentDb.OpenRecordset("his2", dbOpenDynaset) his2 being the table the 2nd box is based on!

cant seem to work out how to fix this code to work for me does anyone have a clue?? Private Sub SelectDrugs_Click() Dim Ref As Integer Dim MyRS As Recordset Dim MySearch As String Set MyRS = CurrentDb.OpenRecordset("his2", dbOpenDynaset) Ref = Me.SelectDrugs.Column(0)...

thank you much! im kinda getting there!:( :rolleyes:

i didnt delete it totaly i had a copy of one i tried to do. so i split the history table into 2. i created a form and put two list boxes on it. in the row source i have SELECT [His1].[Ref:], [His1].[Patient Number], [His1].[Start Date], [His1].[Stop Date], [His1].[Doctor]...

aaaaahhhhh! im still stuck! I restructured my table! dont know how to store the data now though? :( :confused: im sorry! Harry your great! if your not to busy your help will be much much much appreciated. can i get a copy of the list box demo again as i deleted it by mistake!