Search results

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...

This is a standard option for cleaning corrupt databases - you can lose the relationship diagrams but that is it. I like to periodically compile the VBA in my databases I also like to periodically make them into runtime and perform compact and repair. If I can't conduct these procedures on a...

Yes It looks like your program makes copies of both the weekly and monthly database at the same time. Isn't there supposed to be a time difference? It looks like it's doing the same thing twice every time. Its copying one file and putting a month suffix on it and copying the same file and...

I must say I've only had a couple of issues in 2 years and find it incredibly stable compared to the frozen tissue paper of dependency that are web applications. Nonetheless I sleep better when I implement rolling backups on important applications. For all applications I will have. 1.a Back End...

Another option is to have a table of SQL Strings and the call the SQL and run it from VBA - this can be good if you have a large amount of SQL strings to run. Public Function RunQueriesFromTable(SQLSource As String) DoCmd.SetWarnings False Dim StartTime As Date Dim EndTime As Date Dim rstZ As...