Search results for query: *

I have a report based on a crosstab query. The report displays fine until the data from the crosstab query changes. The query places the column headings as dates and when the dates change the report gives a error saying that it dosen't recongize 2/6/06 ( or whatever it happens to be)as a valid...

My boss has decided he want to change our lab reports to show the last 5 series of tests. There are about 10 tests per date. I know I can run a query that orders the tests by date. My questions are: 1. How do I populate the report in columns by date? 2. What if there is less than 5 test series...

I have a report in Access 2000 that shows test results. Some of these results have upper and lower limits. For example the result might be 4.8 with normal range of 4.1-4.7. How can I add a field to the report that will print "HIGH" if above or "LOW" if below the limits? Would this be done with...

When I create a chart in Access 2000 Access assigns the values of the X-axis. Is there any way to use a table for the Y-axis and another table for the x-axis? Thanks

Well I know the answer is staring right at me but I can't find it. I can create a chart manually in Excel 2000 OK and even record a macro, but when i try to run the macro I get error 13, Type Mismatch on ActiveChart.SetSourceData Source:=Sheets("WBC Data").Rows("1:1"), PlotBy:= _...

I have a scatter chart that consists of 256 data points. Excel labels the X axis as 0 thru 300. Actually each data point should be spaced 1.758 units apart to give a range of 0 thru 450. How can I change this? Thanks

Is it possible to put a scatter chart on a report in Access 2000 using data (256 data points) from a table or do I need to use Excel? Thanks

Hi All, I have this code to import data into a table. I need to change it to check to see if the txt file exists and if yes then import but if not then exit. How do I do that? Public Function Import_Assay48control_Data() On Error GoTo Import_Assay48control_Data_Err DoCmd.SetWarnings False...

I have a WinBatch script that uses a call function. it works just fine (outside of Access) until I try to run it using code in Access. All the wimbatch files are in the same directory. Public Function IMX_Patientdata() Dim CmdLine As String CmdLine = "C:\Program...

Is it possible to schedule a function to run at a certain time each night?

When I import data to a table I will get an info box that states (among other things), "Access was unable to append all the data to the table.". This is due to primary key violations which means that access is doing just what it is supposed to do. The problem is that I want this proceedure to...

I have a table called PatientNames that contain Patient ID, LastName, Firstname, and MI. The primary key is Patient ID. This table is updated by importing a text file that has all the Patient Names and associated IDs (old and new). Since the Patient ID is the primary key only the new patients...

I have a macro that runs VBA code to start a winbatch script. This script takes about 30 sec to run. Then the macro does another RunCode to start another action. Like: RunCode Configure Patient Names RunCode Import Patient Names As I'm sure you have figured out the macro dosen't wait for...

I have a text file that I import to a table in Access 2000. This is done every day to update the table. Most of the time there is only one or two out of 32000 entries that are added. Access gives the usual error message about not being able to update 31999 records due to primary key violations...

I have a Access 2000 database at work and a copy at home. I came up with a great new form using the "at home" copy. Now I want to transfer that form to the database at work. How do I do it? I can't seem to find the answer in my books ... maybe it's too simple. Thanks

I'm trying to use a SQL statement to validate input in a form. I need to make sure that the number entered in not already used. ( Access 2000) This is what I tried: Private Sub Pin_BeforeUpdate(Cancel As Integer) On Error GoTo Pin_Err Dim CurDB As Database, JobInputTB As Recordset, SQLStmt As...

I have a simple (or it seems it should be) problem. I have a table named "Input_data" with a field named "Profiles_1". I need to know the length of the data in this field for each record in the table. How can I do this??? Thanks

I have a client who has a Gateway 2000 P5-100XL as his server running Sco Unix System V/386 Release 3.2v4.2 and Medical Manager 8.12 with 4 terminals. He wants to upgrade his server because he is worried about reliability but wants to keep all his software as it is. His hard drive is 463 MB and...

I need to come up with a checklist of things to check on a monthly basis to insure that the system is running properly at various sites. I figured that checking the log files would be a good place to start. Any ideas, suggestions, or pet areas I should put on the list? Thanks

I am new to SCO Unix (or any unix for that matter). I'm determined to learn this OS. Right now I have a very large headache that only seems to develope when I fire up the unix machine! First problem: When using the SCO APC deamon(?)and connected to a Back-up UPS 650 via serial port,the machine...