Search results

I cannot set the index as a primary key. I get an error message that I cannot have null values. I actually just need a 2 key index with the patient id and the discharge date to make sure the patient doesn't have more than one record with a blank discharge date. The user has a form to enter...

I have a patient database. The text field is the patient id, one date field is the admission date, the other the discharge date. A patient cannot have more than one admission record with a blank discharge date. That is what I would like to use the multi-field index to check for. So each...

I am trying to set a multiple field index on a table. I would like to use 3 fields. One is a text field, the other two are date fields. The text field and one date field will always have a value. The other date field can either have a value or no value. The index will work if I only use the...

I just finished running MS Office updates. That seemed to help.

I just created a new form and received the same error when trying to place the command button on the form.

When I try to add a command button using the Command Button Wizard I get an Invalid Use of Null error. I am using Access 2003. I have successfully added other controls to the form. I have searched Microsoft and the forum for help, has anyone encountered this problem?

I get the error message as soon as I leave the field box, even before I get a chance to run the query.

I have another question. In the same query I have several fields that follow the format below and are working: ---------------------------------------------------------------------- Field: ResType: [ResidentType]=[forms]![frmDischargeRptSelector]![cmbResType] Or...

Jon, That worked perfectly. Thank you for the help.

Jon, I'm having trouble getting your suggestion to work. I'm not sure what the [fieldname] in the expression represents. And what is the criteria of true is going to show?

I am trying to setup a query that will generate a report based on options selected on a form. The fields I am using in the table do not have data for every record. If the criteria in the query is left blank, I would like all records listed regardless of whether there is a value in that field...

Scott, I used the Mutiple Field index and it worked great. No need to concatenate fields. Thank you.

Thank you both. The format function worked. I do have an autonumber as the primary key. I really meant that I want to use the concatenated fields as a way to check for duplicated entries in the table. There can be multiple entries for the same client number, but only one entry for each...

I have searched and found references to converting text to dates. I need to go the other way. I have client# field and a date field. I would like to make an update query to populate a new field by concatenating the two fields minus the "/". I am making a new key field in an existing table...

The db contains information I cannot post. Is there any other info I can give you?

I have a form that opens with a filter for active records based on a date field value of null. On my form I have a button to show active records with a date field value of null and a button to show all records regardless of date value. These buttons work fine. I have another button that...

I would like to select an admission date from the display in the subform. After I select the admission date from the subform, I would like to open another form displaying that entire record.

They can be readmitted at a later date during the year.

I am comparing the value in [CNO] (which is in qryAdmissions) to the value in the combobox field on the form (the same for AdmitDate and DischDate). I want to display the record that has the CNO, admitdate and dischdate shown on frmGetRecord in the form frmEvents - which will allow for further...

I have a form(frmGetRecord) with a subform(frmSubGetRecord). frmGetRecord has a combobox cmbCNO to choose the patient. The subform displays the admit date and discharge date(if there is one). There can be multiple admit/Discharge dates for a patient. Based on the values from fields on the...