Recent content by NewFruit

Dear forum members: Kindly help with the following. We have a data-entry form with a button which would allow the user to save the record in a table (multiple copies of the same record similar to what is seen in calendars/events i.e. recurring with the following options 1 to 5: 1) "Every...

Thank you so much Afridi bhai (brother). That works just perfect. Issue [SOLVED].

Thanks for the code and your replies. A few more questions: 1) Where do I insert this code: should it be in an "unbound box" of a report? 2) If it is in an unbound box of the report, how should I assign the value of the variable "conField1" which is being generated from your code? 3)...

Thread bump. 107 views and 0 suggestions, hmm...did not realize it is such a tough question!:banghead: I am attaching the following snippet of how it needs to print in a portion of our report. If it can't be done in Access, experts please tell me so or any pointers will be helpful. Thanks in...

Hello all: Just bumping up the thread. 54 Views & no replies! I hope I asked the right question. Making the 3"x2" box on the report was easy but I am unable to populate it with the data from multiple records and same field. Note, I am not trying to concatenate two fields but merely trying to...

Kindly help with the following report: I have a table with field “FRUITNAMES” with the following text records, the fruit names keep changing based on vendor requests (for example): APPLES MANGO STRAWBERRY PAPAYA ORANGE KIWI REDAPPLE CALIFORANGE I would like to...

Deen: Welcome to the forum and will be glad to help.

Bini: Welcome to the forum and will be glad to help.

Welcome to the forum and will be glad to help. Feel free to post any question but I would also suggest you perform a search for "your question" because from replies to other questions you may probably get the answer to what you are looking for, or the other questions/answers could also give you...

Christi: Welcome to the forum and will be glad to help.

Welcome to the forum. I am also learning the vba & Access programming connection. I have been lurking around this forum and they have great vba code to use with Access. And most important the forum members are well qualified and seem to be experts in Access.

Nancy: Welcome to the forum. Go US.

Welcome to the forum and will be glad to help.

Bob: You are awesome. Thank you so much, this is exactly what we want. Cheers from NewFruit & my fellow staff, we are thrilled. Now I need to figure out how to mark this message as "SOLVED".

Bob, I tried the query method u suggested but the report only prints only the three or two records (as the case maybe) from the "TableFruit". Let me try to explain it in another way. Think of the "report" as a pre-printed stationary with the following: Type of Fruit Quantity...