Search results

Hello all, I've got a little function (code is below) in a supply database, that takes in Quantity Authorized (QAUTH) and Quantity on-hand (QOH), and divides them, to get the %, and then returns a string color-code value (G-green, A-Amber, R-Red) based on that percentage. Problem is my code...

Hello all, I am re-working an old database that 'grew up' the wrong way. It is a medical patient database and has 4 main tables. Primary key of main data table is Medical Record number (MR#), a user entered field (I know...). This links to 3 other tables: Diagnoses (indexed by MR# as well...

In A2000, with VB6.0, I use the following line to save a report to a file. DoCmd.OutputTo acOutputReport, "rptMABriefList", acFormatRTF, Filename Works just fine. I want this process to be automatic and hidden from the user, but a window pops up with a "Cancel" button. I don't want to...

Any ideas on how I could go about archiving data from my Medical Patient Database? Patients are represented with a single record. Each patient could have an unlimited amount of admissions (linked by PatientIndex), surgeries (again linked by PatientIndex), and unfortuantely, complications...

I have an unbound form with several controls that I use as criteria for making a custom user query. I would like each combination of options to allow me to assemble an sql statement, then use that to open up a recordset and set the object source of a subform to that recordset. My only problem...

I abandoned the Access inputBoxes in lieu of a home-made version (an unbound form) that I have a print button at the bottom to print multiple copies of a report. Here is the heart of the code (to print NumPatrons #of the report MABriefList): If NumPatrons <= 0 Then GoTo ExitTournee...

Does anyone have experience with the Re-naming wizard available in the following link: http://www.acc-technology.com/rnwiz.htm I have written a behemoth and I try to be consistent, but my own naming protocol isn't as good as the LESZYNSKI convention that I have recently learned about at our...

I have a hospital patient database that keeps each Medical Record Number unique -no duplicates (MRNum). I absolutely must block duplicate patient entries. To add a patient users click a button which opens the Form in add-mode. First field is Name, the second is MRNum. On-exit, if the...

One of my tables is surgical operations - a resident participates in each operation but has one of three roles - surgeon, first assistant, or teaching assistant. I use a cross-tab query to give each resident a summary of their experience to date - for each operation, how many they have done as...

If anyone uses some form of Access Interface on their Palm, what program are you using and what do you find are its advantages and disadvantages?

I have an update query that I use to calculate a particular value that is inserted into a table (Yes, I know I shouldn't do it this way but honestly there is no other way...I posted a prior question under the reports forum on calculating a value in a report, if you are interested exactly why I...

Short version - DCount super slow. Why? Detailed version - I have a DBase with 1200 hospital patient records and growing. I use DCount to see if a given person's medical record number is already in the dbase to avoid duplicate entries. I think I should do it this way rather than not...

Basic dbase structure - each record has two subforms that could contain either a variable number of hospital admissions (each with an admission date) or a variable number of medical procedures (each with an operation date). In printing an active list of patient records the user will choose...

I have written a small function that accepts two dates and a string, and returns a string. If one of the dates is null, no matter what the other one is or what I do in the body of the function, the function returns '#Erreur' - regardless of if I check with 'IsNull', even if the routine never...