Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Drisconsult

    Indesign 5.5 dimensioning and arrowheads

    After 20 years with Ventura I now have to migrate to Indesign (5.5). I need to dimension lines with arrowheads. It seems an impossible task with Indesign - or is it. With Ventura it was a delight, with InDesign its a bloody nightmare.
  2. Drisconsult

    Access 2007 Startup procedure

    Hello All Is the Startup procedure still available in Access 2007? Although it recognises my previous startup procedures from Access 2003, I am unable to modify this procedure, even after saving under the new file format. Does the Startup procedure still exist in Access 2007? Regards Terence
  3. Drisconsult

    Access 2007

    Hello All Just beginning my change-over from Access 2003 to 2007 and actually wondering why I am doing this. Does anybody know how to clear the "Getting Started With Microsoft Access" startup page as well as all the templates that are listed. It must be possible to start with a clean interface...
  4. Drisconsult

    Converting the Refresh Command Button to VBA

    Hello All I am at present, converting all the macros in my library of databases to VBA. The only problem I am having is getting rid of the Refresh Command Button and simply having VBA code to refresh a Form underneath a Label. I have never really liked these buttons as they tend to be too big...
  5. Drisconsult

    The dreaded apostrophe

    Hello All I am updating a university Teacher Traing School Placment program. Here student teacher's are assigned to schools. There is a large table of 450 schools. Many of the schools have apostrophes in their title such as: City of London Girl's School This is how they wish the school to be...
  6. Drisconsult

    Searcing on three digits only

    Hello All A couple of years ago I completed a program for a college to place trainee teachers in various schools on teaching practice. Most students were allocated schools within their London post codes. I have just received a request from the college, asking me if I can modify the search...
  7. Drisconsult

    Custom links

    Hello All I have a 250 page document created in Ventura V10. I now have the same doument in Adobe V6 format. There is a Contents page on page 3 of the PDF file. At the moment I am creating a link from page 4, on to page 250, so that the user can return to the contents page by clicking on the...
  8. Drisconsult

    Acrobat V8 background colour

    Hello All I have just upgraded from Acrobat V6 to V8. As usual I went to the Preferences to create the same setup I had with version 6. There is a background colour option. Here I opted for a very light blue. However, I got no such thing, only the same almost black background colour. Is this a...
  9. Drisconsult

    creating an error message for an update query

    Hello All Previously, I have been helped by the people who know what they are doing when I asked for help in providing an error message if the user enters and incorrect ID in a paramter query. I have successfully implemented the advice given to me. Now I have a similar problem with an update...
  10. Drisconsult

    Assigning converted macro to a command button

    Hello All I have just started to convert all my macros to VBA. I have no problem with assigning the converted macro to a label using the following code: Private Sub LABEL01_Click() Call mcrOPEN01 End Sub However when I try to use similar code for a command button, I get an error message...
  11. Drisconsult

    Returning a message box if a form is blank

    Hello All I have a parameter query that opens a report. I have a parameter query that opens a form. I am aware of the On No Data property available for providing a message box when a user enters data into a parameter query and the report is empty. Is there such a procedure for providing a...
  12. Drisconsult

    Need to show random week numbers in a query

    Hello All I have written an accounts database for a friend. At the moment I have four reports showing: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter These are based on Select queries where the criteria widow has the following code for the 1sr Quarter: between "01" and "13" This works fine...
  13. Drisconsult

    Creating a password macro for an Access form

    Hello All I wish to create a password macro for a form that edits library data so that only authorised people can make the necessary edits and deleted. Thanking you all in advance Terence
  14. Drisconsult

    Multiple count problems involving the first letter of a field

    To my esteemed colleagues who have helped me on a number of occasions, here is my latest problem: I have a Media Data Entry form where customers enter a code for DVDs, such D2340, or Games such as G4267 and CDs such as C7345. The first letter defines what type of media it is. How do I count...
  15. Drisconsult

    How do I sum this Field?

    I have the following Field; Name: PENALTYCUSTOMER Control Source: =[DAYS]*[COST] Format: Currency Days are equal to the number of days overdue Cost is the daily cost for each item overdue How do I sum this Field? I am at my wits end. Regards Terence
  16. Drisconsult

    Creating a link to the Desktop

    Hello I have a pdf menu with links to other pdf files. No problem with this area. However, I would like to create a link from the menu to close the menu and Acrobat down, so that the user is taken to the Desktop. I can create a link to close the menu down, but I am still in Acrobat. I am using...

Part and Inventory Search

Back
Top