Search results

Hi all, Name.......Date.......Hours Fred.......01/02/10......10 Fred.......10/02/10......15 Fred.......20/02/10......20 Basically, I require a method to lookup (bit like excel's vlookup) a date within a range and return the hours. For example: - a date of 05/02/10 would return 10 - a date of...

Sorry for not replying sooner. I tried your code and it worked to a point, but couldn't get it to work 100%. However, I saw one small line of code which did the trick:- Cancel = True. I revised the BeforeUpdate event to this and the text boxes now work accordingly:- If Me.CalculatedField...

Thanks for looking into this for me. Many thanks, p.

Btw, I forgot to say "thanks for replying" so thank you. I need six other controls to work the same way and they are all involved in the Sum-off. Thanks again, P.

I've been trying something like this:- If Me.CalculatedField < 0 Then Forms![FRM_ENTRY]![subfrm_Entry]![CurrentField].Undo ...or ... Me.CurrentField.Setfocus Me.CurrentField.Undo End If

Hi all, Form has several fields where numeric data is input. A separate calculated field continually adds these figures together. If the calculated field has a value of less than 0, I want a message to appear in the active field stating this and then undo the entry in that field. I've...

Thanks to each and every one of you who replied to my post. I've tried all methods and they work really well. Much obliged, Paul.

Hi there, I currently have the following code on the keypress event of a textbox:- Select Case KeyAscii Case 48 To 57 'numbers 0 to 9 Case 8 'backspace Case 127 'delete Case 46 'decimal point Case Else KeyAscii = 0 'do not allow any other key press End Select I want to...

Yep, I gotcha. Thanks again for your solution. Paul.

Thanks Trevor. I think that has resolved my issue. Just one small question. Between the word "Like" and "[Forms]![......" you have not placed a "*". Is this just a typo, or have you purposely ommitted it? Many thanks once again, Paul.

Hi all, I've been on this all day and what I thought would be so easy to do, is actually turning into a nightmare! Simple scenario: One form has a combination of eight text fields and combos. I want to be able to query one field or a combination of fields. In the query design I have...

As a follow up to this, I executed a make-table query and transferred the 2.4 million records to an Access table. The problematic field was then indexed and the search completed in 1.5 seconds as opposed to over a minute. I now have to persuade IT to index the field from the main source in the...

1) Was aware of that, but I presume the a stored query returns records quicker...so I've been told! 2) Well, "HOC" relates to our offices only so would reduce the data initially. I thought (maybe wrongly) by reducing the records in the first parse might speed things up :o Don't really need to...

No need to apologize. You've been a great help for which I am thankful for. I'm not at work at present, but my set up at present is thus. 1) a query (not sql as yet) which pulls in 5 of the 50+ columns from the ODBC backend. 2) colA has a criteria: ="HOC" (this executes the 2.4 mill records...

Sorry, but when you said this in a previous post I thought you was implying the Access BE, rather than the server as the BE. Anyway, spoke to IT and they said an index could be created to that column but it's not as simple as just changing a flag. As I am not familiar with sql, I'll take there...

Hi Banana, I get what you're saying and yes there is no index set for the column I require. The ODBC link is in the front end, but if I try and create an index I get an error message saying that I can only create indexes from the source data i.e. directly from the tables on the sql server, I...

Okay, so I've read the link (some of it over my head at the moment), but need some advice. I've got a continuous form for which it's record source is linked to a query (based on the ODBC link). When querying the 2.4 mill records normally, it produces the data in under a second. As soon as I...

Thanks for the link Banana. Will read with interest. Rgds, P.

Hi Bob and thanks for the reply. Okay, so the ODBC link goes in the FE. So if I have 15 FE's I could potentially have 15 simultaneous ODBC connections. I queried 2.4 million records in just one FE and it took a fraction of a second to run. Would 15 of these queries, run at the same time...

Hi there, I've started to delve into the world of ODBC and I have hit my first problem. I have a BE which stores two ODBC links to our SQL server, but I want to query these in the front end. Linking tables option does not show the ODBC connections. Could someone give me a little nudge in the...