Search results

Hi all, I am working on a form to show different statistics on the database I am working on, the quotations raised on the database are valid for 30 days, after 30 days we send a quote reminder via email (already set up) & another 30 days are added before the quotation is cancelled on the...

Hi all, I am sure I have done something like this before but I can't find the database I tried it on. I would like to create a query to group the sample data shown below to use in my main database I am working on, the material type has up to three different project types that it can be carried...

Hi all, i need to make a new report on the database I created for use in our office so we can find the top spending clients between two dates selected on a form, I guess it will be mainly used for top spends by clients for the year but being able to choose selected sales between two dates would...

Hi all, We are short a couple of staff members in our office since staff members have left our company, I'm not going to lie but I am trying to import the functions of a database created by someone else before I re-joined the company that we don't have much contact with into a database that I...

I'm thinking about a couple of new projects for work for use on site using laptops with touch screens or a windows tablet. There are a couple of things I was wondering if they were possible or not. 1. If an access database is on a windows tablet & a form is being filled in would it be possible...

HI all, I need to update the ClientName field that is currently empty on one of the tables on my database using the ClientName field on the Clients table, I have been looking online but I'm not sure the best way to do it so any help with how to create the query would be appreciated. Table...

Hi all, I'm trying to add a couple of features on one of the databases I built for use at work, one doesn't work at all & the second isn't working exactly how I want it to so I thought I would kill two birds with one stone in one thread. I've done some googling & searched on here but haven't had...

Hi all, I have done a bit of searching online, didn't really see a what would be the best way to do what I need One of the fields on one of the forms on one of the databases I have created I want to use its contents as part of the file name when a pdf is created, with it being used as part of...

Hi all I've just tried adding a VBA code to a button for searching a subform on one of the databases I am currently building but I am getting the error "Expected: End of Statement " I have used the below code before many times & haven't had a problem before, here is a sample of the VBA code I...

Hi all, I've come across a problem with the database I am working on, there are a few things I need to suss out but I want to get this out of the way first I'm posting this in the tables section as I guess if it can be done in a table then it can be transferred to forms & reports etc, I want...

Hi all, I'm working on fixing one of the databases at work, it wasn't displaying the client name or site address when a text field was added, only the clientID & siteID numbers were displayed, to get it to display the client name & site address how it should I used the below DLookUp code as the...

Hi all, I need to build a database to log the results of the audits our managers do on site, I haven't ever built anything like that before & I was wondering of the best way to go about it. Each audit would have the following fields updated on a table AuditID (pk) AuditDate (date/time)...

Hi all, I am using the below code to create a temporary file in .pdf format, open an email in outlook, attached the .pdf file & add an email address, a subject & body to the email. Everything is working fine with the code apart from one thing, it doesn't add the signature at the bottom of the...

[SOLVED] Refreshing only certain fields on a form after a subform has been updated Hi all, I've been attempting to modify the database that was originally posted here https://www.access-programmers.co.uk/forums/showthread.php?t=176891 Code is added so the main form refreshes after the reason...

Hi all, I have created a database for my girlfriend to use at work to create quotes, she wants to be able to run it from a USB drive on both her work PC & her home laptop, she also wants to be able to back her database up at the push of a button. On the databases I have created at work I run...

Hi I'm Paul I'm noob'ish at access but doing my best to learn all the time picking up how to do things on sites like this & adding what I learn to improve the databases I create. I created my first 3 databases a couple of years ago at the company I used to work at & even though I have moved on...