Search results

MORE PROBLEMS +++++++++++++++ OK, I've set the cycle and got rid of all nav buttons, I was trying to implement the VB code to disable the mouse but i got a bit confused with it. Anyway I've know also noticed that the PageUP and PageDown buttons will also have the same effect, God damn it! Is...

I'm haveing problems with a form. I wont the user to go to a new record and only be allowed to enter details for this new record. However the mouse wheel is allowing me to move to the next record as are the arrow keys. i need additions enabled so a new record is setup, I've tried setting the...

send an escape? do you have an example of how i would go about this?

Thanks, I eventualy found this and its just what i wanted. Format(autonumber,"00000")

I'm using an expression to show some text details and an autonumber with the "&". The problem is i want some leading zeros in the autonumber to ensure overall format stays the same when the number grows in digits. I've tried changing the format for the autonumber but this doesn't change the...

I'm using a form for users to enter records directly into a table. The user may decide to exit the form and not save the records by pressing the cancel button, however my current model is saving records as they are entered. I want to know how to stop any records being saved until the user hits...

you can type 'monday' in the query critera under the column in which monday would appear or 'is like "*monday*" if the word monday appears as part of a sentence. or is like "*[Please enter day for query]*" to have the user enter a specific day each time the query is run. or you could filter...

Really i'm looking for something i can pop in a column in a query to return the number. There must be some kind of formula to tell me the position of the second "." or where the ".#######." appears.

have you tried saving the query at the point when everthing is grand and using another query to sum the time values, or just summing the opening and closing time and then using your formula when already summed

I need a formula to return a 7 diget number from with a text field, the data comes in the format below. "License Search.Could be any value in here or blank.6680997.PUNTO 60 ELX 5 DR.Could be any value in here or blank." This is quite easy to do in excel because the value is the only 7 digit...