Search results

  1. M

    DB Clear Down

    Ok point taken Depending upon how your network is set up, you can send everyone a message through the network. NETSEND is one such application, go to nonags.com there are lots of freeware programs to send messages over the network
  2. M

    DB Clear Down

    I know this is old fashioned but it normally works: Can you not ask them to log out of the database. At least that way they are aware of what is happening. If you justy log them out they may not have saved their particular record or they may try to get back into the database and worse still...
  3. M

    Calendar - Not able to select in "Future"

    And we have all heard of the training Helpdesk staff get !!!!!
  4. M

    Calendar - Not able to select in "Future"

    Would the Helpdesk staff need to enter a date prior to the date they recorded the log? If not then have the date automaticallypopulate a text field on the form. then have the text feild to locked so that the users can't change the date.
  5. M

    Viewing 2000 data in 2003

    Ive just updated to Office 2003 and I can view all of my databases in the A2003. Thgeonly problem I find is the Security settings. Everytime I open a Database in A2003 i get the securty message. Other than that I've not had a problem. I guess you could try opening A2003 then selecting "Convert...
  6. M

    Intellipoint software v5

    i have same problem, thought it was me as i have just installed MS Office 2003. Glad i'm no going mad. I knew it worked before!
  7. M

    Select List box data and populate form

    Thanks for that Mile I'll have a bash at it now.
  8. M

    Select List box data and populate form

    I know, Sorry I like the idea of the openargs but dont know how to implement it really.
  9. M

    Select List box data and populate form

    Thanks for your response Mile The underlying query for the listbox has 12 fields however I have only chosen to have 3 fields in the listbox simply for a more pleasing effect on the eye, I don't want the horizontal scroll bars! I have tried referencing the lsitbox box data but only getting the...
  10. M

    Select List box data and populate form

    I have a form with several list boxes on all working fine. One of the list boxes shows the current quotations for the current customer. I would like to be able select a line in the list box and then click a command button to open the Invoice Form and have the fields populated by the data from...
  11. M

    Change field in table when button on form clicked

    Hi Bradccs & Theprez Thanks for your responses. I tried the update query first but couldn't get the syntax correct so i went along the recordset route. Here is the code I used for the FindFirst: .FindFirst "CustomerID= " & CustomerID & "" All is working well thanks. :D :)
  12. M

    Change field in table when button on form clicked

    I have a problem with changing / updating a record in the table from un an unbound form. Heres what I have. A form whereby invoice details are entered, upon clicking the command button, the data is sent to the report and a new record in the INVOICES table is created. This works fine. What I...
  13. M

    Listboxes for new form data

    Hi I have a small problem in that I have a database for invoices and quotations. The main form shows the customer and has two list boxes detailing the quotes and the invoices. On the listbox, if i double click the line i want, I can bring up the invoice or quote report i need. Is there a way...
  14. M

    How do I display Month/Year only?

    ON the text box for the Next Calibration date, format it using mmm-yy that should return just the month and year - thus Mar 04
  15. M

    How to store calculated values

    Calculated Nitrous The idea is not to store calculated values in a field. You calculate them when you need them be it on a form or a report. Ian If you want i have a small dbase app i could email you to show how it works
  16. M

    Image Management

    Access IMaging Andy I have had similar dealings with images in access although there was only one image per record. It's not a very good system to use really but it does work for the best part. Access can view TIF files quite easily on a form and can be made to scroll through the database...
  17. M

    Document form

    Scanner What do you want to do with the scanned image? Are you looking to capture data or just display the image? Ian
  18. M

    Chart / Query help

    Hi Dan Can get it to compact small enough, plus as im only a contractor here i dont have email Ian
  19. M

    Chart / Query help

    Ok, I have mad progress with the above problem. I now have a graph which is seqentail but only shows the months as numbers along the bottom. Moving on I have chagned the chart query to that of below: TRANSFORM Count([All Accident Chart query].[Report Number]) AS [CountOfAccident Count] SELECT...
  20. M

    Chart / Query help

    HELP!!!!!!!!!!!!!!!!!!!!!! I have been stuck with this for a few days now. (One of those IT contracts which all of a sudden turn nasty - "Oh, we have this database!" Thanks to Dan-Cat I solved the other problem with the database. This one is probably really simple but my brain now hurts...
Back
Top Bottom