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 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: *

  • Users: Taecca
  • Order by date
  1. Taecca

    How to exclude a time period from a query

    You are correct. I was getting confused with 'And' and 'Or' All resolved. Thank you :)
  2. Taecca

    How to exclude a time period from a query

    Weekday cannot be Sat and Sun for the second query. I need all week long except period A (which is Mon through Fri from 8 am to 14)
  3. Taecca

    How to exclude a time period from a query

    Thanks for your reply but it did not work. Basically I need 2 reports: (1 for each period) Period A is weekdays only from 8 to 14 Period B is every day except weekdays from 8 to 14 The query for period A is okay. How do I do the query for period B?
  4. Taecca

    How to exclude a time period from a query

    Need to create 2 queries: Query 1 seems to be working ok: Select * from temp where WeekDay not in ("Sat", "Sun") and TimeOfDay between "08:00" and "14:00"); How do I now create another query to select * for the rest of the times? (Weekdays from 14:01 to 07:59 and Saturday/Sunday the entire...
  5. Taecca

    Need to know how to replace part of a field

    Thank you
  6. Taecca

    Need to know how to replace part of a field

    In one of my colums has data as following: Client ID: AAA2393 Client ID: AXY22228900 Client ID: 92000AZyU OPQ282822AZY NO001AZND and so on... In my query I would like to remove the words: Client ID: How can I do that?
  7. Taecca

    What are the risks to connecting to somebody else's router?

    If I receive a signal from someone else's router in my house, can I connect to it? What are the risks?
  8. Taecca

    How do I create a cmdbutton to filter records?

    Thank you
  9. Taecca

    What do I need to connect my laptop to the internet wirelessly?

    Thank you for your answer however I think I need more details. How do I turn on my wireless network detection? I don't even know where to start. This laptop is totally new and has never been connected to the internet. Could you provide more details? My company tells me I can use the router...
  10. Taecca

    How do I create a cmdbutton to filter records?

    I have created a form (continuous) and StudentName, StudentCity, StudentID are some of the columns. I wish to add a button at the side of a column that when clicked will filter by the value (StudentID) on the current record. How do I do it? Thank you and happy new year
  11. Taecca

    What do I need to connect my laptop to the internet wirelessly?

    I purchased an IBM Thinkpad R50. What do I need to connect to the interent wirelessly? I have connected a wireless router to use my work pc at home and while using it I detect several wireless signals in my apartment. I would like to know what do I need in my Thinkpad R50 to connect to a...
  12. Taecca

    Need help to create a push button to sort my fields

    WONDERFUL![2thumbsup] Thank you
  13. Taecca

    Need help to create a push button to sort my fields

    I have a continuous form with a few different columns. I wish to add a button at the top of each column for the user to press and sort by that column. I will then add a refresh to the code to display the newly sorted records. Can that be done? Thank you for your help
  14. Taecca

    How do I search record based on 3 parameters?

    In my table I have records with :Section ID, Sub Section ID, Item Id and LocationName I need to do a search on my form where a user would use combo boxes to indicate Section, SubSection, Item and finally LocationName to retrieve the correct record. How someone guide me? Thank you
  15. Taecca

    Adding a field

    I am not sure I understand what you mean? When I try to create a form I have to pick a table. If I pick my table, as of now columns ItemID and Comments are empty. How do I make a form that allows the user to select an itemID, or ItemName and description from the linked tables and insert a...
  16. Taecca

    Adding a field

    I have several tables linked to other databases, which I am not allowed to modify. I need to create a form where my users will be able to add comments to each itemID. (itemID and other details are part of the linked tables. I have created my own table with 2 columns: ItemID and Comments. Now...
  17. Taecca

    How do I add an additional checkbox?

    sorry..I just realized I had to enter a column in my table to allow the checkbox to put a value in the column, if checked. Thanks
  18. Taecca

    How do I add an additional checkbox?

    I have an access form with 3 checkboxes. I need to add one. I dragged a new checkbox onto the form but when when I test it, it does not do anything What is the process of adding an additional checkbox? Thank you for your help
  19. Taecca

    Outlook - How can I add a marquee to my signature?

    ops..I forgot to indicate that the program I wish to apply this is outlook. Thank you carrr for your reply but I would not know how apply this on my outlook signature
  20. Taecca

    Problems with my first asp page.

    I purchased a book to learn on my own ASP. Here is my code: <html> <head><title>My First ASP page</title></head> <body> <form Runat="Server"> <b>Username:</b> <br><input id="username" type="text" size="30" Runat="Server"> <p> <b>Comments:</b> <br><textarea id="Comments" cols=30 rows=5...

Part and Inventory Search

Back
Top