Search results

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...

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

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).]

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

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...

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...

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...

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...

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.

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