Search results

Hi Gary, Thanks for the speedy response, not sure I understand what you mean though! All the fields on the subform are using completely different queries to pull the data in, and as none of these fields are on the field list for the master form, how would I make a table with these fields in...

Hi all, I wondered if anyone has got Super Easy Mail Merge to incorporate subforms when doing the mail merge at all? It does just what I want it to do, but isn't picking up any of the fields from my subforms. Here's the link to the information & sample database, you just have to import the...

Ahar, super duper :D Working brilliantly! I actually feel like I've accomplished something today, many thanks for your help :D

Ahar I figured it out!!! It doesn't quite work as intended as it doesn't show the values when the form appears but it does populate them through to the table: Private Sub cmdSaveRecord_Click() On Error GoTo Err_cmdSaveRecord_Click Me.SpecimenID.Value =...

I use options explicit and it throws an error without the declarations. The fields of SpecimenID and PatientDetailsID on the form where the data is entered are named as such, however their control sources are as I posted above - I'm not sure if this is what you're referring to?

Nope. Still not saving the data. I tried changing it to PatientDetailsID rather than NHS Number to simplify things (patientdetailsID is an autonumber & PK for PatientDetails table). Here's the code: Private Sub cmdSaveRecord_Click() On Error GoTo Err_cmdSaveRecord_Click Dim SpecimenID As...

Ahar, n00bie points for me ... the field in the table wasn't large enough *hides in a corner*

Guess I'm doing something wrong, I get "Overflow" error popup?

Hi Ray, Would I put that somewhere in the VBA for the cmd button? Yes I do have a "Save Record" button but had not thought to add this to it. Private Sub cmdSaveRecord_Click() On Error GoTo Err_cmdSaveRecord_Click DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70...

Ray, Sorry could you clarify that a bit for me, as I'm somewhat confoozled by what you mean! Put an unbound text box I got as far as, but no further!! :$

Yep, the subform is linked to the main form via the PatientID & NHS Number

Hi all, I've got a setup with a Master form: frmPatientDetails And a subform: Specimens which is tabular, based on a form "frmSpecimenDetails" which runs from a query "qrySpecimenDetails" On the subform for each specimen there is a button (cmdAddAdmission) which opens the form...

A potentially easier way (and to avoid syntax errors) might be to click on the "..." button beside the Control Source box on the properties of the item you want to update, and then "build" the event by navigating to the form you want to pull the info from, and the field. Might be of use :) Ruth

Wish I had spare time! I do quite a bit outside of work, if that's what you mean! - Run my business Suffolk Computer Services - Play field hockey (Goal Keeper) for Ipswich Ladies - Adult Leader for a Gold Duke of Edinburgh's Award group - Adult Leader for a newly-forming Bronze/Silver/Gold...

Thanks for the thoughts Chris, much of what you've said are exactly in tune with my thoughts - at the moment I am not really big enough to warrant an entire office however in the future having somewhere formal for big meetings/presentations would be useful, and I know of a few office places like...

I have the HTC TYTNii / AT&T Tilt and I have to say it's an awesome phone. It has everything in built as standard that I wanted - full HSPDA, GPRS & EDGE (whatever that means anyway, but it means I can get net access anywhere!), GPS in-built, Wifi in built and so forth. The massive advantage...

If you want to chat about web stuff give me a prod - I run an IT Support/Website Design company specialising in Content Management Systems which sounds like it would fit your needs perfectly, with very strict security systems in place and so forth. Ruth

Just looking for some opinions really, I run an IT Support & Web Design firm and have done for a couple of years, we're actually booming at the moment which is quite suprising given that many are feeling the pinch of the credit crunch! At the moment I run the business in evenings/weekends...

Just incorporated my company, in the UK you no longer have to appoint a secretary, so I am a sole director. I have used my accountant's address for my registered business location but I believe you can use anywhere, but be aware of local regs - you might need to declare the property as a...

Not far off £400 now guys, £391.50 - many thanks to Fifty2One your letter arrived today! Ruth