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 derfloh 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. Baesucks

    Trying to SELECT the most recent Patient.Weight prior to an Order.OrderDate.

    I have 3 tables. Patients, Orders, PatientWeights PatientWeights has 3 fields. PatientID, WeighDate, Weight. Orders has 3 fields. OrderID, PatientID, OrderDate. Patients has 3 fields. PatientID, LastName, FirstName. I want to create query that lists each Order. The trick is I need the...
  2. Baesucks

    SQL - select FIRST record from a sub-query for each item (patient or customer)

    Every once in a while I need to do this type of query and I don't seem to know the best way to do it. I have a table with fields like these... PatientID VisitDate InsuranceType InsuranceCompanyName InsurancePlanName I want to end up with a single record for each PatientID that contains the...
  3. Baesucks

    Trying to use a variable file name in a SELECT statement using OPENDATASOURCE

    I'm reading some excel spreadsheets into SQL Server tables. Can anyone tell me why I can do this... SELECT * INTO TestImport FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source=E:\MyFolder\MyExcelFile.xls;Extended Properties=Excel 8.0')...[Sheet1$] But I can't do this... DECLARE...
  4. Baesucks

    MDAC

    I was having a similar problem. I recently switched from XP to Windows 7. Every time I generated a new ADE from one of my Access Projects it ran just fine for me, but not for anyone else. I finally edited the project on one of the older XP machines. I ended up adding the reference "Microsoft...
  5. Baesucks

    Include an arrow on my form

    I would like to draw a bunch of arrows on a form. Is there any sort of control that can be added that will allow for that. I can draw lines, but no arrows :-(.
  6. Baesucks

    Trying to insert data from a table in another database

    Never Mind. I found out it can't really be done. Had to create an MDB file and then link the tables from both databases to append records from one to the other.
  7. Baesucks

    Trying to insert data from a table in another database

    I'm trying to insert data into a table in my current database from a similar table in another database. From inside my MS-Access ADP file I'm trying to do something like... strSQL = "INSERT INTO [myTable] SELECT [theOtherTable].* FROM [TheOtherDatabase].[theOtherTable]" DoCmd.RunSQL (strSQL)...
  8. Baesucks

    Database Copy Loses Primary Keys

    I have an Access ADP that works well with a SQL Server database. I want to leave that ADP and the associated SQL Server database as is, but make a copy of both the database and the ADP that I can modify to make a slightly different application. I used SQL Server Management Studio to make the...
  9. Baesucks

    Minimize Naviation Pane

    Nope, I meant the Navigation Pane found in Access 2007 (aka. shutter bar).
  10. Baesucks

    Minimize Naviation Pane

    I would like to minimize the navigation pane via vba code when my main form opens (minimize, not hide). Does anyone know how to achieve that?
  11. Baesucks

    SQL Select - Combine number fields to a string and handle NULLs

    I have 4 numeric data fields that I want to display as a single field using a text delimiter (like "/") between the values. So if... Field1=5 Field2=8 Field3=2 Field4=1 My SQL would produce a single field result of (text) "5/8/2/1". I have it working using CAST statements and...
  12. Baesucks

    ADE Compatibility between 2007 and 2003

    I recently upgraded to MS-Access 2007. I made a small change to one of my projects, made a new ADE and everything works fine... except when someone tries to open the MDE using MS-Acces 2003. I have my Access2007 configured to create 2003 compatible database files, but that doesn't seem to...
  13. Baesucks

    Audit Trail Trigger DELETE conflict

    I have been using audit trail triggers on all my SQL Server tables for some time. It records all Insert, Update, and Delete events to an audit trail table (one record for each field). I have a continuous form who's data source is a table. When I just highlight the row in the continuous form...
  14. Baesucks

    Speed up Excel VLOOKUP using IF

    I need to perform a VLOOKUP on a large set of data to get some information from another worksheet (which is closed). I only need the VLOOKUP performed when the field "date" is the last day of the month, so I only need the VLOOKUP to actually excute once for each 30 or so rows. So I have a...
  15. Baesucks

    System.EnterpriseServices ? .net framework problem maybe

    Ohhhhhhh Thank you... That did the trick !!! What in the world would cause that assembly to dissapear?
  16. Baesucks

    System.EnterpriseServices problem

    One day, all of my applications developed in Visual Studio 2005 stopped compiling... I get this error message... Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the...
  17. Baesucks

    System.EnterpriseServices ? .net framework problem maybe

    One day, all of my applications developed in Visual Studio 2005 stopped compiling... I get this error message... Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the...
  18. Baesucks

    Highlight Null Values

    Is there a way to refer to the report text field rather than the database field in a generic way in the code (so I can use the same set of code for all fields) Something like... If IsNull(me)... or If IsNull(this)... I tried each of these and it doesn't fly.
  19. Baesucks

    Highlight Null Values

    I have a text field in my report, I want to create a conditional format so the text field background is RED when the data field value is blank or null. I believe I can do the conditional formula just fine. The problem that I have is even if I set the background to RED for ALL records, each...
  20. Baesucks

    Simple GetDate question

    I still get an error "Invalid use of getdate() within a function". I should have mentioned this is within a Scalar Function I'm building. Is there a problem with using built-in functions within user-defined functions?

Part and Inventory Search

Back
Top