Search results

  1. gselliott

    Listbox ControlTip

    Is it possible to show a control tip style message box when you click on a certain row in a list box? So if I clicked on a particular row it would show me the control tip text which would be from one of my fields in that row?? Thanks.
  2. gselliott

    Admin File

    What does the Admin File actually do? we are having a few problems where we get an error message saying Could not use 'Admin'; File already in use.. I was just wanting to know what this file is used for. Thanks gselliott
  3. gselliott

    Admin File Locked

    I am experiencing some problems with Access 2000 Databases, when a user tries to open up the Database they sometimes get a message saying the Admin File is Locked other times they can login as normal. This has just started happening to a number of our Databases and the only way we can seem to...
  4. gselliott

    Reference Problems

    I am experiencing a few problems with References when I create a database running Access 2000 on a Win 2000 PC. The database will work fine on my PC but when it is run on another PC via Citrix using Access Runtime the Database will throw up runtime errors. When this happens I have to logon...
  5. gselliott

    ListBox Focus

    Is it possible to set the focus to the first row of a ListBox when the form opens? Thanks in advance.
  6. gselliott

    Write Conflict Error

    Is there anyway of stopping the Write Conflict message box appearing and automatically selecting 'Drop Changes' ? I am using a Multi User Helpdesk system and this message only rarely occurs when two users try to accept a job at exactly the same time. It would be useful if this message could be...
  7. gselliott

    Records from a List Box

    I am wanting to be able to click on a record in a List Box and then display the relevent record info on a seperate form, is this possible?? Thanks in advance.
  8. gselliott

    Refreshing in Multi User environment

    I am in the process of creating a new helpdesk database that will be used on a number of PC's eventually running via Citrix. The jobs will be entered into the system by one person and ideally everyone else will be able to select and accept the jobs from a list box as they come in. I have...
  9. gselliott

    Combo Box

    I have got a Combo Box that is referenced to a table and shows 2 columns, what I would like to do is when I select the value from the list (column 1) I want the corresponding value in column 2 to be placed in another text box on the form is this possible? Any help would be appreciated.
  10. gselliott

    Deleting Directories

    I am wanting to automatically delete a Directory when I click a button on my form. I have searched the forum and found the RmDir command but I am unable to get this to work, has anyone any ideas? Thanks in advance.
  11. gselliott

    Display the current Day

    I am wanting to set up an Update query that will display the current day (eg Monday) I have managed to set up the date and time but not sure how go about showing the day. Any help is appreciated. Thanks
  12. gselliott

    Exclude Multiple Values from Query

    I know this is probably very easy but I just can't think how to do it. I want to be able to exclude any records in my query that have certain codes (4 codes) I can get the query to work excluding only 1 but it will not work with any more. Anyone any Ideas I have tired <> "Code1" or <>"Code2"...
  13. gselliott

    Calculations in a Query

    We want to work out whether we have met our deadlines or not. Currently we have a Fix By Date field and a Date Completed field. We want to be able to work out the number of calls that were completed within time against those that were not, ideally we want to display these figures as a...
  14. gselliott

    Calculate Date

    I am wanting to work out the number of months in between two dates that are input into my form. The date format is dd/mm/yyyy. How would I go about this? Any ideas would be appreciated! Thanks in advance.
  15. gselliott

    Transparent Images

    I am wanting to use an image which has a transparent background on a form but each time I place the image on the form it puts a white or balck background on the image instead of having it transparent as it should be. I have tried all of the various image formats jpg, gif, tif, png etc but none...
  16. gselliott

    Message Box

    I have set up a procedure that exports a query with a large amount of data in it and is taking some time to export so what I would is to display a message box saying something like "Export is running please wait..." which has no buttons on it and will automatically disapear once the export is...
  17. gselliott

    Number Field Format?

    I am having problems with the format of one of the number fields in my Table it was originaly setup as currency format with Auto decimal places. This was working fine but I am now exporting some of the data into a Text file (after calculations etc) so this can be read in by another program...
  18. gselliott

    Access and Outlook

    Does anyone know if it is possible to send and Assign Tasks from Access using the Redemption.dll work around? I have managed to get this working for standard email messages but not with assigning Tasks. Anyone any ideas?
  19. gselliott

    Outlook Redemption

    Help! Outlook Redemption I have got a helpdesk database that emails tasks via Outlook (2000), using Citrix. This has been working fine until we installed the latest office service pack and then we got all of the security messages from Outlook when trying to send the email. I know that we...
  20. gselliott

    Link another Query to a Report

    Is it possible to reference a text box on a report to a field in a query? I am wanting to use a total from one of my queries in a report. Thanks
Back
Top Bottom