Search:

Type: Posts; User: JudyJones; Keyword(s):

Page 1 of 15 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    8
    Views
    8,942

    Thanks for everyones help. I think the custom...

    Thanks for everyones help. I think the custom format should work just fine. I would also be interested in the calculated expression that would change this to an actual date.
  2. Replies
    8
    Views
    8,942

    I know I have done this in the past but when I...

    I know I have done this in the past but when I format a cell with the date format I want and then try typing the date without the slashes, Excel changes the date to a different date. Is there...
  3. Replies
    2
    Views
    483

    I have an Access query that I am trying to export...

    I have an Access query that I am trying to export as CSV format. The leading zero is being dropped in several text fields containing numerical input. How can I prevent that from happening?
  4. Thread: Email report

    by JudyJones
    Replies
    6
    Views
    772

    Thanks for the push in the right direction. The...

    Thanks for the push in the right direction. The query I was using did not refer directly to a control located on a form, but one of the queries it was using referenced the form control containing...
  5. Thread: Email report

    by JudyJones
    Replies
    6
    Views
    772

    I have a button on a form screen that is used to...

    I have a button on a form screen that is used to email a report on a regular basis to a list of department chairmen. Everything worked fine until I modified a couple of tables in the database. Now...
  6. Replies
    3
    Views
    682

    I am just getting back to work after a week off...

    I am just getting back to work after a week off because of a 20" snowfall. Thanks for the reference. I'll try it out and see if I can make it do what we need.
  7. Replies
    3
    Views
    682

    Using Access 2002 sp3, is there any way to have a...

    Using Access 2002 sp3, is there any way to have a database automatically close at a certain time if a user has inadvertantly left it open?
  8. Replies
    3
    Views
    558

    Thanks to both of you I was able to include the...

    Thanks to both of you I was able to include the date onto my chart and even tested it by changing my computer date to make certain that the date appearing on the chart would change.
  9. Replies
    3
    Views
    558

    Is it possible to display today's date within a...

    Is it possible to display today's date within a chart's title or somewhere on the chart so that it will display the current date when it is printed?
  10. Thanks for your help. You got me on the right...

    Thanks for your help. You got me on the right path. I had to keep playing with FileCopy to get it to work. There were 9 files and I tried to copy them using the asterisk as a wildcard to copy them...
  11. Both front end and backend are using record-level...

    Both front end and backend are using record-level locking and the default is set to No locks.

    I will have the school test the idea that more than one person could be trying to change the same...
  12. I would like to copy a series of files that begin...

    I would like to copy a series of files that begin with a specific date that has been selected from my form screen. I would like to add this to the end of a procedure that already runs from an Access...
  13. My question would be, although it's not the...

    My question would be, although it's not the likely culprit, but does this school system have occasional network issues and slowdowns? (I don't see how that would delete the data just typed,...
  14. Answers to questions: Has the PC being used...

    Answers to questions:

    Has the PC being used been rebooted recently?
    It is happening on different computers at this location and they are rebooted each morning.

    Do you always get the same...
  15. I have a location where users are typing data...

    I have a location where users are typing data using a form screen to enter text into a memo field. They are using a front end copy of the database located on their computer which is linked to the...
  16. Replies
    8
    Views
    862

    Is this something that has to be set on each...

    Is this something that has to be set on each user's computer? Once I added the close print preview button to the quick access toolbar it was there in every database I opened on the one computer I am...
  17. Replies
    2
    Views
    507

    Thanks. That worked great. I can think of so...

    Thanks. That worked great. I can think of so many places I can use that type of expression now that I understand how it works.
  18. Replies
    2
    Views
    507

    How would you set the criteria for a date field...

    How would you set the criteria for a date field named EffectiveDate to limit your records to all where the EffectiveDate is greater than July 1 five years ago. I didn't want to type the criteria as...
  19. Replies
    4
    Views
    1,600

    Thanks. I played with the startup options using...

    Thanks. I played with the startup options using version 2002 of Access. I found that by unchecking the option "Allow full menus", and then opened the file in Access 2007, the Office button provides...
  20. Replies
    4
    Views
    1,600

    I would like to know how to hide the ribbon and...

    I would like to know how to hide the ribbon and Office button in Access databases we have created for our users. We have been testing various databases we have in use and many of them we want to...
  21. Thread: Time field

    by JudyJones
    Replies
    5
    Views
    502

    Thanks for your help. I think the code would be...

    Thanks for your help. I think the code would be the way to go. Since the users are not use to using the 24 hour clock, it would be too hard for them to enter time that way.
  22. Thread: Time field

    by JudyJones
    Replies
    5
    Views
    502

    I am working on a database that keeps track of...

    I am working on a database that keeps track of each time a student is tardy to school. When the time is entered into a field which has it's format set to hh:nn am/pm. I would like the am or pm to...
  23. Replies
    2
    Views
    751

    I have 21 fields that need to be updated so I was...

    I have 21 fields that need to be updated so I was trying to avoid a separate query for each one. I used code and it worked very quickly.
  24. Replies
    2
    Views
    751

    I have an Excel file that originated in Oracle to...

    I have an Excel file that originated in Oracle to which I am linked in Access. I have a make table query that creates the table "Cases" that I am using for reports. I would like to remove all...
  25. Replies
    5
    Views
    554

    That solution fixed the problem. I would have...

    That solution fixed the problem. I would have thought that both calculations would have provided the same results but I see now that there is a difference. Thanks for your help
Results 1 to 25 of 363
Page 1 of 15 1 2 3 4