Search results

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

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

I really like this structure for contact information I consider this the exact same as the key value database model. http://rounduptheusualsuspects.org/wp-content/uploads/2017/11/KeyValueTableStructure.png

Sounds like you've totally got it. And now we are back to a single table It would seem that after our discussion my conclusion is.. For many to many relationships where one of the two one to many relationships is finite (eg 2 parents to 1 child) data can modelled either using many to many /...

Hi jmq - I actually thought quite a bit about this during the night. I used our discussion as inspiration for some thoughts that I expanded on and put in a blog post. You can actually model the relationship we have been investigating as either many to many / one to many / one to one or as a key...

The actual Biological Parent to Biological Child relationship is somewhat more subtle than the classic description in books would have you believe (they constantly equate the parent child relationship to a one to many relationship). Strictly strictly speaking biological parent to biological...