Search results

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

Hi here's some information on setting up a standard import that you can automate to import all files in a directory into a table https://rounduptheusualsuspects.org/?p=1825 You should be able to convert that into importing excel spreadsheets by replacing the DoCmd.TransferText to...

No problem Z You sound like you are well on your way. It sounds like a fun project. Those templates are kind of fun as they are nice and theoretically pure so unlikely to really age and should be available in any database (with tweaks to the code and implementation). Generally speaking you can...

Transfer of the entire local authority building control and development control records for local authorities in the UK between Oracle backends - the biggest provider in the UK uses MS Access as a significant tool within their Export Transportation and Load projects. They also recommend MS...