Search results

Updated links to downloads and code library location. All the best mick.

In this video we create a couple more lookup lists, our artists Types Sub form, Plus use some code to Auto file The Combo Box List Related Files: https://www.databasedreams.co.uk/support/index.php?action=downloads;sa=view;id=60

With this lesson we create our UI/Front End, Update the database Settings, Link to the datafile tables Create a template form, a main control form plus a List form and use a bit of copied code ;D Download: This lessons files Here

The Final Part Of The Tables Design lesson 4 The video covers your main tblCharts Table & a related table tblLabels plus a few related forms view from CTE 2525 The Next offering will cover creating a few simple forms Plus we'll make a start on the main control. Files Available Here...

The third Offering Adding tblArtistsAndTypes, tblArtistTypes, tblChartNames. Also demonstrates the usage of related items and how simple importing charts is :D Related Files Download: https://www.databasedreams.co.uk/support/index.php?action=downloads;sa=view;id=57

This is the second Offering Of the Simple Charts Database Design This video Takes you through Adding tblArtistsAndRecords, tblChartRecordings and tblFormats Plus shows related usages in my database CTE2525 One Note I made a mistake with the Points field I should have left a default value of 0...

Just finalised the version 1 ERD This is as simple as possible but will be a good Foundation

I have agreed with another music/Charts forum to Help there members build a simple charts tracking system. This is being designed in lessons 3-4 per week using my Code Library and Project Management System I am constructing this as simple as possible but later intend to take it further in small...

Sorry to jump in but the Above statement is incorrect and even misleading. If a Access accdb Datafile backend tables are designed correctly and depending on data types within a table that table can hold 10+million entries, I have Tables with 6+Million Entries (With A Single User) Chart Tracker...

What I'm working on is a data Update, The Left list holds the Main Data That is to be updated Depending on Chart, Date, Twk and Lwk, In most cases I will be able to use the select all as I would have made a visual check but sometimes I may need to match Items By selecting a Item in left list and...

Thanks @June7 But wont work for me As will be using a ACCDE, And may make the system over complicated so will use a test to see how many items have been added, I'll store each row in a local so I can unselect it should there be 1 item already selected. hopefully that will work lol

Thanks Didn't see that

Really Don't remember Using "That's not possible" Anywhere in my post I asked a simple question do you really want me to explain every design concept I have used in this project which Is running at over a 1000 hrs to date.

I have a form where Under certain circumstances I would need to set A listbox Multiselect property to 0 from 1 in the after update of another listbox. https://docs.microsoft.com/en-us/office/vba/api/access.listbox.multiselect I have tried the above and also Me.Lst_Sales.Multiselect = 0 Which...

All my programs are freeware i don't have clients but if I did then I would of course invest in suitable software

Thanks found a free limited one https://www.screenleap.com/ Which looks promising plus they has a api I can use on my site. Thanks Just waiting on a replacement headphone/microphone as you guest it dug it out and the thing don't love me anymore :(

Not quite sure what to call this but title fits it best. I am looking for something I can use to: Demonstrate My programs/Site Etc The User(s) should NOT be able to interact other than though Voice so the users join and can watch and ask questions Say how do I do x&y but nothing more Would be...

I don't know is US Sizes are different to UK Sizes but that looks like a standard size I.E 26in Wheel and 2in which in a narrow inner tube You should be able to go to any bike store and they will advise you

This is what I use on one of my systems, I copy all fields which are then updated depending on the export type conditions. This is used in a buttons on click event Dim R As DAO.Recordset Dim I As Long On Error GoTo HandleErr Set R = CurrentDb.OpenRecordset("SELECT * FROM tblOutPuts"...

Thanks @Uncle Gizmo I will have a look as yes I am very rusty but have found some very good books https://www.amazon.co.uk/gp/kindle/series/B08X1BQ2DH?ie=UTF8&ref_=series_rw_dp_sw They not only take you through the basics but they tell you what you need to use. As Luck has it I just bourght a...