Search results

Here it is... Really appreciate your input on this! Anne

hi Folks Would really appreciate your help with this..essentially these forms are to track treatments (each of which has a number of sessions for customers) I have 3 forms: Main form for Patients (mFrmPatientDetails) .I have this set up as with combo box: (There is an underlying tblPatients...

Just tried that. I have up to 8 in the treatment table itself for one record and so it adds 9 but won't increment beyond that. So when I add a new treatment it still shows 9 and stays at 9 For my other sample record it won't show the treatment number at all. (I'm using Access 2010 - sorry had...

This is what I have at the moment in the Treatment Number control on a sub form. The txtPatientID is the name for the PatientID on the main form (I gave it different names because Allen ?? MVP recommended doing so :-). I think where I'm going astray is that I am not getting the value into the...

#error has been resolved - many thanks. Any idea what else I might be missing? Anne

Have amended and that works better. PatientID is an autonumber field and txtPatientID is the name of the field. I've tried that and also added some treatment numbers up to 8 to the underlying table. Now it just seems stuck at 9 and won't increment..and it shows 9 for both of my sample records...

Re: Electronic signature capture - Access 2010 - InkWindow? Hi Folks Would love someone's help with this! I've got that I probably need to add some sort of Active X control for the capture of the signature InkPicture? but how do I put that into the database so that it can't be changed. I can't...

hi VBAiNet Thanks for quick response :-) and appreciate the heads up on the syntax. Treatment number is number (Single) and when I tried your revised dmax (amended your one to show the table name first ...I now get an #Error message =DMax("Tbl_Treatment_Details","TreatmentNumber","txtPatientID...

Hi All I have trawled through the forums and I think I'm just missing one small piece here. I have a sub-form with a field (Numeric) called Treatment Number. Essentially what I want to happen here is that when a new treatment is added - the number increments from the last one e.g. the first...

Hi All I hope you are well. I've been looking through the forums here for a solution to the following.. How to capture a handwritten signature in a form and write it to a table. I found the Topaz systems solution and it's exactly what I need except that it doesn't work with the HP Touchscreen...