Search results

Look at this thread - think it does what you are after http://www.access-programmers.co.uk/forums/showthread.php?t=74459

silly me - got it

Looks great How do I see the code behind please? "Shift Bypass Key" ?

Not sure if you are trying to overcomplicate the data input, from your description. Seeing the database would help. Have you considered using tabs, so they start at the left tab sub form, and move to the next one. Then all you need to do is requery the sessions subform when the contracts info...

Without seeing your database and understanding what you are doing is a little difficult, but I'll give it a go. Assuming you have a form with tabs and sub forms in each tab. (we'll call the parent Form frmClients, for reference below) When you open a Pop Up form and enter data, you need to...

Thanks for the example - helped me. I was having problems trying to get a report to total and order. Basically I had a sports event where competitors entered events and so they would have up to 5 events they had entered and wtotalling there score in the report was easy, just a text box with a...

Glad it was of help - I often sit there wondering why I can't do something for the same reasons.

I am having a little difficulty under standing what you are trying to do. If you want to update one box with the contents of another then why not use a:me.textbox = me.otherfield What are the update queries doing?

Ah well that being the case, the best way to do that is create a close button on the form with this code: Private Sub OKfrmAddManagersPopUp_Click() On Error GoTo Err_OKfrmAddManagersPopUp_Click 'make sure current edits in the current form are saved to the table Me.Refresh 'refer...

Rather than record the GivenName, as this is a know concatenation, all you have to do is create a field in the database source sql Givenname: [surname] & " " & [Firstname] Or if you want to present the data with firstname first, then do it the otherway round.

Not sure how automatic you want this to be - the code indesisiv has hyperlinked below is very good. In my case, the combo dropdown only gave a name, of course you want them to add address and phone number etc or other relevant data, then you want them to add more than just the drop down...

You need to do refresh the combo for stops when you leave/change the routes combo. You need to put the filter on the stops combo

As I know nothing, I'll never fall in to the trap of figuring it out first. Phil

I am fairly new to Access and I know how hard it is to get in to it. Understanding concepts is not always easy and once you understand them it all seems so obvious. The first thing to think about is that the same data should never be repeated. If it is going to be written twice then it should...

I won't claim to be very good at Access but would like to give you my opinion as to how I would go about this problem. In the Stops Combo Box, you need to go to Properties, Data, Row Source and then click on the dots to the right. This will open the sql select criteria. You can then set a...

Not sure how you want to do this in terms of look, however I have used the not in the list event for the combo box to display an error message that says the item is not in the list and says if you would like to add, double click on the field. Then an event for double click opens a form which...

Thanks very much - tried the cose and it works fine. Also may I thank you for the explanation that went with your example as that helped me understand what you were doing. Phil

Hi - My first time here, and I am fairly new to Access, but getting on OK. So as ever, be kind. I have spent several hours reading this forum and learnt a few things, and been completely confused by other things. My Job is IT but Software, Networks etc configuration rather than programming. I...