Search results

Hello, My problem may be quite simple for you. I have only one bound text field in my report. By default, it shows the results (150 records ) vertically. I wish to show them horizontally, 5 in a row. Please help me how to do this. Thank you.

... I may update CustID 5000 and may not update CustID 5001, may update 5200 and may not update 5330... Hope this helps. thanks again.

Thanks CJ, But I am not updating all the records between 5000 and 5999. Only the relevant records. That said, I need to specify each CustID in my update query. Thanks again.

Thank you jdraw. But I am not updating all the records in the table. Only around 5000 records. Thanks, Rajan

Thank you. Table Name: MasterData Field1 : CustID ( Text ) Field2: GivenName Field3: LastName Field2: ContactedOn ( Date ) I need to update the ContactOn field with date where the CustomerIds are the 5000 numbers (Criteria). Sorry, I deleted the query since it was not working...

Please help me.. I have around 5000 customer ids ( field name: CustID ( 45632, 46372, 85633.... ) data type text. I need to update the field called ContactedOn with a date 10/10/2014. Please let me know what is the best way to do this. I tried to use the query builder, but it says...

Thank you very much. It works.

My question might be trivial to you. Please let me know how to do that. I am able to get the user name of the computer using a function. The function returns the user name in this format: first Name.last name. ( Example: philip.daniel ). I wish to display only the first name ( the name...

Thank you, I was able to resolve it. When I compiled, the error message is gone. Thanks for your help.

Thank you, It is a splitted DB. You need only the forms or both? Thanks.

I am back again. I am getting an error message "FieldArray(0)=<Subscript out of Range>" error message. currentVal = FieldArray(0) is highlighted in the debug mode. I double checked the names of the text boxes, they are correct.

Thank you very much. It is very helpful. Thanks again.

Yes, they are actual dates like 02/04/2014, 04/08/2014. I am not able to figure out how to do from the link you provided. Thanks.

I need your help please. I have six textboxes in my form. First 5 textboxes have dates ( MMDDYYYYY). In the sixth textbox I need to display the minimum date among these five dates. Thanks for your help.

Thank you very much. It helps me.

Thank you, My specific question is how to address the last departure date in my date calculation, since it could be either in text2 or text4 or text 6. Thank you.

I need your help please. It looks very hard to me. It is like a date calculator. 1. I have 12 unbound text boxes in the unbound form in 6 pairs. 2. Text1 receives the arrival date and Text2 receives departure date, Text3 receives arrival date and Text4 receives the departure date and...

Sorry for the delay. Yes, you are right!.

Thanks Burrina, Can you please give me the code for that or let me know how to do that. Thanks

I have designed a form like this: cboState - Combo to select a state cboYear - Combo to select the year cboQuarter - Combo to select the quarter (1,2,3) Each record in the table has a OLE container with a pdf file for all states, all years and all quarters - Not linked. The user...