Search results

i have a table with every office employee on it and in it i have a field called codes in my sales form i have a dropdown box that selects the people who i have assigned a " 1" to i also have a dropdown box for purchasing of which i have assigned a " 2" to the same as above for finance but i...

i really appreciate your help with this as i am not good at this sort of thing i dont think i have done this correctly i did this on form child68

i have put the yellow lines around this form . this is where text box 12 is looking this is where it links text12 to the stocknumber the strange thing is it works sometimes as it does on other copies of it see below but like i said i am worried it will go wrong

i am confused. yes i know it is a meaningless name and must try and get better at this but have i not used the correct name in the field control? =[Child68]![Form]![Stock Number] thanks steve

i am not sure how to do that if they are both subforms in an empty main form ?

i have created a unbound text box called (text 12) for linking 2 forms via the stock number yet it is showing an error see below screen shot the screen shot below shows the formular yet on another copy of that same database it works. so i am now worried that there is a problem with how i have...

hi i am confused why i have fixed my field yet when i click on that field i see about 10 numbers yet the qty is only 0.010 this one below shows 0.000 in the qtyoutstanding which i should not see because the query say >0 for that feild . again when i click on it it shows

below is the code someone helped me with a while ago but i have now got a problem that i would like to stop this give an error message if the address attached to the line number is not there in the table. i have discovered that people are not entering it and the reports are blank So if i...

Found it. the field name was emailaddress but it was called e-mail address in the propertity field name box thanks for your help

i have found that data source in another old table of which i dont reference anywhere i can see other than the code of which if i change it but i am confused why will this not error and the second one does one is opening the report and one is saving it this one opens it Private Sub...

yes , i did see that 2 email address and i dont know how and why. as i only seem to have it in the code / else where it is emailaddress. but i cannot understand how it shows the e.mail addresss on the first report i did and not on the other 2 as it is the same report. but sending it or...

this is an Acknowledge form. if i select "open ACK" I get the reports below which is correct and you can see the e.mail address in it yet if i select the buttons " email or create ack pdf i get this e.mail error if i select ok the email will show up as show below yet the e.mail address is...

it i send an invoice to a customer ie " crompton greaves " there could be 2 shipping addresses see above and i am asked which one see code below i would like it not to prompt me for the line number if there is only one shipping address for that customer thanks for your help steve...

hi , i use this for the input mask on some of my fields >"PCO"00000;0;? this is for the "works order number" but i have just been asked if it could be modified so i could also put the word "stock" into that field sometimes as we need to purchase stock ie maybe cleaning material etc can...

i have about 36 forms of which there are 6 processes within the company , sales , purchasing , production etc , is it possible that when say sales log into their area only their 6 forms would show in the navigation form ? thanks steve

i have done this hopefully to overcome the problem if i tick the line complete tick box to say the information is recorded and available to see until the parts for that line has been actually allocated then when i tick the allocated tick box it will not be seen again i added the "line...

at this time the batch number is advising purchasing/stores what allocation qty has been allocated to the batch number/part assembly number therefore when we checked the parts for PCO 00011 the query would say be did not need to order that part of 6 because we had 10 in stock then we got...

the top fo0rm shows the items that need purchasing the second form shows me the situation with stock etc and what allocation but not allocated . when the first line for that part is allocated and i tick the box it will disapear from the form. as you can see there are 2 transactions for that...

thanks for your help i have solved it the query had the field batchno.value in it , when i removed that it was ok

i had not noticed that and yes it has done the same where i have 2 batch numbers to the same record. is it possible to only get the one record? SELECT StockLevels.StockID, StockLevels.StockNo, StockLevels.OnOrderQty, StockLevels.Allocation, StockLevels.allocated, StockLevels.StockQTY...