Search results

well i have 2 databases 1 called action requests that has the 4 companies in it 2 the other database is used for sales , purchasing, manufacturing etc at this time on the second database we have products which have a bill of materials attached to them which if that product is sold it...

hi , i have a table that stores all the records for 4 companies. it is possible to link that table to another access database but only the information from one of the companies not all 4 thanks steve

this is the dropdown box that allows me to query any of these items for example if i select returned i get the following . can i get it without using another query and button showing me all the items in the table except for status "completed"

i have a combo box that i use to select the criteria ( say 10 possibilities ) that are selected from my status field in my query for my report , is it possible to run the same query when it would just list all the item except for the ones where the status is "completed" thanks steve

I have a excel spreadsheet that had about 8 sheets within it , i know you can link excel to access and then change the data in excel which will update the data in access. is it possible to have the same thing but in reverse . ie update the data in access and it changes only sheet "one" in...

i have 4 tables with a folderpath in them. this takes reports to the respective places on the server table name folderpath pdffolder \\192.168.4.16\contdocs\sales\orders\current orders pdffolderpd...

this is what i use in my update query which i thought would be ok . the field in the table defaults the onorderqty defaults to 0 . but today looking though the records i noticed that we have 5 parts on order yet the on order qty was blank , is seems someone has deleted the 0 and left it...

Private Sub Command51_Click() On Error GoTo Err_Handler Const FOLDER_EXISTS = 75 Const MESSAGE_TEXT1 = "No current product ." Const MESSAGE_TEXT2 = "No folder set for storing PDF files." Dim strFullPath As String Dim varfolder As Variant Dim ECN As String The...

HI , I have been away for a couple of days so did not get time to see what was written . there seems to be many things i am not sure about now like this. it seems i think that everyone says this is what it should look like yet i make use i get the description showing in the material...

ok , i will look at that and see if i can do it , i have managed to get the code working now as well

Private Sub cmdUpdate_Click() 'DoCmd.RunCommand acCmdUpdateRecord 'DoCmd.OpenQuery "Material Details 91 days not purchased" Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("StockList", dbOpenDynaset) With Me.RecordsetClone If Not (.BOF And .EOF)...

yes it just a copy of a piece of the database as the database does sales orders, engineering , purchasing , production , stores, quality , invoicing albeit just a novice version but it works so know i am trying to add the engineering change note information into it as well as an audit log ...

Private Sub Form_BeforeUpdate(Cancel As Integer) docmd.RunSQL "INSERT INTO stocklistchanges select * FROM stocklist " & _ "WHERE MaterialID=" & MaterialID End Sub i tried this yesterday and it reports the changes i have made . but the problem with this is it reports all the fields which...

The original question was about how to change "all" the places where material shows when it is changed in the primary table.

with the material description we manually do a PDF file on the product and the material so i can refer to that as say rev A after changing i make it revB for consumable parts i dont have a record after changing it

The stock list material costs do change and yes it will always look at the latest cost . So If i add all the material costs for a product and say it is 200£ and I sell at 500€ and 2 months later the cost for that same product has gone up to 300£ then I dont have the old total material cost...

if you look at post 1 you will see there are 129 different products each product has a list of items to manufacture that product , the one on the screen post 1 shows 21 items lets say product 2 has 30 items selected from the stocklist and product 3 has 50 items from the stocklist and the...

When I first started to create the database I never used the ID fields I used to link material to material but when I talk to the forum I was told never to do that and link materialId to material and I really struggled as the results I was getting was the materialId and not the description so...

not sure if i am on the correct track but i have managed to get to this at this time albeit the latest text not the one before i changed it SELECT Stocklist.MaterialID, Stocklist.Material, [Product Detail].ProductID, Products.ProductNo FROM Stocklist INNER JOIN (Products INNER JOIN [Product...

when i change the material description i would just like it to create a pdf file with the old description and the new description and the associated product numbers and send it to a folder on the server