Recent content by steve ferry

Rural Guy you where right I was selecting 1 of the pages not the tab control. Thanks sorry about getting back to you so late had a easter break thanks. Steve Ferry

Really simple one for all you folks out there, but I've just been struggling for 20minutes and thats it I've decided to to seek proffesional advice. Though its been said I need it in other areas of my life too (so my ex says but..), any way I digress. I put a tab control on a form all I want...

Thanks ken will do, that sounds the way ahead. sorry for the delay in getting back, been a very busy weekend :D

Okay, I have a unbound form with three combo boxes the selection of these three & then clicking of a filter button opens the relevant form showing records based on the selection. Great that bit working, no major feat. Trouble is when I select three criterea in the combo boxes that no...

strings & variant(strings) thanks Pat but problem sorted. I was just looking throught the object browser when I came across Cstr. I replaced str$([Related SEQ TA]) with Cstr([Related SEQ TA]) apparentntly Cstr is what I should of used as it converts numeric to strings wereas str$ converts...

thanks Pat but problem sorted. I was just looking throught the object browser when I came across Cstr. I replaced str$([Related SEQ TA]) with Cstr([Related SEQ TA]) apparentntly Cstr is what I should of used as it converts numeric to strings wereas str$ converts numeric to Variant (strings)...

Thanks for the advice Pat unfortunately its not the answer SEQEL still not getting above 1. Been suggested to me I have to go down the rout of unbound forms & have code running on it but this leads me up another avenue of submitting data, when and where, also Editing and deleting data really...

Problem Multi-level numbering. I consider myself a moderate user of access a little out of my depth here I hope someone can help. I have a multi level numbering system based on the Dmax function as follows: Me!SEQEL = Nz(DMax("[SEQEL]", "[Task_Analysis_Elements]", "[Related Job Position TA] =...

The db will be chiefly for my use, but other individuals may wish to use it from time to time. There will be only one user at a time accessing it. I think I see what you are suggesting in terms of a multi-user enviroment and integretity of continuous forms in continuous forms. You've got...

"That's not actually strictly true", this statement raised a smile seemed like a 6 of one and 1/2 dozen of the other answer. Anyway thanks for your reply, having read your posts throughout this forum you seem a very helpful and knowledgable person. If you'd like to share your train of thought...

Three crow, just a brief overview what I'm aiming at. I have a Job that is broken down into tasks. Job on the main form task on a subform. The general details of the task are on the subform. click a button on the Job main form and a task sheet main form appear, with a subform which breaks...

What I am trying to do is put a subform within a subform. The trouble is I want both forms to be continuous forms. when I put the subform within a subform, access comes up with the following message: ********************************************************************** A form with a subform...