Search results

  1. D

    Solved Unable to update query

    Hi @Pat Hartman I added the Shows as in a earlier topic posted on the same topic as this one he had commented how he wanted to Create Playlists for his shows. I did create this from a program I'm working on, I just hope he makes use of it this time but maybe it will help others mick
  2. D

    Solved Unable to update query

    I have a feeling you are seeing compilations that somebody with a lot more experience wont see. I did post a ERD which would do 90% of what you want. Before I started work on my DJ 2020 I asked for advice on the table structure which helped me stucture my system. I do think you are stuggling...
  3. D

    New Member

    Hi Rahaman Welcome Aboard!
  4. D

    New member

    Hi Welcome to AWF!
  5. D

    Multiple instances of an Access report

    If you only want to Multiple Say Employees you could create a form with a list box with multi select and seleced all Employees/Items and loop through the selected items and add them to a temp table or create a where string to display each required item. I'm sure I did something like that in one...
  6. D

    Hello from AZ!

    Hi Welcome Aboard!
  7. D

    Solved Unable to update query

    What you need for your Recordings subform is whats called (I think I read that somewhere lol) is an auto lookup Query Like below Which is what I use for my artists and recordings to show all recordings for the selected Artist SELECT tblArtistsAndRecords.RecordID, tblArtistsAndRecords.ArtistID...
  8. D

    Exif and Access queries

    I use Exif In my picture library Make sure the location is correct This is the code I use to save the cords Picture Library This will check for a jpg image Dim C As Long Dim sngLat As Double, sngLong As Double, sngAlt As Double 'On Error GoTo HandleErr On Error Resume Next If...
  9. D

    I would love to know why micrsoft Bot is only crewling over my downloads section

    I've noticed a lot of visits from a few address which I've traced back to the misrosoft bot why only my downloads not that they can download any but it uses my page views.
  10. D

    Print Report

    You will need a way of allowing your user to add the two dates Either Input boxes or a custom form. I use this behind a form The code below uses the openArgs to print or preview a report the form is also linked to my reports table and is filtered by the calling sub Dim stDocName As String...
  11. D

    Solved Unable to update query

    The only time I would use concentrated Values is: The results Of A Search on the results screen "Used for visual Aid" On A Report
  12. D

    Exif and Access queries

    Sorry I read something that talked about the link which i found in your program. I use it a lot in the project I'm working on and along with my google account I can mark locations I need to get too.
  13. D

    Exif and Access queries

    This is what I use for getting a map location I found the link In @isladogs App above and updated FormatLink(Trim("https://www.google.co.uk/maps/place/" & AddressLine & "+" & City)) The format link function you will require Public Function FormatLink(Str As String) As String Dim FStr As...
  14. D

    Hello everyone. This is my frist post.

    Hi Welcome Aboard!
  15. D

    Make Directory Button

    I use this which has works for me for more years than I really want to admit to ;) Dim FS Dim StrExt As String, Ext As String Dim StrExtShort As String, BasFolder As String Dim AZ As Boolean On Error GoTo HandleErr StrExtShort = "\" & StrArt StrExt = Trim(DLookup("ArtistsFolder"...
  16. D

    Solved Unable to update query

    I'm not a professional (I'm A Wannabe Pro lol) I still get stuck even after 25 years, you can learn a lot but looking at the stucture (Tables) Of others Databases.
  17. D

    Solved Unable to update query

    There is a link bewteen tblas and tblArtistsAndRecords it's the contrubution combo in the recordings image I use something I designed called the style manager where I have up to 10 styles which I can switch between at will. All downloads from my site are members only but I think you created an...
  18. D

    Hyperlinks

    You need to setup a trusted location for the document(s) location(s) https://databasedreams.createaforum.com/info-center/setting-up-a-trusted-location/
  19. D

    Solved Unable to update query

    Apollo will include a playlist creator, DJ 2020's playlist is tied to an event
  20. D

    Solved Unable to update query

    The first program (DJ 2020) will be released In the next week or two, the music library (Apollo) will be released a month or so after as it's being taken from DJ 2020 and additional features added.
Back
Top Bottom