• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Search results

  1. Minty

    Assist requested. Providing a Query with criteria from a field on a form.

    This suggests that the missing query parameter is mistyped with regard to what you think it should be (presumably it's a reference to the form control?)
  2. Minty

    Slow Search on Subform

    I guess we should be asking what the issue is that required you to use a subform? Is the subform linked to the main form in any way?
  3. Minty

    Data disappearing from report.

    What happens if you simply (temporarily) comment out that code? Whilst I can't see why it would be causing a problem either, start at the simple end of the trail.
  4. Minty

    Sebseb538 introduction

    Hi Seb, and welcome aboard AWF!
  5. Minty

    Fill in table fields automatically from dropdown

    You shouldn't (and can't) do what you want directly in a table. Tables are for storing data, not interacting with. Stick with your form. As well as redundant data an Age field is meaningless as it is only correct at the time of data entry. Age should be calculated from the date of birth and...
  6. Minty

    Add Working Days, excluding We & hols. Function is mixing dd/mm

    I found the best way was to actually dive in with a specific task in mind. The real secret to success with a new thing like VBA is to break it down into very small steps. So if you need to manoeuvre something around (like a time/date) do the basics in a query, use the QBE editor to select a...
  7. Minty

    Slow Search on Subform

    By adding the wildcard to the beginning of your search string you are rendering the Index on either field useless. Do you have to search in that way? Try it by removing the first wild card and I bet it speeds up considerably.
  8. Minty

    Just saying hello

    Welcome to AWF Javier!
  9. Minty

    Spurious 'SELECT [Id] FROM [Table]'

    That's a really interesting find, thank you for posting back about it. I've only had limited use of GUID fields, so not experienced the issue.
  10. Minty

    Spllited Database risk over LAN Network challenge ,please how to Secure?

    I think it would be easier to let the users only use the database with a touch screen.
  11. Minty

    Fitness Tips in this time of Pandemic

    @Jon Buy a set of clubs and join in. It's definitely the most frustrating hobby I have ever had.
  12. Minty

    Access Running Slowly

    I wouldn't worry. On a Friday it will only be someones recipes for the weekend :eek:
  13. Minty

    Solved Remove Time Stamp From Table Field

    You have spaces in your field names, which is not a good idea. Welcome to bracket city, where you get to do extra typing for lots of no extra reward... ;) Update [Outcome Master] SET [Appointment Date] = DateValue([Appointment Date])
  14. Minty

    Solved Remove Time Stamp From Table Field

    Formatting the data does not change it, merely how you see it displayed. If you really do want to delete the time information rather than simply querying it in the right fashion to get the results you want than as @jdraw suggested you will have to run a one-time update query. Update YourTable...
  15. Minty

    Access Running Slowly

    From your description, I would suspect a network issue, above anything else, unless something has happened to increase the number of records by a factor of 10 or more. Network traffic or more importantly a network "storm" can and will cause massive problems. Something somewhere might have ended...
  16. Minty

    Error with splitting

    Take a backup before doing anything. Another route is to simply copy your entire database, in windows explorer. Call it NewFrontend Delete all the tables. Link all the tables back from your existing working copy. You now have a front end database. You can now safely delete all the objects...
  17. Minty

    Error with splitting

    That sounds very strange. It's happening on every table? What happens if you try and import all the tables into a brand new empty database?
  18. Minty

    Advice on migrating Mysql/Access DB to Azure AD

    Agree with everything @CJ_London has said. With Azure AD the IP address issue should vanish. We have found that the connectivity isn't really an issue until you start moving between countries. Ping/response times are very good when connecting to a relatively local Azure Service, but for...
  19. Minty

    Trouble with Migration Assistant V 8.14

    Is the Migration Assistant the same version on the Win 7 machine and the Win 10 machine?
  20. Minty

    Solved Independant text box value based on a combo value, with enumeration

    Rereading your post and thinking about it that won't work on a continuous form anyway, and not in the on open event of a form. Simply use either a join in your underlying query to display the value or copy the combobox and control source, and simply display column 3, make the control locked to...
Top Bottom