Recent content by itprog

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?