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

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

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.

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

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

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

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

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

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.

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