Search results

i did not finde the SQL view i am using maccess 2017 they are i double checked i even created different id fields in the two tables so that we dont copy data in a autonumber field that has the primary key

INSERT INTO tblMastersheetPartsList1 SELECT * FROM tblMastersheetPartsList WHERE MaterialNumber = '00001-0258' INSERT INTO tblMastersheetPartsList1 SELECT * FROM tblMastersheetPartsList WHERE MaterialNumber = '9098' INSERT INTO tblMastersheetPartsList1 SELECT * FROM tblMastersheetPartsList WHERE...

this i what i get as an output for the debug.prin. the printed out stuff is from another field of my form do i have to place the DEbug.Print some where else? also what is the SQL code window?

i have not you are right that was not the way i initially programmed it and already deleted it out of the code again but it still does not work

by the way thanks for the fast reply

Private Sub Command220_Click() Dim tablename As String Dim newtablename As String tablename = "tblMastersheetPartsList" newtablename = "tblMastersheetPartsList1" Dim MaterialNumber As String Dim Station As String MaterialNumber = Me.MaterialNumber.value Station = Me.Station.value...

Hi guys i am loosing my mind here and really need some help i dont understand what is going on so here is the situation i have a table that contains materialnumbers now i have created a form that will add a new material to the table local materialnumber table and also updates the online...

Hey Georg, thanks for your quick reply. I when i suddenly lose internet connection or rather when i turn it off i still cannot keep working with my database. and get the error message cannot connect to linked tables. maybe i understood the article wrong but isnt access supposed to enter offline...

Welcome, thank you for your answers so far. Here is a more detailed description of my project, maybe I did not focus enough on it. We have several machine locations on our shop floor (for example, friction welders, hot crimp stations, etc.). Currently, these stations use a paper sheet to track...

Good morning everyone. I am fairly new to working with microsoft access and only used it during my internship so far. my task is to develop a tool that will help to electronically collect data from some of our operating machines. so basically what is happening is this. in the future the operator...

have you tried to use an SQL statement instead of using the Dlookup Function? another