Recent content by Adriano85

Hi guys, I have created invoices as reports but now I'm looking for a way to add an invoice number to it. It needs to be an auto increment number for every invoice for every client. I have 10 different clients and I want them to have their own incremented invoice number. Every client has it...

Thanks mate! Cstr([fieldname])*100 Did the job. Amount in cents as a string.

Hi guys, What is the best function to turn a currency field €10,00 into a text field like 1000? Many thanks! Adrian

Hi guys, Does anyone know if there is an option to open an existing form and click a button on that form? Is that possible in the macro builder or should I do this in VBA? Many thanks for you help! Adrian

No I didn't yet because I have no idea where to start in VBA. I have been looking for more information about VBA but it didn't help me a lot yet. But basicly this should be an easy macro to write if I had more knowledge correct? Thanks.

Hi guys, I have created invoices in a report based on a weekly basis. When I run the report it show all invoices to be send from the last week. Around 100 invoices. When I choose the option to send it by email the whole report with all 100 invoices is attached and that is not what I'm...

Eugin, this is a VBA code right? To be honest I have no experience with VBA so tried to put this code in VBA but constantly I received errors. (not very surprising) I did build a button that did almost everything that I wanted exept the part of putting the email from the form into the TO...

Great! Will play around with those. Thanks for your help!

I dont have a code yet. Im also not sure what would he the best option to realize this. In the macro you can select the receipents address so I did something like: [forms]![formname]![fieldname] but unfortunately that did not the job. So Im looking for some ideas how to fix this and what...

Hi guys, I have a form that shows first name, last name, email, date appointment, time appointment. If I just select the regular email option (form attached as pdf) I have to type in the email address manually. How can I make sure the form is attached as a pdf to my email and the email...

Hi Pat. Yes I tried but it did not brought me where I wanted to be. Not because your advice is not correct but because I don't have enough knowledge about this to realize what I want. Thanks for your input anyway.

Thanks for your help guys. Unfortunately this is not what i'm looking for. Between.. and.. needs to be manually amended once bonus fees change and this is not the best solution. I think I did not explain everything good enough for you guys to help me. What I'm looking for is something like a...

Hi guys. First of all, sorry for the vague description in the title. I have no idea what the name is for the function I'm looking for.. Bascily this is what I'm looking for; I have a table with the number of sales and the bonus that belongs to that number of sales. I don't have a record for...

Thanks for your advice. I will have a look!

Hi guys. Im creating a report that is using the following data from a qry; sales rep name, sales month, count(contractID). Grouped by sales rep name and sales month. The report is showing all data I want but I need to seperate every sales rep name on his own page so every sales rep can get an...