Re: Required Fields in a form

Tech-Archive recommends: Fix windows errors by optimizing your registry



You haven't described the network, the PCs, the version, or whether the
application is split front-end/back-end. You haven't mentioned table
structure or indexing, or ...

All of these may be factors ...

--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/


"tahuero" <tahuero@xxxxxxxxxxx> wrote in message
news:1142865744.352811.34720@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I am trying to make several fields in a form required. I do not want to
set the required property in the text box, but rather in the form. I
set up a macro to enable certain fields to be available only after
others fields are populated with information, but I think that is
causing my database to run slower over a network than it needs to be.
Is there a better way to make several text boxes required without using
a macro?


.



Relevant Pages

  • Required Fields in a form
    ... set the required property in the text box, ... set up a macro to enable certain fields to be available only after ... causing my database to run slower over a network than it needs to be. ...
    (microsoft.public.access.forms)
  • RE: Run-Time Error 1004
    ... why don’t you try turning the macro recorder on then open ... for writing and testing macros before placing them on the network). ... Dim strMYear As String, strMMonth As String, strMExist As String, strMName ... ' Select Monthly Chemistry Data worksheet and copy data to Monthly Template ...
    (microsoft.public.excel.programming)
  • RE: Import Excel data - File not open
    ... excel file located on the network. ... Here is what the macro is doing, incase you notice something odd here: ... try a different spreadsheet to see if the same thing happens. ... Can I add a command to my macro that opens the specific spreadsheet, ...
    (microsoft.public.access.externaldata)
  • Re: Copy DB file to new location, and open without warnings
    ... Private Sub Form_Load ... ' If the network path does not exist then just use the local copy ... the macro code attached to the OnClose ... Show a warning "Network is unavailable. ...
    (microsoft.public.access.formscoding)
  • Re: Copy DB file to new location, and open without warnings
    ... Private Sub Form_Load ... ' If the network path does not exist then just use the local copy ... the macro code attached to the OnClose ... Show a warning "Network is unavailable. ...
    (microsoft.public.access.formscoding)