Search results

  1. D

    Finding times greater than an entered value

    Try adding another field to your query and call it, lets say TimeDif with this expression Format([DispatchedTime]-[CompletedTime],"General Date") So the field would look like this: TimeDif:Format([DispatchedTime]-[CompletedTime],"General Date") And then in the criteria row for the TimeDif...
  2. D

    exporting a report to an email

    I'm assuming you are using the Docmd.SendObject procedure. I have found that setting the format to acFormatRTF (Rich Text Format)works best for me. Although I still had to do alot of tweaking on the report before I got it the way I wanted. hth dj
  3. D

    Icons

    If you don't have a shortcut to your database yet create one. Once created right click on the shortcut select properties and select the change icon button and then find the path to your downloaded icon DJ [This message has been edited by DJBummy (edited 07-04-2001).]
  4. D

    auto fit to screen forms

    I would be interested in that module anuaz. Thank you. DJ
  5. D

    Changing Input Mask

    Hey Ryan I tried both of these on a test form and report. And they printed out with the spaces and also stored in the table with the spaces. I'm using Access 2000 I don't know if that makes a difference. I don't see why it would. Maybe it has something to do with the background on the report...
  6. D

    Simple open form questions

    How are you I'm relatively new to access myself. Here is a sort of help that I use to help teach myself the vba code used in command buttons. Create a test database for yourself with test forms and tables etc. Use the command button wizard to create different buttons and then view the code and...
  7. D

    Changing Input Mask

    Hey Ryan You need to go to the table in design view and change the field size to a larger number than 50 maybe to something like 100. There was two things I was wondering. 1.Why do you need so many space between the numbers. 2.Is having this many spaces going to drastically change the size of...
  8. D

    Changing Input Mask

    Hi Ryan You can do pretty much the same thing as for your zip code. Did that work for you? Use the quotes as Don suggested or the capital C or number 9 wherever you want a space. If you want more information on this, enter InputMask Property in the index of your help and scroll down to see the...
  9. D

    changing fields

    You could add this to the input mask for the zip code control. 0CC0CC0CC0CC0. Only Problem is when entering a new zip code you will have to include the spaces when typing it in.
  10. D

    Hiding Combo box on form

    How about this. Not sure what event you would want to assign this too but I use this to hide a combo box. [The name of your combo box].visible = False and change to true when you're ready to use it again. It can't be that simple but maybe you can use it anyway. Hope it helps. DJ
Back
Top Bottom