Search results for query: *

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

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

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

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 :-(.

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)...

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

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?

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

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

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

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

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

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

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

I get an error when I try to set the current date to a datetime variable using these statements... DECLARE @LatestDate Datetime Set @LatestDate = SELECT GETDATE() AS Expr1 What am I doing wrong?

I have an ODBC connection object to a SQL Server in my vba code (which I believe is functioning OK). I want to execute a user defined function on the server using that connnection and store the result in a variable in my vba code. I'm not sure what the syntax is... Dim wrkODBC As Workspace...

I wrote a SQL function (my first) that returns a string (which can vary in length). If I declare the function like this... ALTER Function getVteResolvedStatus (@VTE_ID INT) Returns varchar (30) AS I always seem to get 30 characters back. If the string is only 20 characters I only want 20...

I have a front-end access database file (mdb) which connects to linked tables from 2 different SQL server databases using ODBC. I want each user to have a similar front-end mdb file but be able to create and store their own queries. I want users to have access to several custom functions, so...

I have an MS-Access file with linked tables from a SQL Server, and want to create a query that uses the result of a function that resides on the SQL Server. Is there a way that can be done?

Is it possible to programatically call the Linked Table Manager? I would like to provide a button on a form to allow users (when needed) to set the directory/file location for linked tables from the backend db. Since I'm hiding the main database window it would be nice for users not to need...