Search results

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

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

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

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

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

Hi guys! My name is Adrian and I work with Access for a couple years. I decided to join this site to get new ideas and keep my knowledge up to date. I think this is also the place to get some help if needed. Thanks!