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 Chriss Miller 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. aaronlglover

    Prevent linked table from locking records

    Hey All, I have been searching all over the web trying to find a solution to my problem. I have a FE and two BE access database. One BE is used to house the table that is modified by the user and one BE that is to be used for reference only. My problem is this, when I link tables from the...
  2. aaronlglover

    Remote query external MDB without locking it

    -------------------------------------------------------------------------------- Alright guys, I am beating my head against a wall with this one. I am a new access programmer . Here is what I have; One MDB that has a couple of tables for storing data and another MDB that will be used as a...
  3. aaronlglover

    RangeHTML not working on VBA 6.3

    Hey Guys, I have some code that converts a range to HTML for insertion into an email body. It works fine and dandy on my machine that has VBA 6.5 but when someone tries running the code that has VBA v6.3 they get an can't find object or library error. I cannot find the reference to enable to...
  4. aaronlglover

    Reall simple Date/Time converstion question

    Thanks PHV, Worked perfect.
  5. aaronlglover

    Reall simple Date/Time converstion question

    Hey Guys, I am sure the answer to this is very simple I just can't find it anywhere on the net. What is the function in Jet SQL to convert a date time (07/13/2009 13:30:00) to just show the time (13:30) Thanks
  6. aaronlglover

    What is wrong with my query?

    Nevermind, that was my problem...removing the brackets in my Toad query. Thanks for responding....
  7. aaronlglover

    What is wrong with my query?

    It runs ok when I do it from access (i need to put brackets around the derived tables for access to be cool with it) but it works.
  8. aaronlglover

    What is wrong with my query?

    I am using toad to query an MDB. When I try to run the below query I get a "Microsoft Access ODBC too few parameters expected 1" error. Anyone have any thoughts? Thanks SELECT DISTINCT agtdata5.AGENT_ID, agentA.AGENT_NAME, agentmap2.HIRE_DATE, agtdata5.MU_ID, agtdata5.AGENT_DATA_VALUE...
  9. aaronlglover

    Using Function in in access ODBC query

    Thanks PHV, I have tried using the IIF() and Switch() functions however when I have more then 15 conditions in either of them I get a "expression too complex" error. I would normally just create a table in the MDB with all the lookup values that I would join however the lookup values are...
  10. aaronlglover

    Using Function in in access ODBC query

    Thanks, When I try to query my MDB ODBC via microsoft query I get the error "Undefined function 'CaseSearched' in expression" here is the SQL I am using SELECT Schedules.AGENT_ID, Schedules.AGENT_NAME AS 'Agent', Schedules.AGENT_DATA_VALUE AS 'Supervisor', Schedules.MU_ID AS 'MU'...
  11. aaronlglover

    Using Function in in access ODBC query

    Hey Guys, I have an access database as a store for some data. I have a custom function in my MDB that is basically a CASE statement. It works when build queries within the MDB itself...is there a way I can call on this function when querying the tables externally via an access ODBC...
  12. aaronlglover

    SWITCH FUNCTION TOO COMPLEX

    Sorry, Here is the SQL I am using SELECT Schedules.AGENT_ID, Schedules.AGENT_NAME AS 'Agent', Schedules.AGENT_DATA_VALUE AS 'Supervisor', Schedules.MU_ID AS 'MU', Schedules.HEADER_DATE AS 'Schedule Date', Schedules.DETAIL_EXCEPTION AS 'Detail Exception', SWITCH(schedules.DETAIL_EXCEPTION = '1...
  13. aaronlglover

    SWITCH FUNCTION TOO COMPLEX

    Hey Guys, I have a bunch of data stored in an MDB. I am using microsoft query to query it and pull it into excel. From what I understand Access does not support Case statements so I decided to use SWITCH instead. The problem is when I get past 15 conditions in my SWITCH statement I get a...
  14. aaronlglover

    SQL to calculate half hour summary

    Hey All, Does anyone have some SQL to get me started or maybe a link to a help guide that will get me started? I have a table with schedule exception detail that I need to summarize into half hour incrememnts. Here is an example of what the schedule exception detail looks like. Exception |...
  15. aaronlglover

    noob SQL question Join question

    Got IT!! I just had to add a few () and it worked. Sorry guys, I had no idea that Access treated the code different the SQL server. Thanks so much for your help.
  16. aaronlglover

    noob SQL question Join question

    I am actually just querying an MDB 2000 file format from access...
  17. aaronlglover

    noob SQL question Join question

    Just tried that...same error. WHen I try the the derived table Join by itself it runs, and then whey I try the first join by itself it runs. Something is goofing up when I try to join those two together though.
  18. aaronlglover

    noob SQL question Join question

    Hey Mark and George, I tried both of your suggestions and I get the exact same error at the exact same spot. Here is the last SQL i just tried SELECT ScheduleDATA.AGENT_NAME, ScheduleDATA.HEADER_DATE, agentmap.MU_ID FROM ScheduleDATA Inner Join agentmap On...
  19. aaronlglover

    noob SQL question Join question

    Hey George, So duplicating your example I built some SQL that uses my actual tables and I get a "Missing Operator" error starting at "ScheduleAta.AGENT_ID = agentmap.AGENT_ID" Can you see anything I clearly missed? SELECT ScheduleDATA.AGENT_NAME, ScheduleDATA.HEADER_DATE...
  20. aaronlglover

    noob SQL question Join question

    OH man thanks so much. I actually new I had to do some kind of sub query or "derived table" as you call it I just could not get the syntax right. This actually makes perfect sense to me now. I appreciate it greatly!!!!

Part and Inventory Search

Back
Top