Search results

Thank you for the feedback, so looking at it from your order suggestion: Competitors play in tournaments tournaments have rounds rounds played on a course course have holes holes have scores......not sure how this would be tied in to the competitor without a circle/loop?

I have just created my first set of tables (normally import or connect to a DB) - I believe I have setup correctly with normalisation etc but not sure. I have created a DB for a bunch of us that play golf once a year, and play at different places, different people can attend, handicaps change...

I have posted this question already on Excelforum, but not had a response yet, so wondered if anyone here could help? If so could you please post your answer on Excelform (link below) you can post here if your not a memeber and I will copy the response over...

Hi, Sorry, I have been on then off then on then off line for a while (new pc - it died after 2 days and then another) , and have just come back to say I have been provided the answer......After I posted this initial post I was still looking for the solution when I came across an Excel forum...

I would like to count the number of consecutive values >=2 in a row. Eg:- 1 2 3 2 3 2 2 2 2 1 1 1 3 3 2 2 1 1 The returned value would be 8, because the 2nd to the 9th figure are all greater or equal to 2 OR 1 2 3 1 2 1 3 2 1 3 2 3 4 3 1 2 3 1 The returned...

Thank you!! That is a great help, in my query I am always asked to enter a value for vbNullString, so I am not really sure why this is there....checking for nulls from what I have read. I am looking up what the other functions are doing - thanks!

Sorry, can you please explain a bit more, I do not understand how I can use IsNumeric to split 13a into 13 & a If I use t1: IsNumeric([HOUSE_NO]) I just get a True or False (-1 & 0) I want to split the numbers and the letters up 1a 1b 1c 2a 2b Would become 2 columns:- 1 1 1 2 2 and a b c...

I want to split data in one field into 2, so 12a would be 12 & a or 1a would be 1 & a, I have managed this where the format is split by / but not sure how to split based on letters and numbers? How can I separate this data? 12a 14b 1e 5f etc I have created a query that splits data into 2...

Cheers, that makes sense!!

Very bad....but I never have put in error handling, but just read up on it and it make sense to have!! However, after thinking it would be easy to add this fails "Label not defined" and highlights the second line.....any ideas? Private Sub RunAllQueries___Click() On Error GoTo...

I went with this solution, as it shows an hour glass and also provides a description of what is happening.... Private Sub RunAllQueries___Click() DoCmd.Hourglass True Dim myQueries() As String, i As Integer, myDb As Database Set myDb = CurrentDb ReDim myQueries(3)...

All sorted Thanks!!

So some reason it hangs after I have run the function - I see the text flash up on the status bar, and then goes back to "Form View" but the whole of Access is frozen!! I can work on everything else on my pc, but cannot do a thing with Access.

I tried this too, but got an error:- "An expression you entered is the wrong data type for one of the arguments. When I click debug, it highlights this line:- DoCmd.Echo "Running query " & i & " please wait...." I have tired on a few functions, here is an example of one of my functions...

That is great!!, thanks again. Will look into the first one, the second option - status bar already showing, but nothing appears on it when running the function (the progress bar does appear when I run the queries one at a time) The Third option, will start using straight away, while I am...

There is just one thing.... with so many queries running in the background, so of the users are complaining that they do not know when that function has finished or if it is still running (unless they click on the form and everything freezes or an egg timer pops up). Is there any way of getting...

Thanks a lot this worked a treat!! I have never used Macro's so thought it was better to set up a form with comand buttons linked to these functions. Thanks again!!

I would like to be able to run one query and when that has finished running another query automatically, and when that has finished running another query automatically starts........ I have about 10 queries that I run in order at the moment:- 01 – Append a table from another database2 to...

Thank you very much!!! I had to change a couple of things, but it appears to have worked a treat!!! The duplicate fields where the addr1, with numerous CustID’s– so made addr1 the Primary Key. First attempt I received all the lowest CustID, so change my append query to Sort Descending for...

Thank you for the quick reply!! I am not sure where or how I enter the DISTINCT part into the query SELECT * INTO test FROM [tblCust] WHERE ((([tblCust].[Duplicates])="y"));