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...
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...
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...
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
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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.