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!

  • Congratulations strongm 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. Clegg25

    Access data auto export to powerpoint slideshow or other "Scrolling"

    Hope this isnt too complicated, but heres what i am in dire need of. I have an access databse with a table that has 3 fields. Entries will be made into the database every day. Is there a way to automatically export the last "however many lines of data" into a powerpoint slideshow, or some...
  2. Clegg25

    disable print report

    is there a way to disable the print option in a database report? IF so, is there a way to only allow certain users to print reports?
  3. Clegg25

    disable print button by user

    i just wanted to repost this. Was wondering if there is a way to disable the print option in a Report?
  4. Clegg25

    date range input to query

    that last post worked!! Thanks Bob!!
  5. Clegg25

    date range input to query

    my follow up question to this is: When i try to create a report based on this query, the report comes up blank. it asks me for a date, but when i put in a date, the report doesnt show any of the fields. does this make sense?
  6. Clegg25

    date range input to query

    That last one workeD!!! Thank you very much. Is there a way to remove the last entrie on the list? it
  7. Clegg25

    date range input to query

    hey! if i put an asterik after the date i input, it gives me the dates!!! It also gives me the current date at the bottom of the list though. I think it's almost there.
  8. Clegg25

    date range input to query

    i tried that sql. it did not work. It still gives me the latest date and time. This is driving me nutz!
  9. Clegg25

    date range input to query

    Here is the code from my query: SELECT [Shift Log Entries].[Pass On?], [Shift Log Entries].Time, [Shift Log Entries].Entry FROM [Shift Log Entries] WHERE ((([Shift Log Entries].Time)=[Enter Date]));
  10. Clegg25

    date range input to query

    i tried it out, but it seems to not like the fact that my date/time field is an auto (NOW()) field. Is there a way around this?
  11. Clegg25

    disable print button by user

    is there a way to disable the Print option in an access database, based on user logged into the database?
  12. Clegg25

    date range input to query

    okay, i have asked a very similiar question before, but i want to repost, because i dont think i explained it well. Here goes: I have a database with only 3 fields. The first field is an autodate/time field. I want the "user" to be able to push a button and something come up to ask...
  13. Clegg25

    Input Box Querying

    What is the alternative imaginary field method?
  14. Clegg25

    Input Box Querying

    I must be an idiot. I still cannot figure this out. Im sorry, but my access level is newbie. I hate to ask this, but can you describe it in a little more laymen terms? thanks,
  15. Clegg25

    Input Box Querying

    I have access 2000. I had once created a form or query where a window would pop up and ask me for a date range. I would put in a date range, and the query would show only those records within that date range. (the table has a Date field, and a Name field.) Is there an easy way to do this? I...
  16. Clegg25

    Report that can format a 255 text field nicely

    i want to create a report that has 3 fields. the first field is date, the second field is time, and the 3rd field is a text field with length 255. the problem is that if the data entered in the text field is only a short phrase, there is still a big space between all the records on the report...
  17. Clegg25

    date query

    the 24 hours works great, but the 12 hour does not work. at least i dont think it does.
  18. Clegg25

    input query?

    i am trying, but cannot figure this out. does anyone have a db example i can use and maybe change to work with my database? if not, thanks anyway.
  19. Clegg25

    date query

    how do i make a query that pulls up the last 12 or 24 hours of information based on a Time/Date field?
  20. Clegg25

    input query?

    this is a little advanced for me. Is there an easier way? I db example may help me much. thank you.

Part and Inventory Search

Back
Top