Search results

In this particular case I will be referring to it in multiple views and forms so if I design it once I can reduce the complexity of a number of queries. You wouldn't happen to know? If you persist a computed column will it re-calculate when the record is updated?

Just solved my own problem. Its great that articulating an issue helps to more clearly define the problem leading to a better investigation towards a solution. One of the reasons why forums are soooo good...

Postscript I guess I can use something like the case statement put it in a function and then reference the field to the function? https://www.w3schools.com/sql/sql_case.asp

Hi all I am trying to create a computed column as per Computed columns But I would like to use a conditional statement to create the value IF datefieldvalue is null or >= Today computedfieldvalue = Future Else computedfieldvalue = Past END IF Has anyone any pointers ?

This is the vba I use to get lists of files from a directory so swapping out the rs. stuff with some kind of name code as per Cronk should automatically work through a whole directory although a function like that is pretty powerful make sure you make a backup of that directory before you do it...

I'm with everyone else I would never put image files into Access - although its an option I have always ran out of space incredibly quickly doing this. PS - if you want a cheap option for a SQL server Postgres is excellent - open source and likely to be able to cope with anything. I suspect...

Colin if you are looking at wordpress - OceanWP have a free offering which seems quite good. I don't use it on my blog I use default 2016 theme but that was more because of timing. I have done OceanWP for a client and so far I have liked the balance of flexibility and control that it offers. It...

Hi Colin Others people code always looks way more interesting than your own! I will set up a links page and let you know. Thanks for your work. Update : I have a links page as well now.

Just tried it in MS Access 2003 and it seems to work. Seriously for me Access 2003 refuses to break - I can still connect to Azure with it.??? In some ways maybe this is a good thing maybe they will test better before release especially for MS Access.

Hi Colin I've been writing and collecting some simpler functions here which people may find useful. Its somewhat simpler than many of your links. https://rounduptheusualsuspects.org/?cat=16 I figured out how to create SQL queries and put them in a table and then run them from a table. Its...

Sorry I would be in the same situation as you if I had those limitations. Posts script : I would have another go as Gasman states below

Looks like you might be stuck. If you can't run code you can't run code... For anyone else https://rounduptheusualsuspects.org/?p=1386

Thanks guy - that counting everyone that is lower sounds so deceptively simple wonder why I couldn't have thought of it myself...!

I've had some very limited experience with this. I did manage to use VBA to navigate to multiple websites and enter a planning application in a field and then submit that for a search. I am guessing it could be adapted for more significant input and submission. Have a look at this Navigate to...

Another discussion that might be useful https://stackoverflow.com/questions/4463116/use-access-sql-to-do-a-grouped-ranking

This looks like what I was looking for will just have to convert to MS Access http://sqlfiddle.com/#!18/4d6b4/1

Hello everyone Another questions about a race timing system 4 finishers In a report or a form what do you believe is the optimal way to rank finishers such that people with the same time are marked equally eg 1 - John 2 - Bill 2 - Colin 4 - Thomas With the ranking running automatically off...

Referential integrity WILL CATEGORICALLY enforce the relationship between tables across all forms. It also automatically sets up the correct relationship when creating queries. Lookup tables on forms MAY IF SET CORRECT enforce the relationship between tables and will have to be set correctly on...

Thanks everyone - this was largely the conclusion I had come to but was just checking. I will have a go at something a bit more bespoke.

Dear All I'm thinking of putting together a simple database that can print out race numbers for athletic races. I'm using MS Access 2003 and from limited testing it seems I am limited to a font size of 127. The numbers on the bibs probably need to be quadruple that size. I am thinking of...