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: lradon
  • Content: Threads
  • Order by date
  1. lradon

    Converting GMT to local time aka IT server time.

    I am building in CR XI, a report that lists complaints that our call center receives on a daily basis. The only problem is that the Start_Date_Time for the comments is in GMT, so some of the comments look like they were entered late at night after we've closed or at 3:00am. I wanted to use the...
  2. lradon

    Can the CAST function be used in MS Access 2000 to link tables?

    Before I post my question, can you use the SQL CAST function in the SQL view of MS Access 2000 to link two tables by their primary keys that have two different data types? i.e. Table1 has member_nbr as numeric Table2 has member_nbr as text.
  3. lradon

    Combo box based on another combo box

    Access 2000 I have created a combo box that limits its list based on the selection made in a previous combo box. First Combo Box Table Name: BackOffice BOID BOCode BOName 1 ACCTG Accounting 2 CENLEND Central Lending 3 LNSERV Loan Services 4 REL Real Estate 5 SA Special Accounts Second Combo...
  4. lradon

    Subquery w/in query of the same View/table

    Apparentally, I am missing a close ")" in my code because I am receiving this SQL message: Server: Msg 170, Level 15, State 1, Line 12 Line 12: Incorrect syntax near ')'. But, now I am wondering if it is possible for a query to contain a subquery both of which select from the same View? I have...
  5. lradon

    Use List Boxes w/SQL linked tables.

    I noticed that when I upsized a table to SQL 7.0 and then linked it to an Access 2000 database via a SQL ODBC connection, I lost my drop-down boxes. Can anyone confirm that you definitely can use list boxes or combo boxes with sQL tables with Access as a front end? Is there a way to do this or...
  6. lradon

    Create an SQL ODBC Connection Read/Write

    Hi, I have a similar need as the previous post. We use SQL 7 and I need my ODBC connection to be Read/write, so that users can do data entry thru an Access 2000 form and be able to edit the records and delete them as necessary. I have a feeling that the problem lies in the SQL login and I am...
  7. lradon

    Create ODBC to SQL Server 2000 as Read/Write

    Hi, I have a similar need as the previous post. We use SQL 7 and I need my ODBC connection to be Read/write, so that users can do data entry thru an Access 2000 form and be able to edit the records and delete them as necessary. HELP!!! Thanks in advance.
  8. lradon

    Select Subquery not returning all desired rows.

    Hi, I really need help with this, so I have updated the post with more information. I work the IS dept. for a small credit union. I am using SQL Server 7. I am trying to create a query for a report that summarizes our loan underwriters' response times. The data needs to be limited to...
  9. lradon

    Select Subquery not returning all desired rows.

    Hi, I work the IS dept. for a small credit union. I am using SQL Server 7 and I'm not sure what else you need to know. I am trying to create a query for a report that summarizes our loan underwriters' response times. The data needs to be limited to applications from only 2 out of several...

Part and Inventory Search

Back
Top