Jump to content

Scooter513

Member
  • Posts

    16
  • Joined

  • Last visited

  • Donations

    0.00 USD 
  • Country

    United States

About Scooter513

Scooter513's Achievements

0

Reputation

  1. I would suggest using one of the following sites: globalcomputer.com ZipZoomfly.com I have used both of these for numerous projects over the last couple of years, and have been very pleased with their service and prices. My personal favorite is ZipZoomfly based on the fact that their prices are usually lower then other sites, and they have free shipping (2nd day air) for the majority of their products. Hope this helps, Scott
  2. I don't know of any other way for you to increase the size of the field other then adding spaces as the default text. Depending on how complex you want to make this, you could add some code to the document to highlight the whole form field when you click in it (see information below) Enter the following informaiton into a Visual Basic Module (Substitute Text1 with the name of the field) Sub Select_Text1() ActiveDocument.FormFields("Text1").Select End Sub Then select it to run the macro on entry into the field.
  3. I know it’s not the best solution, but one thing you could do is add a lot of spaces as the default text (in Form Field Options).
  4. Another free software to consider for cleaning up temp files is CleanUP http://www.stevengould.org/software/cleanup/
  5. I'm not sure exactly what you are looking for based on this post, but I will try my best to answer the question. When using a form to enter data, it is possible to set a default value for any field. In the Design Mode for the form, go to the field properties, and enter data in the Default Value option. If this isn't what you are looking for, or you have additional questions, please provide more detailed information of how your db is set up, and what/where you would like to happen. It would also be help to know what version of Access you were using. Thanks, Scott
  6. Have you considered converting the document to a form? To do this, all you will need to add Form Fields to the document (easiest way to add them is by using the Forms toolbar). With Form Fields, you have the option to display shading for the fields, but it doesn't actually print (see sample below). Here is a quick overview of how I created this document in case you haven't used this feature before. Make sure Forms Toolbar is visable (View --> Toolbars --> Forms) Click in the Cell/Area where you need the field to be Click the 'ab|' Button on the toolbar to add the field Make sure that the Form Field Shading option is selected Make sure that the Protect Form option is selected In this sample, I had also double clicked on the Date Form Field (prior to protecting form), and changed the type to 'Current Date' so that is automatically populates the information. Hope this helps, Scott
  7. You have 2 basic options for this depending on what you are trying to accomplish Configure them as a Delegate in Outlook Select Tools --> Options from the main Toolbar Go to the Delegates tab and Click Add In here you can configure whatever permissions are necessary for all aspects of Outlook. You also have the option to configure how meeting requests will be handeled. If you check the box highlighted in red, the admin/employee that you are setting up permissions for will receive all of your meeting requests instead of you. After this has been completed, the other person will have to configure their outlook to open the additional mailbox. Share your Calendar with them In the 'Navigation Pane', select the 'Share My Calendar...' link In here you can add additional users and configure the type of access that they will need. Once you have added their permissions, the other person will have to click on the 'Open a Shared Calendar...' link in the 'Navigation Pane', and add your user name. If you have additional questions, please let me know. Thanks, Scott
  8. Here are a couple of quick ideas that may or may not work in your situations Password Protect the documents The main problem with this method is that either the password is used too much and everyone knows it, or there are too many passwords to remember and people have a hard time opening the documents. Store the documents on a Server, and provide links in the Meeting Request You could create groups based on criteria (Director / Manager / Supervisor / ...) and store the documents in the specific folder created for each group, or in the lowest level required provided that everyone above them also had access to that folder. Mark the Confidential Meetings as 'Private' Using this method, you could share your calendar with everyone, but only allow specific employee's (Secretary, Administrative Assistant, ...) access to view the 'Private' meetings.
  9. Changing Reminder Options To turn off the automatic reminders, select 'Options' from the Tools menu, and then uncheck the 'Default Reminder:' option Note: Changing this will only apply to meetings that you set up, and not requests that you receive. Appointment Length I'm not sure what you mean by changing the Default Time Span. When Creating an appointment in Outlook, it will schedule it based on what you have highlighted on your calendar. If you Double Click on the Calendar to set up a new appointment, it will always be for 30 min. If you highlight the hour, and then Right Click or use the toolbar to set up the appointment, it will be for one hour. Hope this helps, Scott
  10. Typically the Error will be highlighted when it tries to run/compile the code. Based on the attached picture, it looks like there is text highlighted behind the pop-up error box, but due to the placement, were are unable to view the code. Could you post a new picture/code to better analyize the situation. Thanks, Scott
  11. This query will search every row in the database individually, and return results based on that specific row. Unless I am completely misunderstanding what you are asking for, the information above should do what you needed it to (I have added an image with the detials to help show what it does). My sample checks the data in column 3 against 2, not 3 against 1 as you just listed, but based on the fact that it is only checks column 3 IF 1 and 2 are the same, it shouldn't matter which column you use for that check. If this is really not what you are looking for, please post a sample of your Table Structure, Sample Data and Expected Results so I can better understand what you need. Thanks, Scott
  12. Sorry, I should have stated that this option will only work if you email is formatted as 'Rich Text'. On the Standard Toolbar in Outlook, select Tools --> Options Select the 'Mail Format' tab, and choose the 'Rich Text' option in the 'Compose in the message format:' field As far as I know, there is no way to do this using the 'Plain Text' or 'HTML' format messages, and if you are unable to use the 'Rich Text' format for some reason, you will most likely have to continue to type it out the long way.
  13. The following information is based on a Table with 2 date fields of Start and End Create an expression in your query by typing the following informaiton in the field of a blank column Abs([start]-[end]) and then list a Criteria of >1 for that field Hope this helps Note: I used Start and End dates for the example, but had added the Abs funciton to reture the Absolute Value of the formula, which would allow the start date to be before or after the end date, enabling it to have a 1 day difference in either direction.
  14. This can be accomplished by adding 2 Expression Fields to your Query, and then limiting the results based on the Criteria of those fields. The information below is based on a table with 3 fields named A, B and C Build the Query like normal with the necessary fields In blank columns, build the following Expressions by typing the following information in the Field and Criteria fields. [A]= -1 =[C] <>-1 Or Is Null When you enter the formula in the field, it will look like this ‘Expr1: [a]=’. You can change the text before the : to whatever you want the filed to be named in your Query (Example Test1: [A]=) What this will do is show any rows were A and B are the same (-1 = True) AND where B and C are not equal or when it is not able to compute (Blank Fields) --> see image for example Hope this helps
  15. You can use the following steps to insert the Hyperlink 1) Click on Insert --> File from the toolbar 2) Browse to the file like normal 3) After you select the file, click on the drop down arrow next to the Insert Button, and select 'Insert as Hyperlink' Hope this helps
×
×
  • Create New...