Recent content by JPR

Hello, I would like to add two unbound text boxes on a form which indicate the 1st day of the current year (txtFrom) and the current date (txtTo). Thank you for your help.

Hello, I have a vba that export data from a form to a MS Word template. It works great but I would like to add a final code that allows wither to open the file in case users need to modify it, or print is double side. I cannot specify the printer type as the database will be used my multiple...

Thank you

Hello, I have a table with a filed named CustomerFileNo which is made of 10 digits plus one or two characters which identify the customer. ex: 0000000000A 0000000000BB I was trying to create a new field that only shows any digit or character after the 10th digit but can't get it working: ex...

Works just great! Thank you

Hello, I have a form with a cmd button that exports data to MS Word template. Presently the word file is saved via code too just one folder (C:\MyTemplate). I would now like to change my code to save the word file into different folders depending on the selection in a textbox (txtfolder)...

Hello Pat, "Age 70" obviously is just an example of what I want to show up in the textbox. Thanks

This last code works great. Just was I was tryin to achieve. Thank you. Appreciate your help

Hello, No, I will not pick up the data from a table. Since it's a simple projection, I would like to write this estimated retirement age via code. I do not expect to write more than 10 lines each of which will refer to a year. Example: if me.txtdob between 01/01/1951 and 12/31/1951 then...

Hello, I have created a form with two unbound textboxes. txtDOB in which i type a date of birth (mm/dd/yyyy age format) txtRetire in which I would like to add a text via code, depending on the age range entered in txtDOB. Examples: If me.txtdob between 01/01/1950 and 12/31/1950 then...

No code. I don’t use reports but just print the current record which is displayed on the form

Hi. All other apps work fine. They all print to the default printer

Hello, I have a form with a cmd button which refers to a macro to quick print the active form. Suddenly, the print function does not recognize the default printer (PRT1) and all prints are sent to a different printer (PTR2) which is not the default. Both printers are shared as part of a...

Thank you for your reply. Actually this is the way the sub it’s setup.

Hello, I am creating a small db to manage member of a sports club. I have a two main tables: Members and YearlyFees Memebers is to store general info. Yearlyfees is to add the yearly fee each member pays. The unique code for both tables is ID. I first add a new memeber, than save the record to...