Search results

The form's recordlock is set to Edited Record, however, all records appear to be locked.

Yes, all users have copies of the front end.

Hello, I've created a database, split it and distributed to 5 users. The backend is located on a share drive. I was working fine during the validation but yesterday a user alerted me that one of the forms appears to be locked for editing. This is a continuous form that is bound to a single...

Hello, I’m making a query “Max210” that should return SampleDate, InterpP210, and Patient ID from Table “tbl_Samples” for the most recent Sample Date when InterP210 is Negative. I’m getting duplicate patient Ids in query output for some reason. The db is attached. Could someone please take a...

It will be done periodically monthly but maybe weekly. There is no limitation of how many values "Values" field can hold.

Hello, I would like to normalize a linked table from another database. The values that I need to link to another table are in comma delimited “Value” field. Could you please suggest how to accomplish this? I’m thinking I need to create a Temp table and run code/query to normalize the table...

@plog As it turned out, VBA editor doesn't like Is Not Null and prefers <> "". Public Function get_ActionNeeded(NextAppointmentDate, AnticipatedCompletionDate, ExtractionTime, TimeToReciept, TimeToRequest) ' takes set of data and determines the action neeeded Debug.Print...

@plog I get run time error 424. object required. and I can't get the error to go away. I'm calling the function form a query that is a row source for a form. ActionNeeded: get_ActionNeeded([next_appointment_date], [anticipated_completion_date], [ExtractionTime], [TimeToReciept]...

Error message says that I'm missing a bracket or a vertical bar. ActionTwo: IIf(Nz([next_appointment_date],0) < Date() + 2 And (Nz([next_appointment_date],0) > Date(),"Request Anticipated","false")

@Mark what's wrong here? ActionTwo: IIf(Nz([next_appointment_date],0)<Date()+2 And Nz([next_appointment_date],0)<Date(),"Request Anticipated")

@plog Please give a short example of how to write this sort of function and how to call it in a query that is row source for a form. Thanks, Mila

If anyone is interested here is the entire formula that I'm trying to breakdown into parts because I can can't get it to work.

ExtractionTime: IIf([nucleic_acid_available_date] Is Not Null,DateDiff('d',[blocks_slides_req_date],[nucleic_acid_available_date]),"") ExractionTime expression returns a number or nothing. There are no errors. if the number of days is greater than three I want to return "Consult...

i don't want it to return error but it's returning error when there is null value.

ExtractionTime is a number derived from another query. I want it to return "consult technologist" when [extraction time] > 3 but it still returning error when [extraction time] is empty.

Hello, The following query formula is throwing an error message when for records that don't have any values in [ExtractionTime]. ActionThree:IIf(([ExtractionTime] Is Not Null) And Nz(([ExtractionTime]>3)),"Consult technologist") What is the correct syntax? Thanks, Mila

that was it! thank you!!!!

please help to figure out why your code removing other values beside the duplicates. Here are two outputs with the original code and the modified code: My code: AKT1 exon (3), ALK exon (21), ALK exon (22), ALK exon (23), ALK exon (24), ALK exon (25), AR exon (6), AR exon (8), BRAF exon (11)...

Do you know if there is a limit to strExpr string size, like 255 characters? thanks

Ok, I get it. This is great! Huge thanks Mila