Search results

You can do this and still do it in the forms 'ontimer' event. In the event put a piece of code that runs the SQL from VBA. within that sub you can then run error checking and events. This should solve your problem. There is lots in this forum about running queries from VBA. HTH

I've had a think about this and because no one else has answered I have decided to give it a go. I can think of a number of possible ways of achieving your request but a lot depends on what is behind your combo boxes. i.e Where/how do they get there information? Are they casscading? Are they...

Hi Sathyab OOH Errr --------- Lotsa numbers--------I don't like numbers, especially first thing in the morning. Unless, that is, they have a £ in front :D First thing; Have your list box display both ClientID & ClientName. Have the form display the record relevant to the criteria in your...

Please do not make multiple posts. This is confusing and exceedingly bad manners. Read the forum FAQ's and use the search facility.

Put something like this as an expresion in your query. Sum(CLng([PBal])*(0.1/100)/365) Then add the result of this to your interest colum in the same query. Next I would run another query on theis first query and within it take the new value generated by this query and add it too PBal to get...

Thanks Pat The function is in a standard module. There is a reason for the reverse IIf statement------I need to capture the second part of an alpha numeric as a second string to carry out certain procedures with it. The SQL goes on to call a second function on the Alpha part of the string. Or...

How about, instead of deleting the item you remove it, temporarily, from its original table using a query. Have that query append a temp table. If you then change the state of the control again have another query put it back.

Please do not multiple post it is most confusing and exceedingly bad manners. Read the forum facts and Use the search facility. I have posted a brief reply to your other post to put you on the right track.

Hi Jak You do not need to limit the number of rows in a table (indeed i'm not even sure if this is poss,) I would do this in code. Read up on IF and Else statements ------ This is what you need. Count the number of entries in a table then If entries in some table is >9 then Call a msg box...

Hard code it as a calculation and include a routine to change the points allocation. If you store the points value as strings then you can do a routine to change the values without ever having to go back into the code. If other people have access to this you can p/word the routine through a...

Yes you could, in theory, do it just in a query but allowing for every possible combo would be a nightmare which is why I sugested using a couple of functions and call them from the SQL. I don't agree with your first statement though. There is no reason why you could only do this with a uniform...

Public Function Pad(strIn As String) As String Pad = Right(String(9, " ") & strIn, 9) End Function Yes it does appear in the list of functions (and yes 'MyFunction' was a substitute name :D ) Later in the SQL I call another function (that is also listed as available). I am assuming...

Ouch OK I've just picked this up and I can see your biggest problem straight away. Normalisation. Just take a look at one table - tblPoints You have every heat and every result listed causing loads of repeated information. Split it up. You only need to store each race once. i.e: tblHeat...

I have a Public Function (call it MyFunction) that I need to call from a query but I keep getting 'Undefined Function in Expresion' :confused: Here is the relevent part of the SQL SELECT tblMember.String_Value, IsNumeric([tblMember]![String_Value]) AS Sort1...

That could be an awful lot of queries. You would have to run a different query for every possible scenario. I have a couple of functions that would work along with some SQL and do it all automatically but I can't figure how to call the function from a query. THe idea goes something like this...

Use the code builder behind the 'on load' event of your form. Use an if/else loop to set the visable = True or false according to criteria I.e Private Sub Hidemydoobry If (some criteria = something) Then (Somethin) Visable = True Else (somethin) Visable = False End If End Sub You could do...

Take a look at the 'Orders' example or the 'Northwind' example both have clear examples of how to do this

Yes :D

All these numbers first thing in the morning--------very confusing :confused: Zip your db and post it lets have a looksee

First do a compact & repair When you say you have deleted the switchboard have you just deleted the form or is the table gone as well? To replace your switchboard the easiest way is: Go to 'file '; 'get external data' on your Access menu and navagate to any other data base you have with a...