Search results

um......how? I know what u mean now, after re reading it, but there is a problem, not all the stuff is written to a table! and some stuff have been written to different tables

Hi there. I have made a custom report (using the design view) I have set all the text boxes and labels. Text boxes are in the details section and have been linked to a form, which includes a subform and some text boxes there... it's a bit complicated but here goes: This form, has a subform...

or maybe u could have gone to the menu and selected Insert > Page x of y or something? Maybe I am getting my wires crossed?

IF I am writing a piece of code in a subform to go and do a button click event, but that button is in the Parent (MAIN) form, what would the command be in order to tell it to go click it? it is usually commandxxx_click but i can't do that, since it's in a subform and I can't do: Forms![Order...

right ok: I made a command button which does the value writting - works!!! WOOHOO!!! but, how do I tell VBA/ACCESS that, once the values of the text box in the subform have been calculated, hit the button in the main order form?

the text box...it's using SQL Statement...so the text box displays: =[t1]-[t2]

the reason it's showing 0 all the time is because, it takes a few seconds to do the calculation....so, how can I tell it to wait until the calculation is done, then go ahead and take the values?

i need to set focus to copy the value of the text box in memory, other wise an error will occur

still says 0 :(

Thanks :) what i am trying to do is, there is a main form and a sub form. I want to copy a subforms textbox value into a text box on the MAIN form. I want this to happen on every record, perhaps using the on current event? I tried this: Dim x As String Dim y As String Dim finally As...

Hi there. VBA, how would u identify the forms? I mean, for current form and to go to a particular text box, it would be Me![text field], but would happens if u want to copy a certain value from a certain text box to the parent form to a certain text box there?

I tried it that way like i said but didn't work. I even tried to create a whole new database file (mdb) and tried to copy the some of the things from the original file but couldn't make it work, even after looking at the SQL statements and stuff. so, basically i'm heading for a fail....great...

sure, thanks. what do u mean by open arguments? :-s do u mean make a text box and link it to the orderID?

I have just done the query, it works very well except I need those 2 values in it

it's probably better if u saw it urself, I am sooo confused, i don't even understand the database! ftp://temp:temp@techftpserver.co.uk/mdffc.zip What I want it to do now, is to create some sort of relation where the Quantity Ordered and the unitprice values, are taken from the productpurchased...

I have tried to create a Relationship between the Tables, that didn't work. I tried taking the value of the current Subtotal/quantity required and copying it to a text box, so this could be written to the table - no luck there. I dunno what to do, I couldn't sleep

I was thinking of making a query for the unpaid table but this whole thing is driving me mad up the wall, and i am not joking, i am about to smash my PC! URGH I have been following, for so many hours now, I AM THICK, on the productpurchase subform and SQL statements/query. What I want to know...

that's cool, thank-you very much tho, i appreciate it...

ty :) It's actually, genrous of BJackson to make it work, great guy :) IT works..but whatever u said, it has been written in my own personal notes too :) i just went out, bought 2 books, 1 of them being the dummies one...hope it helps...off for reading tyvm again!

there is REALLY one thing I am stuck on, and I hope you don't mind answering this. In the order form > design view, there is another text box next to the customer number combo box. This basically copies whatever value is in the combo box. I tried doing a similar thing but with the product...