Search results

Hi I figured it out i needed to use the update function rather than insert. "UPDATE tbl_booked_out INNER JOIN tbl_barstock" & vbCrLf & _ "ON tbl_booked_out.[Traceability Code] = tbl_barstock.[Traceability Code]" & vbCrLf & _ "SET tbl_booked_out.[Original Length(M)] = [tbl_barstock].[Stock]"

I do apologise, i am pretty poor at explaining things (I normally get on with google and patience trying different things). The picture attached is 3 cropped screen shots the top 1 is a row of information from the first table where the (stock) is each row of information has a unique...

Hi, I am Luke I am from England, I do a lot of work creating spreadsheets for the admin department at my work (Im a CNC Lathe/Mill programmer/setter) but I believe i could improve the systems they are using by implementing databases and replacing the spreadsheets with something more user...

Thanks for your reply, ill save that info for when i may need it in the future. What im trying to do is i have a form set to pop up that i can put a Traceability Code into and other information. Then input that into a table, but i would like to get it to also use the traceability code i type...

Sorry guys, ive figured out what was doing it. Its because i was doing that query and then trying to use strSQL1 as a value for insert into. Would you happen to no of a way i could find the number that would direct me to and insert it to a different table. Thanks for your replies

Hi all, Im new to programming on Access and have hit a brick wall with this, im trying to select a value from a table, but i keep getting the error runtime error '3075': syntax error(missing operator) in query expression. any help fixing my mistakes would be great. strSQL1 =...