Search results

the new folder is the first to charectors on the product number . so if i was saving product AC4619M1 \\192.168.2.11\contdocs\Engineering\Document libraries\approved documents-controlled\product library-controlled\ AC also I do not know how to incorprate the append into the code thanks...

when i create a bill on materials the file goes into the first location i have listed which is my folder path \\192.168.2.11\contdocs\Engineering\material list in pdf now they want to move it to another location listed below \\192.168.2.11\contdocs\Engineering\Document libraries\approved...

Yes tables are in the BE i did not know you had limits for the FE thats one reason i asked the question and does it slow the database down "Do you have common functions/subs that each segment uses?" lets say 30 % of each area use the forms,/ tables etc from other areas steve

my database covers 7 areas of manufacture, sales, engineering , purchasing, stores, quality , finance each person can log onto their own area with a password the backend is split away from the FE . there are about 60 tables, 100 forms, 120 quires , 20 reports of which i am trying to tide...

yes , i have all these in action and i have just replaced the FE on everyones computer

yesterday someone tried to open the form called stocklist ( button located along the red line ) and this error came up . the form has been open hundreds of times without a problem . after rebooting his computer it was ok again . i am trying to understand why this could happen . any ideas...

i was only asked to try and bypass consumables yersterday so just trying to develope it now "How do you identify a Consumable from nonConsumable? " enginnering will put all items into the stocklist table that are product related purchasing will out all items that are not product related...

Private Sub Form_Current() Me.stock_changed.Enabled = False Me.stockchanedcons.Enabled = False Select Case Me.Passed Case "yes", "short", "part rejected" Me.stock_changed.Enabled = True End Select Me.AllowEdits = (Nz(Me.[stock_changed], False) = False) If Me.consumable = True Then...

the GRN does not matter for this part i am trying to do , its just a matter of it going throu inspection or not . so all consumables dont need to go throu the inspector all others do so depending on which way it goes i want the other tick boxes locked then when ticked then that lock also...

i am struggling with the code for this and you will laugh :)at what i have been playing with when you see it but at least i am trying the code i started with is in post 1 but what i would like to do is . both stockchangecons and stockchange are locked if consumable is true unlock...

i am struggling to think how to do this the screen below shows a contract part arriving at the goods inwards then the stores man fills in the date the parts arrive , the qty received and the GRN number the inspector then has to complete the date parts inspected and if passed or not...

i would like to be able to stop people entering certain words within a sentence in the text field MaterialPUR. and warning them if they try to. the words for example are. drw drg drawing w room see screenshot below as an example thanks steve

thank you this has got it working ok now the stock qty gets change when the purchase order gets booked in this is done by a append query but to book out the parts individually to the shop floor i use that form to select the part which automactically loads the stock quantity and...

Below is a form that changes the stock qty and allocation and stock balance in the yellow feild which is called update i put the qty i am taking out of the stores in this case 10 so when i have pressed the button " update allocation " this second form below shows that this has happened ...

I have removed the macro and did you you advised and changed the append query to include the datemodified and all seems to be ok thank you will test again later today with real data not my test data

since checking what pat asked i have checked something and it is not quite doing what i would like it to do when i type the qty into the stockqty field the datemodified works ok . but with my latest modification to the form it will not work in the form below you can see a stock qty of 1260 if...

this is how i have done it .is that correct?

thank you , now working steve

this marco i found on an old database that records the date and time when the stockqty gets changed via the after update event so i thought i could do the same think on a new database but i cannot find the "setvalue" from the dropdown box can you please advise what i am doing wrong thanks...

"Access doesn't have the ability to link to a query so you can handle this slightly differently. Link to the table but rename the table after you link it. This only changes the name in the linking database. It doesn't affect the name of the table in the BE. Then create a query that selects only...