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!

Register Log in
  • Congratulations derfloh 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. iainrkemp14

    concatenation

    I am trying to write an update query that will update column B with 5 zeros and the contents of column A. For example: Column A = 12345 Column B = 0000012345 How can I do this? I have tried "00000"&[Column A] but that doesn't seem to work. Cheers, - Iain
  2. iainrkemp14

    getting the Very Last Login from series of columns

    Hi all, I have a table that shows name, id number, and last login. It has 21 last login columns (with the more recent checks being the furthest to the right). If the person's last login was in LL4 (last login colum 4), 1-4 would hold dates, and 5-21 would be empty. If the last login was in...
  3. iainrkemp14

    browser can't open form

    We are currently running an instant messaging application that is run through the web-client using javascript. It is launched by clicking on a link that launches the messaging window. The url for this link end as shown below: "/WebConnectLaunch?OpenForm" Some users are unable to...
  4. iainrkemp14

    pop-up window not popping!

    We are running Windows 2000, and IE 6. the application uses javascript. cheers
  5. iainrkemp14

    pop-up window not popping!

    We are currently running a web-based messaging application. To launch it a user must click on a link in an Internet Explorer window. When clicked, a new window appears prompting for username and password. This is working fine for the majority of users but there are a handful who do not see a...
  6. iainrkemp14

    outlook 2000 - active buttons

    Thanks a million - that did the trick!
  7. iainrkemp14

    outlook 2000 - active buttons

    I am trying to send out an active email that will allow receptients to response by clicking a button (much like meetings requests etc). So far I have found a drop-down list for 'voting buttons 'with: approve/reject yes/no yes/no/maybe Is there any way that I can make up my own options for...
  8. iainrkemp14

    Colors in Charts

    I have a report that is laucnhed from a form, in the form you can pick the region whose information you want to display. The report that is returned includes a pie-chart. There is a maxium of 5 slices that make up the chart (A-E), and each slice is given a different color by selecting 'vary...
  9. iainrkemp14

    incrementing numbers in Excel

    awesome - Cheers!
  10. iainrkemp14

    incrementing numbers in Excel

    Hi all, This may be a pretty easy thing to do, but I can't do it and its driving me crazy! How can I set up Excel so that if I put the number "1" in cell A1 for example - when I pull the fill handle down it increments the numbers? Essentially I want to make a list in column A from...
  11. iainrkemp14

    totals

    Thanks, I've tried this and doesn't quite work. The problem is the 'Hourly Rate' that is referred to varies slightly between records (some our 54, some 30, etc). In the Project_Name_Header it matches the related 'Hourly Rate' and 'SumOfHours' records. When I put 'Hourly Rate' in the report...
  12. iainrkemp14

    totals

    Thanks for responding! I have tried to do that but never seem to get the syntax quite right, perhaps you could help? Label39 is a calculated value: =[Hourly Rate]*[Label48] Label48 is a calculated value: =Sum([SumOfHours]) I tried the following without success: =Sum([Hourly...
  13. iainrkemp14

    totals

    Hi all, I am currently having some trouble trying to total something. I have 5 'text boxes' in a Project_Name Header. One of these text boxes is called 'Label39'. In my report footer I want a text box that displays the sum off all the 'Label39' instances. I have tried =Sum([Label39]) but...
  14. iainrkemp14

    outlook - email help

    Hi all, I am currently trying to find a way to email a group of people a list of options to select from. They will have 5 options and need to select one. Is there a way to do this using radio buttons or something similar so all they need to do is check a box and hit reply? Cheers, - Iain
  15. iainrkemp14

    drop down menus in Excel

    thanks!
  16. iainrkemp14

    drop down menus in Excel

    Thanks all - that looks like just what I need. I did have some trouble calling the 'list' from another sheet in the same workbook. Is this possible? Or is there a weay to hide the list that is the source for the drop down? Cheers, - Iain
  17. iainrkemp14

    drop down menus in Excel

    Hi all, Does anyone know how I can put a drop-down menu into an excel spreadsheet? I have a registration chart for people to complete, and in the fourth column I want to have a drop down menu for them to select from the list. I'm sure I've seen this done before but can't figure it out. Any...
  18. iainrkemp14

    decimals to INT

    Hi all, I have atable full of data, a lot of which is decimals (ie, 1.423). Does anyone know a solution for changing all this data to whole numbers - perhaps an update query or something? Ideally I would like to round everything to the nearest whole number. Cheers, - Iain
  19. iainrkemp14

    from all-caps to normal

    Hello again! - ok, here's the next question. I currently have 2 columns (first_name and last_name). However some people are entirely in CAPS and I want to change them to standard. example) KEMP >> change to >> Kemp Any thoughts would be greatly appreciated! Cheers, - Iain
  20. iainrkemp14

    creating full names

    thanks!

Part and Inventory Search

Back
Top