Search results

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...

Perfect. Thank you

I have created a form on which I have two textboxes with a Date format (mm/dd/yyyy) Text1 will be used to store a specific date Text2 should automatically add 1 month to the previous date I have used the following code to the Default Value property of Text2 but after entering the date in...

Hello Pat. First le me thank you for your help. I have removed the DOC fields in the LOG table but am confused on what control rename txtinputfile. I have tried to add your codes to my sample, removed the unbound listbbox and replace it with a subform which has its records source to the DOCS...

Hello, as recommended, I have created a new table. Unfortunately I am now having a problem when adding a New Record to my DB. This only happens the first time, when there are no other records in the db. I am sharing a test copy of my database. It is used to keep track of document we receive from...

Hello, I have a form with a combo and a textbox. The combo has its records source to a table named documents. The text box is unbound. I was wondering if if would be possible to copy different records (not at the same time) from the combo box and place them in new lines in the text box...

found the solutions. I removed the Environ$("userprofile") & code. Working fine now. Thanks

Thanks. Obviously I did search in that folder but it is not showing. Very very strange. Don't want to trouble furthermore. No hidden files in the folder. I have tried it on another standalone PC and works fine. Maybe it has to do with some security settings on my machine as working on a...

Still cannot locate the file. I also tried to rename the path (C:\Documents\myReport.pdf) but just cannot find the file. Sorry about it.

Hello Arnelgp, I have tried your db and actually cannot locate where the file is actually stored. After selecting a value from the combo, I cannot see where the report is. Is it because it gets deleted with the code Kill? Thank you

Thank you I will give it a try.

Thank you for your replies. I now understand why it appears on the second page as it is a place holder. About the code I placed it in the report as not sure how to use it with the send object code. Is there a way, I could include the second report in the above code? Thank you

Hello, I have created a main report for my db which includes a sub report. On a form, I have a cmdbutton which converts the report into a pdf file and attaches it to the email. Depending from the value selected in a combobox, the report may or not include the sub report. If selection in...

the control's name is correct. Finally got it to work. What I did, is completely remove the code and wrote it again, once sentence at the time so that I could troubleshoot it. The first part is what probably was causing the problem. Thank you If Me.DEBTTYPE = "partial" And IsNull(Me.RemNo) Then...

Sorry about the if is null. It was a typo. I removed the quotes. The code does execute until the msg box but but then it gets stuck, meaning that nothing else can be done and have to close the entire db.

Hello, I am having problems with the execution of a if/then statement and an exit sub procedure. Just cannot figure where is the mistake. I appreciate your help. My project is to create a db to manage refunds which clients are due to my company. Once in the main form, users will select the...