Recent content by PaulD2019

  1. P

    Is this possible with VBA?

    Thank you for all your replies, I could look at syncing the data when connected to the network for one of the databases I was thinking of but it wouldn't work for the 2nd as to get the data each day our staff would have to come back to the office each day which is one of the things I need to...
  2. 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...
  3. P

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

    Thanks for your reply, I know it is normalization & a join is already in place, I need to fill the field for another reason. Any help with the query would be appriciated
  4. 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...
  5. P

    Trouble adding code on date fields

    Thank you again pbaldy, it works now
  6. P

    Trouble adding code on date fields

    Thank you Uncle Gizmo, I'll have a look at those links
  7. P

    Trouble adding code on date fields

    Thank you pbaldy, that works now :) , I just need to figure out the other problem now
  8. P

    Trouble adding code on date fields

    I haven't done that before (still learning), unfortunately the database is a bit of a mess at the moment as I am working on rebuilding it & getting rid of stuff that isn't right on there & adding new features, it would take me ages to clear all of the data & images from it. I've just made a...
  9. P

    Trouble adding code on date fields

    Apologies, the combo box bound column is the actual job status ("Works Booked", "Quoted", "Invoiced" etc) not an ID field, nothing happens at all when the combo box is updated/changed, there isn't an error or anything like that
  10. 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...
  11. P

    Best way to disallow special characters in a field

    Thanks all, I'll look into adding some VBA code to the fields OnChange event
  12. 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...
  13. P

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

    I've tried having them commented out & removing the ' its still not working though, annoying that it isn't working but tbh I could probably do without the search function on the form. Thanks for both your help in trying to fix the problem :)
  14. P

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

    Do you mean remove both of those lines out of the code?
  15. P

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

    Thank you @MajP & @theDBguy I've saved that link in my favorites There aren't any errors anymore but the button isn't doing anything at all now
Top Bottom