Hi Couldn't you just set the "required" parameter to "yes" in the table design for that particular field? Then they have to put something in or the record ...
Try this: Private Sub cmdSave_Click() if isnull(me.myfield)then msgbox "Please enter myfield before doing this operation." me.myfield.setfocus exit sub end if ...
There are a lot of things Access does well in building the basic tables, queries, forms and reports that don't need VBA to work well. This is one of them. If...
... Hi, I have a demo on my website that will show you how to make certain fields required on your form. You can find the demo by following the link below. ...
Greetings! Background: I have a form with a header, detail, and footer sections. header - has several combo boxes, to dynamically alter the type of rows...
Sandra- Well, the "Dummies" books have always left a lot to be desired. It's silly to write code to do this when the form loads. Open the form in Design...
Hi John, I had first tried the suggestion to use Formatting/Conditional formatting etc. The field is a text field...tried field value is equal YES (and tried...
Are you sure it is a text field? check the field in the table design view and see if it is "TEXT" or "YES/NO". If it is YES/NO, then it is not a text field....
Hi Bob, yes, checked table-design ... the field is set at text.... thx, Sandra Bob Weller <bob_weller_tx@...> wrote: Are you sure it is a text field?...
If it is going to contain Yes or No, I would change it to a Yes/No field in the table design. It will better handle your data and reduce its size. Then you...
When you use this property "Required" and set it to "YES", You have to set the other one "Allow Zero-Length" to "NO" to be sure that the user will enter data...
Using Access 97, I am trying to create a query, VB code or a macro to return values from a field based on partial content. I need to get each record that ...
Microsoft uses a control that operates like 2 list boxes. The left column has check boxes that operate in multiselect mode. The right column has a list of...
Hi Neil, Sorry for late reply. Just wondering where or how should I add the scripting file object (Microsoft Scripting Runtime)? Thanks mate! ~Arnold~ Neil...
Hi, Has anyone used a datagrid and adodc in Access. Please let me know how can use both. Is there anyway I can do a spell check in my application Thanks PM ...
Hi Tom, How about: dim strFilter as string strFilter = "*" & Me!txtFilter & "*" where table-field LIKE strFilter strFilter for example would be: "*FL*" Tom P...
I have a form which I am linking a table to. I have several date fields which I want the user to access the Calendar control to populate the fields with a...
I typically place a small calendar button to the right of each date field, so the user can press the button to enable the calendar control for picking a new...
Hello all, I am using the popular API code that hides the access window and just shows a form on the desktop. (Small snippet below) Private Declare Function...
Lonnie, The following line will preview a report. DoCmd.OpenReport stDocName, acPreview If you want to print a report instead of preview it, try the following....
If you purchase your program can you use it in Access 2003? I mean can I copy it into what I am using and it will work? Right now nothing works. I don't...
you refer to 'frmXmplContactEvents? I am trying to find an example of a calendar control that is easy to understand. A Form a couple of text boxes a calendar...
Lonnie, Make a new toolbar, and attach it to your report. To the toolbar can add e.g. the print function, output to snapformat etc... On Tue, 2 Nov 2004...
Dear Neil, Gee.....I guess I'm thousands miles away and that could cost me a fortune (now in Australia, and sometime travel to Asia).......... Is it pretty...
... Well I've never tried it but it must be easy. - Make a frmGetPwd, make it a modal, dialog, popup - give it 1 text box to get the Password - Make the Format...
I've built a form for our case managers to add new clients to our database. I'd like at the end, either with a command button or the enter key to have the...
Open form in add mode bundled after a save this record type macro would do
what you want, I think, but you would be well advised to build this in
visual basic....
