Search results

Plog I think my post might have made it more complicated than it is. My firm produces weekly invoices for clients, rather than try and work out the due date i was hoping to have a field on the report that took the following into account: Today's date; the number of days to the end of the month...

Hi Is it possible to code the following: An invoice is created with a textbox of =date(), Clients have varying due dates; 30, 60 and 90 days from the date of the invoice, easy to code =date()+30 etc. So far so good, However, here is the twisted, the due date days only start ticking: at the end...

Thanks Ranman, I'll give it a try and let you know how i get on. Regards EasygoingDave

The code below successfully saves a .pdf file to my c: drive. However, on occasion i want to overwrite a previously saved invoice e.g. 3815-140515-Bristol with an amended invoice but retain the same Invoice Number e.g. 3815-150515-Bristol. Currently, if i save the invoice with the same invoice...

thanks for the reply, and apologies for the lack of information. The current Db is for a small security firm whose staff are employed at different sites for 1 or several days. The current form only allocates one day at a time. If a member of staff is allocated 5 days work at the same site, the...

I am currently updating an old Db which rosters staff. One of the enhancements will allow the user to automatically allocate staff details to a Roster after a given date. i.e. Roster date 20th Feb 15, repeat for 3 days. 21st 22nd 23rd Feb 15. I have created a form with a medium date field and...

David, worked a treat many thanks for your time. Happy New Year :)

David Many thanks for your prompt reply. I will add the lines tomorrow and get back to you.:)

I know there is a simple answer, but i am a novice to Access and what will take me hours to find a solution will probably take this forum a couple of minutes to solve. I currently have details of my clients in a table called tblSites, this tble includes a field with an email address. I currently...

David Worked a treat many thanks for your help:)

I have generated a report in acviewreport, after viewing the details I want to save the report as a pdf file with the client name, invoice number and date. In the report design view I added a cmd button and successfully coded it. However, it saves the report WITH the cmd button showing. I don't...

That's exactly what my colleague said, I have now re-designed my report to resemble an invoice. However, I am struggling to get the client's address to compact and fit into a txt box. The main reason I was using Word is the finished product requires emailing to client's, so I will convert the...

JHB Many thanks for responding, but I not sure I fully understand the mail merge process. I had intended to run the query from Access via a form, inputting parameter values which instead of producing a report it would output a mail merge word document to my design (produce an invoice). I thought...

I am trying to mail merge from word 2013 to a query in access 2013. I initially had problems displaying the query until I came across a solution regarding connecting via DDE. I can now link to the query but it then asks me to 'enter parameter values' from the query. I have already run these...

Frothingslosh Worked a treat, many thanks for the help.

I have the following code for hours worked by staff over a 24hr period. However, I want to calculate staff pay by using their hours worked. The table I am using is populated with the minutes i.e. 270 but I want this field to display 3.5 hrs. I have initially got round this by using a calculated...

Mr B. Many thanks for your encouraging words. I have had a dabble at Access and do have a basic understanding. My Client (daughter) will have no choice but to wait until I have mastered the intricacies of Access. Thank you again, and I am sure I will be using this forum to solve many of my...

I have put together a monthly work roster in Excel 2010 for a small security company. It works quite efficiently, but they now want to produce weekly/ monthly client invoices, staff hours and numerous other queries. Their requirements and now pushing me towards an Access Db, which I am not too...