Search results

  1. P

    Is this possible with VBA?

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

    Query needed to update a field on one of the tables on my db

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

    Trouble adding code on date fields

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

    Best way to disallow special characters in a field

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

    Problem With Search VBA Code - Compile Error - Expected: End of Statement

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

    Change date format to display dots instead of forward slashes?

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

    [Solved]Null field for "new" line in list form when using DLookUp

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

    Design of a database to log site audits

    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)...
  9. P

    Adding Outlook email signature to email created by VBA

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

    Refreshing only certain fields on a form after a subform has been updated

    [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...
  11. P

    Help backing up a database that is stored on a USB drive

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

    Great site

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