Search results

OK you sound competent to good at access (apologies if I am underestimating you) I'm going to suggest some steps for you probably in this order. This happens to have been my journey as well. Download SQL Server Express and get it installed somewhere on some kind of network would be good but...

There is one further practical consideration for making ID field integer Autonumber primary keys have to be integers. Plus if you want to use referential integrity I think access requires integers. Unless forced if you want a long life just use integers for keys :rolleyes: The students and...

I would definitely research single azure backend linked to the required number of front ends. Creating your own transfer protocols probably is for the confident and interested. A developer SQL Azure database starts at about £5 month this should be all you need until you have the principle up...

I changed unstable to - complicated and confusing to put together. Undoubtedly a measure of my knowledge - I've only dipped my foot in web applications development. I find web form design more intricate and tricky there are less people about to ask questions and error trapping is sparser...

Azure managed SQL Database backend with local MS Access front ends can be really nice. Access runtime is free so don't need to have a paid licence on local computers Access runtime 2016 There should be runtime versions of all Access versions but they get harder to find as you go for older...

Gus things are moving to the web and there are low coding options for the web which is probably why it is confusing that Microsoft have chosen to deprecate the acces web option. Here's my conclusion on tools for developing web databases I wrote this back in January 2017 but still applies I...

Yes you are looking at a many to many relationship All databases implement this in the same way as two one to many relationships with something called a junction table in between. Carefully study this video should be better at describing what you need to do than anything I can write. Once you...

Yep once you start getting to that larger scale automation you do need to get creative. Sounds like you are well on your way. Be aware that programmatically implementing compacts and repairs is a bit tricky because Access can only perform a compact by closing the database which effectively...

Here's some code that I used to create some HTML in a text file - You could easily adapt it for your need. You will replace the target recordset with a query or table and you should replace the Easting and Northing items with the field names you wish displayed in your file. Sounds like you are...

We are doing a system transfer of information (there is politics involved) Important notes need to be related to an application number for a planning system. There is no where to store these in the new system so rather than destroying them I am exporting these to files. There are enough that if...

Cronk I was very impressed by some of the things Dev Ashish put together from the Access Web.

I think what Ridders and Gizmo might lose from being open is more than made up for by the increased visibility and status they get from being open. In 12 years of using Access I've not come across any applications that are knock offs. Interestingly I would be more protective of code relating...

Very interesting Tony - that barcode example is really good. Haven't needed it but might well in the future

I would add that helping others re-enforces understanding of one's own knowledge and if you happen to be reading about a problem you happen to have fixed relatively recently its difficult to resist trying to see if you can fix it. :D

Thanks yes will try

Here's something that I haven't tried to do before. If there are a small number of field values that error out eg in expression calculations within a query. Is there a simple way such as Not #Error? Running a loop of a query and there are a small number of values that have calculated out as...

This is the process in Access 2003 but its almost exactly the same in all versions of Access. Open the form you wish to have the button on in Design Mode. Using the form toolset select "button" and use the mouse to draw its outline on your form. Right click on button and select Properties. A...

Good idea and good thread to subscribe to

USING a VBA onclick event - Within the On_Click Event of the ListBox - my listbox is named List0 where ID filters the record you are wishing to show in the Form1 (change this to the name of your form) I would normally close the form with the list box on it prior to going to the form but I've...

Office 365 does seem to be increasingly better value and with Access now included in more versions more appealing. I do like my hard copy CD as to a certain extent it gives me the choice of when the software becomes obsolete. 2003 runs great with Windows 10 - its not really a cost issue for me...