Search results for query: *

hi, in the code below, the line seems to be giving a2k a bit of a problem: Private Sub MR_Number_BeforeUpdate(Cancel As Integer) Me.RecordsetClone.FindFirst "MR_Number=" & Me!MR_Number If Me.RecordsetClone.NoMatch Then 'do nothing Else Cancel = True MsgBox "WARNING -- A record...

hi, i have a table called "ID Table" which can not have duplicate values of the person's medical record number (MR number), this field not being the last field of a composite PK. I have created a query using the design wizard appearing below and I have added a 'Dummy' field to the table whose...

i have a form that is 5" wide and that i want to be worked with at that size (not bigger or smaller); it is actuated from a 'switchboard' menu item. it has been paired with a 'tool bar' that has a subset of about 5 commands (called 'screening log'). in its 'menu bar' property the setting is '=1'...

i don't know if the simplicity of the subject heading really does the thread i'm introducing any justice.... i have a database with a host of interrelated tables. at the simplest level, we have a patient registration table which has a medical record (MR) number. other tables may follow the...

i am developing a 'screening log' which will allow the telephone screener to screen the same person for more than one experiment. last name, first name, mi and study_number are the members of the pk in that order (so that the same person can be logged as having been screened for more than one...

the subject is pretty much the core of this message. i have a parent/child relationship in a form/subform and the latter is set to display as 'continous forms' but yet it won't? “The philosophy of the school room in one generation will be the philosophy of government in the next." ---...

my table contains "On Study Date" and "Days" for each record. my query computes "Next F/U Due: [On Study Date] + [Days]" but when i enter the following criterion "Between [Earliest] And [Latest]" as the criterion for "Next F/U Due" and enter two dates, it gives me dates that lie outside the...

i have a table i want to query (ultimately i would use the select query's result in a report but that will have to wait)... there are a few fields on this table but the ones i'm interested in are called 'Submission', 'Date Submitted' and 'Appvl Date'. the first is completed via a combo box...

a user brought this 'interesting' behavior to my plate this pm. there is a form called 'Protocol' which has nested w/in it a sub-form called 'Tracking'. the 'Protocol' (parent) form is linked to the sub-form via a field called 'IRB#'. the tables of each have the forms' same names and the pk...

i am trying to export some tables from my a2k mdb to csv files. here's some code someone's helped me put together. it seems to work pretty well when there's data in a field, but as you might've guessed that's not what it does when it fails to find data in a field in the underlying table. i get...

let's say there are two a2k databases --- we'll call them Database 'A' and Database 'B'. Database 'B' would be easier to use if some of the forms on it could access information which already exists in Database 'A'. So, I guess the question is 'can fields from one or more tables in one...

i wish to export several tables from my a2k mdb to comma delimited csv files which i will then rename to have 'txt' extensions. when i use a query to create the csv file of one of them (the "PUBLICATIONS" table), what i get is this once i rename the csv to txt...

i have a form and correlated sub-form in my database. IRB# is the linking parent/child field. my parent table has pk IRB# and my child table has IRB# and PRMS_Review. i am trying to create a report which lets the user see only those records which have values of 'PRC_Meeting_Date' occuring...

i have a query on a table. the table has three fields (to keep it simple), dosage amount, height and weight. all three are real numbers and can have decimal values on entry into the table. i want to export the three values as numbers (not text) into a csv text file. my query uses expr1...

hi, i have numerical three fields in my table which need to be exported (via a query) into csv text file. they are height, weight and dosage amount. the first two must have one significant digit to the right of the decimal point. dosage, on the other hand, must have three significant digits to...

well, my subject heading pretty much represents my query.... i have some tables with height, weight and dosages and i'm exporting these variables to text files via queries. my downstream recipients are blueprinting requirements for height and weight to have ####.# and dosage...

from my query, when i export a date using Expr1:Format([Subm_Date],"yyyymmdd") into a csv text file and my date is, for example, 01/01/2001 (January 1st, 2001), the value appearing in my output file is "20010101" WITH quotations (as show above) surrounding it. the thing is, i...

i think this is kind of weird. lets say i have two tables in my a2k mdb (there are more but only two concern me now). one is called 'Patients' the other is called 'Prior_Therapies'. as you would expect they are related. Patients has a composite primary key made up of Protocol_Id and Patient_Id...

hi, the last command in my macro is 'RunCode'and in the area provided to enter function name i have the following text SHELL("COPY...

hi, the last command in my macro is 'RunCode'and in the area provided to enter function name i have the following text SHELL("COPY...