Search results

Resolved. Just needed a cup of coffee to get the cob webs out of my brain :D

solved - Locking text boxes Hi guys, I have a form that is opened when a user presses a button. Once the new form is opened a unique ID is passed across a put into a text box (which is invisible). The user then inputs some data and hits the enter button to assign the data to the person...

Not sure if I follow exactly what you are after... Can you not use the format function? I had a issue in that I needed to get the day at the end of the week when only having information for a day during that week :-) I used the following bit of code in my case... it might be useful to you...

Thanks Rich, Looks like that should give me something to go on :)

Hi guys, Another one for you whists I'm learning the art of access :-) I have a report thats doing a grouping by clientID, with the detail for each client showing hours worked and a total amount for that time period. In the clientID footer I have a line that just prints on the page and...

Ah ha!!! I had started to play with that event but didnt quite get it to work. Thank you very much for helping me out :-)

Thanks for the hint... However I have found that the form_Error event is the first thing that is called, thereby I'm not getting to my other code. I'm can trap error 2113 here when I do my save and present a msg to the user. One issue with this though... If I hit my cancel button and I have...

A stupid question here... I have a form that has a single bound text box that is set to currency. The table is also set as currency with decimal places set at 2. I have my own save button Now I want to catch if the user types in text instead of numers and display a suitable error message...

I found a hack to do this... I defined a query for the sub form rather than use a table as the source. In the query I used desending to sort on the date so that my most recent record becomes the first record in the subform. I would still like to know how to navigate around a subform so if...

Hi guys, I has a subform in datasheet view. Now when this is loaded I always want to be at the last record in the subform. I've searched through the forum and am completely unsure of how to do this... Any hints or tips appreciated :-) Cheers

As far as I know you will have to use a 'big' if statment to see if the value of each check box is true. If all are tru ethen update the caption of your text field (assuming you are using a text field)

Ah... I was trying to use it in the default value in in the client table! Thanks, appreciate your patients.

Ok so follow up question then.. Where should I use the dmin()function? If I try and put that in the default value box I get told it has the wrong number of arguments. I cant find this function in the expression builder either?

Thanks you sooooo much..... :D Been driving me mad and I never noticed that. Appreciate your comment about the mr/mrs table. I am just learning and coded this in. Of course defning a list of value for the combo would be better as they can never change :-)

But there is no default value set at the table level. I dont know if it matters but the combo box that works is set as text at the table level, whilst the combo box that doesnt is set as currency in the table...

Hi guys, I'm obviously doing something stupid in my form :-) If you open the form in the attached sample you will see that I have 2 combo boxes. One of them has a default value showing and the other doesnt, I want to get the second combo to automatically show the value in the list but just cant...

I could do the me.undo in the before_update but I need to know somehow that the user had tried to close the form via the X (dont want to cancel an actual record add) The close event is only called *after* the before_update event so I have no way of setting a flag that could be used in the...

OK seperate buttons its gonna have to be then... Ta

Obviously doing something stupid here :-) I use a form for data entry. When I hit the next arrow in the navigation button section (the default navigation buttons supplied by access), by data is saved into the relevant table. When the I press the X on the form my data is also saved. However I'm...

Hi Smart, Ok nearly there I think :-) One further complication. If the user clicks the X and closes the form, the beforeUpdate event is called. If the user hits the next button in the navigation section (to enter data) then the beforeEvent button is again called. How can I distinguish if...