Search results

okay I admit it! I'm avoiding really VB coding if I can help it:D

Hi, I have this table validation which I built using the VB expression builder: IIf([More MgSO4?]="Yes",Not IsNull([extra dosage]),MsgBox("Provide the dose!")) It doesn't work. If violated, how can I make this constraint give the message "Provide the dose!"

yeah my head hurts and I've spent too long on this already. Vanity be gone! Thanks

maybe its vanity;) but I just want the user entry to be in the format mmm-yy. If this is next to impossible, then dd-mmm-yy. How would I manipulate your code below to give this..? I tried but it didn't work:o

so in essence I want that field to record the date (preferably minus the day but...) for that particular record

the table records a number of incidents and at certain periods, an analysis will be carried out based on the month period and number of occurrences

really? what should I use then:confused: I'm seriously bummed by this one. Please see the attachment. The error also says "...you may have entered text in a numeric field or a larger number that the fieldsize setting permits" But the data type is Date/Time!!!:banghead:

we don't need the day just month and year... I guess I'll have to include regardless. Thanks CJ

okay what am I doing wrong? I have a date field on my form and used Input Mask L<LL\-0000;;* and validation rule <=Date$() I want the user input to look like 'Aug-2010' for example. but I get error: The value you entered isn't valid for this field :banghead:

hey CJ. No I haven't yet but that's the look that I'm aiming for. Thanks

phew! many thanks!

version 2010

I'm not able to do that either. It is greyed out:confused:

Hi, I made my form a pop up, saved and exited. Now I'd like to reverse this but the Form Design Tools Ribbon does not appear. How do I get the Property sheet for the form at this stage:confused: Could someone please advise?

okay Stopher, just seen your response. many thanks. I'll look at the video.

okay sorry forgot to add the attachment.

Someone help me please. This one is driving me bonkers! I'm trying to create a switchboard through which one can access data entry forms. Now there are about 13 of such forms but I've put only 3 here for simplicity. The idea is to have a button (on the main switchboard) represent each category...

Have a great evening/nite and many thanks for your patience.

okay, you'd told me earlier not to use "Yes" and I didn't want to mess up the program. But I get it :) It worked! Thank you!!!

just to be clear, are you saying replace this line of code: If Nz(![Tocolytic?], 0) + Nz(![Multiple Tocolytic?], 0) < 0 Then with this?: If ![Tocolytic?] = "Yes" Or ![Multiple Tocolytic?] = "Yes" Then