Search results for query: *

It also cause allsorts of other problems I forgot to mention. I use a table (report) fromn the database to export as html to upload to our website. I cannot do this from the pc (the one with the runtim error on) It says' "cannot find the database on server". I end up having to run it on a...

I kinda just "scam" my way around access. I am no whizz with it by any stretch of the imagination. I have no idea how to open a VBA editing window. I have clicked debug and the compile option is greyed out?

I have a database that everytime I run it on my main pc I get a "Microsoft Visual Basic Runtime Error 91". The same database runs fine on 3 different laptops I have. It stopped doing it for a while after running a Kaspersky Virus scan then started again after a number of days. I have tried...

Sorted it with points: Sum(IIf([Infosheet 001].Placed>0,11-[Infosheet 001].Placed,0)) VERY MANY THANKS PHV. I would have been here till next Xmas.

Hi. I have tried that and it is almost there. If everyone had a position from 1 - 10 it would definately work. The problem comes in for the people that do NOT place i.e placed=0...they all get 11 points using the above formula Is it possible to use a boolean operator such as "AND placed <0"...

Hi and tnx for your reply. I will give that a try. Can I just add I would never have thought of something so complex. If it works or if it does not I consider you a genius :) tnx

Hi, I have a database that I wrote in MS Access some months ago (via lots of questions on forums and various books). I need to add a new query to it that I am having some problems with. I will give you some background info to it. I run a poker league and the database is used to create the...

Hi. I have created a database to track players in our poker games and create a league table from the database. I have done so by creating a main table with the player details in i.e date of birth, address etc. and a subform that stores player results, etc. The league table is created using...