Search results

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

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

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

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

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

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

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

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