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

    Custom CMS Report - Too Many Skills

    Hi, I have about 100 skills I'd like to report on in the same report. The input field for split/skills only allows a limited number of characters. Problem is my skill numbers are not grouped together i.e. I can't just ask for skills 1-100, I need skills 45;67;38;145...etc. Is there a way to...
  2. chrisaroundtown

    CMS Script to Close Report after 30 minutes

    I'd like to run an interactive CMS Supervisor script that will automatically close after 30 minutes. The report will display a bunch of information that is only relevant to the call centre for 30 minutes, then I want the report to close so the monitor can return to displaying the information it...
  3. chrisaroundtown

    Return the next date recorded

    Hi, I am having a problem where I cannot return the next date recorded against an employee. For example, I have the fields row_id, start_date, employee_id, team_id I need a query to calculate the end_date for each record. The end_date would be the next recorded start_date for the same...
  4. chrisaroundtown

    Show number of direct reports in org chart

    Is there a way to show the number of direct reports a manager has in an org chart in Visio? Is there a way to include it in the contents of the shape or as a separate shape? Is there a way to do this automatically through the org chart wizard? Is there a way to show total number of...
  5. chrisaroundtown

    Group emails by Date

    Hi, I am an MS Outlook user from way back and have just started using Lotus Notes for emails. I'd like to create a view which groups my emails by date. How do I do this? A very easy task in Outlook but one which requires programming knowledge in Lotus Notes no doubt. Can't understand why this...
  6. chrisaroundtown

    Record Count Field

    Hi, I'd like a column in a query to show a record count next to each row. i.e. if I have got a query returing 10 records I'd like each row to have a number, which would be numbers 1 through to 10. Any ideas on how I can do this? Chris
  7. chrisaroundtown

    Maximise Form Window Problem

    Hi, I have a form displaying a staff members profile. On that form I have a button which opens a second form. I would like the second form to open up in restore mode while the first form remains open in the background and in maximise mode. When I open the second form it opens as maximise (as...
  8. chrisaroundtown

    Access Crash

    Hi, I have created a form in my MS access database and now every time I touch it MS Access crashes. The form contains a lot of labels, radio buttons, text boxes and some code. I cannot open it in any view, copy it, export it, analyse it, anything at all without it crashing. Does anyone have...
  9. chrisaroundtown

    Who's logged into my database?

    Hi, I have a main form which has hidden fields which record the username, time logged in and time logged out to a table. When the databsase is opened the main form launches through the start up and the username and time logged in fields are updated. If the user exits the database by using an...
  10. chrisaroundtown

    Find closest value without going over

    Hi, I have a table called 'Employ Status Change' and another called 'Schedule'. The table called 'Employ Status Change' shows when employment statuses have been changed. It has an employee ID, the employment status (Permanent, Casual etc) and the effective date. The table called 'Schedule'...
  11. chrisaroundtown

    Startup screen for Access db

    I once saw somewhere an access database that would display a startup screen when the database is launched. This would often be a company logo or product information for the database. It would only be displayed for a second or two while the database is coming up. Does anyone have any ideas on...
  12. chrisaroundtown

    Trying to find anything "*"

    Hi, I have a table with orders in it. I will enter in a report_month and try to count records which were ordered int the same month. This is easy enough however if I want to count all orders I will enter the report_month as "Total", it should then count everything. Below is my code, I am...
  13. chrisaroundtown

    Update Progress Bar

    I have a progress bar on a form which I show at the start of my code, I have set it to update the progress bar value at the end of my loop. The problem is that the bar isn't actually updating as I have turned screen updating off. Is there anyway to have only the progress bar updating without the...
  14. chrisaroundtown

    Send Excel Worksheet using VBA

    Hi, I am after a line of code to do the same thing as going to File then Send To Mail Recipient. Does anyone know how to do this? Thanks Chris
  15. chrisaroundtown

    DLookup problem

    I need to do a DLookup from a form however I want to test 2 criteria and not just one, how do I do this with the below forumula. =DLookUp("[Skl 2]","[Li Split Groups TBL]","[GroupName]=txtGroupName") Hence, this is asking for the field [Skl 2] from the table [Li Split Groups TBL] when...
  16. chrisaroundtown

    Crash and Burn

    I have a few reports which crash access whenever I try to open them in print preview mode or design view mode. Some of these reports come from crosstab queries and a few of them have sub reports. Access also crashes when I try to view the queries that are attached to these reports. Does anyone...
  17. chrisaroundtown

    Who's logged into my database?

    I was wondering if there was anyway I can see who is currently logged into my access database? Whenever I have to do work on the database it would be nice to know who is in it so I can get them out rather than searching forthe culprit. Thanks Chris
  18. chrisaroundtown

    MIN Problem

    I am trying to find the minimum values for a single record across a number of fields. For example, lets say I have the following data: Name Test1 Test2 Test3 LowScore Adam 30 20 25 Fred 45 15 35 Julie 40 25 30 I can use a Totals query to...
  19. chrisaroundtown

    Tough One

    I have text in a SCHEDULE field that looks like this...
  20. chrisaroundtown

    Speedo Chart in excel

    Hi, Trying to be a little creative with my excel charts I'd like a chart to resemble a speedo on a car dashboard rather than a plan old pie chart. Any ideas on how this can be achieved? Thanks Chris

Part and Inventory Search

Back
Top