Search results for query: *

Now that's clever ! why did'nt I think of that.....! thanks DougyP your a gem. Best rgds Nick

I wonder if anyone can help please I have a form based on a table which has one field and which contains 3 days of the week, mon, wed, and thurs. I refer to these dates from a list in a main form. I have to manually enter the dates in advance which is a bit time consuming and I wondered if there...

ok many thanks for your help i am going to try this one, it does'nt look that simple but I like a challenge thanks again Nick

G'day all would anybody have an example which shows how to test a form for validation in the before update section. I am trying (without much success) to check to see if all the controls / fileds have been completed, before closing the form. I would like to do this with a VB yesno if I could...

Hello all I am trying to check my various controls 0n a form with something like the following If Isnull me.XXX then control. set focus. cancel=true what I think I need is to get my code to check all controls in one piece of code rather than duplicate my code for every control,and then say, a...

wonderful....many many thanks indeed best rgds Nick

Hi and thanks fopr the quicko response fromyou both. Jimlee could you go a little deeper for me as this is new to me The Int answer piece goes red ! and IO don't understand ? do you have a more complete example ? Many thanks Nick

Greetings all would you help with the following please I want to prduce a report on a vb yes no box, I have the first bit, but my report prints on both the yes answer and the no too ! could you fill me in please or is there an easier way than my attempt ? Private Sub Command81_Click() On Error...

many thanks for your quick reply now it works for me ! Rgds Nick

good evening all would anyone please be kind enough to show me how to use the Len expression in a query pane I Have so far this much expr:len([name]) but I would like to show only the first 4 characters in the query result, so far I only get the number of names thanks nicky

Yes ! wondeful. thankyou so much....beer's on me. Best rgds Nick

Hi ther grandkathy many thanks for your reply I put this in and it works up until here and seems to have a problem with this bit .Open "ltblKeyWords", cnn, adOpenDynamic, _ adLockOptimistic I am in XP office by the way, I am not sure which version that is apart from Office XP...

Could you help with the following please I have a combo box that I wish to add a name if not already on the combo list / Table. Is there a way to check and then ask I want to add the new record to the table and therefore combo afterwards using VB many thanks Nick

Hi there again that worked just beautifully ! and also helped me to understand. Could I prevail on you to explain on other thing for me. Could I have used the Control scource for referencing the name of this public function or is that something completely different ? rgds Nick

Many many thanks for your quick reply, I will work on this. thanks also for your explanation. best rgds Nick

hi everyone could you help me understand public functions or global things with the following example please. I have the folowing piece of code which helps me to "check digit" an eight figure number.It is on a bound text box in a form and only refers to that text box.IE using "Me" What I would...

Thanks p27 and Zameer this is new to me, would either of you have a simple example on hand that I could try to understand ? thanks and regards Nick

Firstly happy new year all. I wonder if one of you good people could show me the way to make the following available to all forms rather than just one control on one form.I think they call it a global I have the following check digit code for an 8 figure number, using the mod method.This...

Hi Mark well I've tried just about everything it works ok on the after update but again all of the rows, even with a PK field added. I know its a bit of a cheek, but would you take a look at it for me, I would gladly buy you 20 beers when I am next in NYC , which is normally twice year !. It is...

ok thanks Mark I will give it a try. Given the time diff are you in the USA? Rgds Nick