Search results

.

:(

I have a copy with false data on it that i can post here if anyone thinks its worth a look!

Yup I suppose that’s along the right lines! I need 3 fields from the result of the qry to fill out the form. The patient can only have clear or sugar free so If clearcheck is in the qry result then tick the clearcheck box in the form. If not leave the field in the form blank. If the...

Was that the one splitting history into 2 tables?? I did try this but couldn’t get it to work! Prob because I don’t really understand what im doing!! :rolleyes: (that’s a surprise eh!) It was more that I didn’t know what to put where and how I would get the info from my form (which has all the...

Private Sub BaselineMeth_Click() On Error GoTo Err_BaselineMeth_Click Dim stDocName As String stDocName = "baselineMeth Query" DoCmd.OpenQuery stDocName, acNormal, acEdit Exit_BaselineMeth_Click: Exit Sub Err_BaselineMeth_Click: Msgbox Err.Description Resume...

.

:(

i did a car rental system in 1st yr at uni ill look it out tonight, if i find it ill let you know either later tonight or tomorrow!

I have tried doing a subform and that doesnt work! I have tried getting the qry to only show the patient name start and stop date and that doesnt work i have tried code that i found on the internet and that really didnt work! i tried creating another form based on the qry and using a button from...

know what im still stuck! :eek: :( :( :o :o

Right so if i put =IIf(IsNull([Strength3])=False,[Forms]![ARTScript]![Stop Date]-[Forms]![ARTScript]![Start Date],"") into the control source of the text box then that should work! It did thank you very much! Lyns X

whats your email? sorry im confused too thanx for taking the time your a star. here is the story so far basically the doc opens the db goes into a form and selects a patient (on this form there are buttons to take the doc to other forms-prescribing forms.) say the doc goes into ART script and...

in a report i have i have a sort of table, i cant seem to work out how to do this it should be easy but hey you know me!:rolleyes: What i want to do is check if a field has a value and if it does then in a text box next to the field have the number of days shown else if the field doesnt have a...

:(

I still cant fix this as I need at least 7 drugs each having a form, freq, strength Hence ill have 7-drug names 7 forms 7 freq and 7 strength in some cases! It doesn’t wanna play and won’t let me use this amount of fields! Surely this is not a huge amount of fields compared with big companies is...

Got the sample ok thanks! I have a hitch...when trying to populate listbox1 with the result of my qry it keep's telling me I cannot have more than 20 fields yet wont let me select any less than what the result is! E.g. my qry result has approx 33 fields that I need as a patient can be on up to...

Ill have both! :D text and the logo

A sample would be great! I get you now Harry im sorry im away with the fairy’s right now not paying enough attention! My email is 00067458@napier.ac.uk a sample would help a lot! thanks much, Lyns. Hay! How’s tricks thanks for replying! Hope ur ok! Ill call soon!

Thanks for that! not really kind what i need! i really really need it to be as simple as anything so clicking on a button then selecting the record they want and the fields being filled out kinda has to be the way it's done. else it's to complicated for them and they wont bother with it, they...