Search results

Thanks Bob, I started with the forms On Current like JBB mentioned and then did the click of the listbox.. Works great.. :)

Thanks John, I was nearly there when I got your answer which works great, while trying I managed to come close to your solution. Only the fields wouldn't switch, as per your answer I put the code in the On Click event of the Check Box and then everything worked fine. Then I transferred code to...

Hi Guys, Happy New Year to all, and a fresh question to go with the best wishes. On frmPayment I manage the purchase and sale of scrap, I choose records from a listbox [List210], most transactions are buying, sometimes there is a sale. A operator has to enter / override the [buyprice] or...

Your great my friend, sorry for the late response but haven't been at computer for a while, after my question I got more operators, so went for a listbox as this is a touchscreen only application.. Thanks for your offer, sorted for now.. Wishing you a Happy and Prosperous New Year..

Thanks Reddwarf, here is the app, wonder what it would look like with 4 lists/ combo boxes, the code is probably a mess but I tried to keep it as tidy as I can for a beginner.. Anyway, here is my attempt...

Thanks for thinking with me Khalid, the form is used all day by different people and they don't want to log-on/off every time a new docket is created by another operator, there would be a number of operators and a press on the cmdButton would prevent that.. They would have to sign a printed...

Hi Guys, I have a weighbridge application that is mostly operated from one form, several operators make dockets on this screen, now I want them to press a cmdButton to register their name in the record, this is the way I do it now; Private Sub cmdWBO_Monika_Click() Me.WBOperator = "Monika...

Get the drift, did the change and didn't work, but this looks much better to me then the query, will play with this for a while and let them work with a button for the next few days to let me do so.. Great LagBolt.. Private Sub List203_AfterUpdate() ' Gets pricing data from the Materials...

Today's prices come from the Materials table, and I see where you come from, reports are going to be based on history and historic prices that need to be stored in the Docket table not the Material table, sorry if I did not make that clear in previous posts.... Thanks for thinking with me...

Sorry for misunderstanding, when a salesrep is selected, the fields Docket!Buyprice and Docket!SalePrice need to be updated with the fields from the material table, then the record should be saved and added to the Name Docketnumber listbox.. I have been playing and found this to work; Private...

The people will work on the form Touchscreen, they will create a new docket, input a name, pick a material, a haulier. Then click on Docket to generate a docket_number. A loaded truck will drive on a weighbridge and the weight will be added by means of DDE, The sales person is clicked and the...

This should do it for you.. it's in Access 2007 give a shout if you have other version

When you open the table in Design view, are these fields numeral??

I do appreciate your answer, however with my knowledge I had no other choice then to do it like this and make it transparent. The situation is that I have one main form handling the intake of Waste, On this form people choose a material from a database that contains price information. Buying an...

Thank you very much, I will have a look at your website, I am sure there is lots to learn for me and believe me I really need it.. Just writing my first app and have another problem as described to Lagbolt, Any help is greatly appreciated in getting the touchscreen form up to scratch.. With...

Thanks Lagbolt, that is a clear explanation, sure goes in my library.. I have one more favour to ask that I have been struggling with, I had help, but still wasn't able to make it workable. I have a SQL update query that I need to run automatically every time before the last record is saved. I...

Hi Guys, Trying to requery my form and come back on the last created record, however I get a data type mismatch in criteria, run-time error 3464 Pretty new to this so I hope someone might help.. The code;

Still no luck, when I do that I am thrown to the first record, and no update..:confused:

First the number is created by an On Click event, then I would like to fire the query in the After Update, of course there is a very big chance of a beginner mistake here. The code; [CODE]Private Sub txtDocket_Number_Click() Me.Docket_Number = Nz(DMax("Val([Docket_Number])", "Docket"), 0) + 1...

It wasn't a multi select listbox, however I think this is not the error, I put the code in the After Update event of txtDocket_Number so there would be no listerrors. Still no joy and now it doesn't even give a error. The field buyprice and sales only update when running query manually, any...