Search results

  1. A

    Really new to this query stuff,please help

    Access Report Hello HopelessITStude, You need to adjust the page margins to accomodate the contents of the report. You can access these options during the preview mode, or you can access them through the file menu during design-time. If the objects that are contained within the report are...
  2. A

    Continuous Form & Current Record

    Thanks for the information smallh. I will consider how I can implement that idea. Kind regards, Aaron
  3. A

    Access ListBox

    I want the user to be able to click on the label for sorting, etc.. I could use a list view for this purpose, but I like to work with controls native to access. I have notice that as you scroll left and right within a list box, it jumps a 'whole' field at a time. So, I thought that I could...
  4. A

    Continuous Form & Current Record

    I would like to be able to alter the color of the currently selected record in a continuous form. Has anyone done this before or can offer any suggestions?
  5. A

    SQL error

    The parameters declaration also has the bang(!) operator instead of the period before [Text17] Text (255)...
  6. A

    Access ListBox

    Hi, I am looking to programatically change labels outside the basic listbox when the user scrolls left or right. Does the Access Listbox control expose as a property indicating which field is [the left-most] visible when scrolling horizontally? Maybe, possibly, using a call-back function...
  7. A

    Create Records with Range

    I think your answer may be in the post by FRIDAY titled "Insert New Records with Range of Values"
  8. A

    Save As Dialog

    Save as Dialog Anthony, It seems that you have to provide the FileName argument of the TransferText method from within VBA. So you will have to collect the information prior to calling the method. (I believe if you use a macro and do not provide a FileName/Destination you will be prompted...
  9. A

    Logging the control that caused error on form

    mikeco555, For my error handling I have written a handler. Although I am not storing the errors that occur, I do use the 'currenlty active control' along with the error to determine which error message to present. The syntax for it is ErrorHandler(Err, Me.name, Screen.ActiveControl.name). I...
  10. A

    Null Problem

    mohammadagul, In the past, I have used the MSAccess Application Public Method NZ(). The syntax of the function is: Nz(Value, [ValueIfNull]). Kind regards,
Back
Top Bottom