Search results

firstly, the problem is that, in the main order form, if we select an employee number, it does select it but doesnt store it there, it just doesn't store it's value in the database at all, why? I want it to do this. because i want it so that some employee "manages" a particular set of...

it's probably best if u looked at it: ftp://temp:temp@techftpserver.co.uk/mdffc.zip I want it where the employee table has the order number, customer number, perhaps the details of the order in the employee table. that's all. similar to the order form table (using relationships)

sorry about this, I have created a subform in a form. this subform holds the employee number. how can I make a relationship where it can copy some values (like a customer number in the customer subform included in the main form) into the employee's table? (Like I have done previously, with...

hi there. I done this before, with the help of u ppl but now i have forgotten. there is a subform in the table and that updates fine, so when u change the record, the values in the previous record are NOT copied, i just created a new subform and the values DO copy and I don't want that. how...

plz don't say that lol. I tried but can't follow much.

ty, it worked! :)

but I already set the value to a date in the table input mask...

how do I convert it to a date format? but i doubt if it will still work or make any difference....

hi there, need help. if we enter the date < the year 2002 it works but if not then it doesn't: If Me![Delievered].Value = 0 Then Order_Delivery_needed_by.SetFocus If Order_Delivery_needed_by.Text = "" Or Order_Delivery_needed_by.Text = " " Then MsgBox ("Enter the delivery date...

hi there. OK, after this first assessment, what they want now as an implementation, further, where, there are x number of employees. (lets make it 4) and each employee has a number, when they place an order the number is entered by themselves, so they are managing a particular order/customer...

U R THE MAN!! Thank-you soo much :) o, u just made a great start to the day before uni :) *kisses and hugs* lol :) so, how would I tell it to update that text box in the main form automatically if the values change on the subform OR if they have moved from 1 record to another? I tried using...

it still don't work! :( Private Sub Order_Total_Click() Dim x As Currency Dim y As Currency Me![PurchasesSubForm]![T1].SetFocus x = Me![PurchasesSubForm]![T1].Value Me![PurchasesSubForm]![T2].SetFocus y = Me![PurchasesSubForm]![T2].Value Dim calc As Currency calc = x - y...

well, the reason I HAVE to use the .setfocus is because VBA then says that the control needs to be focused first otherwise it will produce an error, ALL THE TIME. I tried taking away the .text and using the .value but that didn't make any difference for some reason, just diplayed £0.00 I did...

it works..sorted. TY!!

thank-you :) this is what I did: put in the command button, follow the wizard for "Form operations > open form" then I told it to open the Daily log record form then I selected to open the form to find specific data then I selected the txtSearch and the Order Date from the other list box...

ftp://temp:temp@techftpserver.co.uk/db197.mdb

it is zipped, it's half a meg lol. that's everything in it :) um, how to convert to access 97 from XP?

that is great explanation, tyvm :) ok, I have done as u said, except that the form has all the details in it, the form is made from that query. in the query, in the order date section, I entered this in the criteria: [Forms]![daily order log]![txtSearch] and I made the unbound txtsearch text...

well that depends on how many products the customer wants :) take a look at the DB: ftp://temp:temp@techftpserver.co.uk/mdffc.zip :) and it's the order form....

the calculation is =[t1]-[t2], this is text21 in a subform. so I'm wanting this value to be copied to a text box in the main form when it changes everytime...