Search results

Good Idea; Bad Idea Do you think its better to invest all the money you have in property (if you can) or keep it in a savings account?

Right guy's i gotta problem! cant seem to work it out even though Hay posted examples. I have a DB with tblContacts ContactID Email CompanyName ContactName Tel TYPE WebAddress frmADDREMOVE which is a data entry form so they can add new contacts to the db or delete contacts from it...

I have code that i thought worked but doesn't and it needs fixed. Private Sub PrintScript_Click() On Error GoTo Err_PrintScript_Click ' print ART report DoCmd.RunCommand acCmdSaveRecord ' print the record with three different headings Me.fld_ReportTitle = "Pharmacy Copy"...

Just about outta here guys and have a few wee bits I need to clean up... if you could help that would be great! :D 1. I have a button that takes me from my search patient form to an add patient form (I simply used the wizard to do the add patient) I have taken away the record selectors but...

I have 3 text boxes. Start date, stop date and numberofdays. Startdate Default value =Date() Stopdate Before update =[Start Date]+([Days]*7) Numberofdays Control source =([Stop Date]-[Start Date]) THIS IS FINE for working out the number of days a Doctor wants to write a prescription for...

OK guy's I have a text box on my form for the number of days a script has to be for. (Well 7 text boxes for 7 different drugs, each drug needs to be able to be for different amount of days if the Doc wants) All I need to do is Fill this out automatically from the start and stop date and if the...

What is going on? I have a report designed to print a prescription (you know one of those A5 size things you get from the Doc). I have measured where things are supposed to go, for instance, post code of the patient needs to fit into a box on the A5 bit paper exactly 2.9cm from the very top of...

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

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

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

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

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

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 have got a button on one of my forms! the button runs a qry!and displays the result in a table like format i need to be able to select one of the records from this table. i need the selected record to fill out fields in the form. e.g. a patient has a history of prescriptions, click on the...

i have searched and dont see anything relative.. i would like to have a button on one of my forms, call the button history and when the button is clicked on i would like a pop up form to come up and show either the last 12 or so prescriptions or all the prescriptions that a selected patient has...

Hi guys me again:rolleyes: my methadone script needs to work by 2mo and i cant seem to get it working dispite all me posts on it! i need it to print out ONLY the currant record. i need it to print the script twice. one copy with a date on it and the other copy without a date. i need it to...

i hate that bleepin wizard! thank god i backed up my db just before i ran it! it went all screwy on me! like everthing always does! i simply want to create user names and passwords for each user. i need to have 1 group(doctors without permission for electronic prescribing from the scottish...

Right i had a problem with my forms going all funny on me, e.g. not always maximising although i had the DoCmd.Maximize code in the on open and on load events. i found that Opening my form in Form view. Sizeing the form to the size i want by dragging the borders of the Form window to where i...

i thought i knew how to do this as i asked a while ago but it doesnt seem to work! and i cant find my post! i simply want all of my forms to have empty fields when they open up(after another patient has been selected) i have basically 4 forms Splash screen Select patient Create Meth Create...