Search results

Works! Thanks!

Private Sub cboConsulta_GotFocus() Dim strsql As String strsql = "SELECT ID_Verificação,Verificação FROM tblVerificacao WHERE ID_Peça = '" & Parent!TxTId_Peça & "' ORDER BY Verificação;" Me!CboConsulta.RowSource = strsql End Sub Message Box: Data type mismatch in criteria with data field...

You right! Thanks! Now I can finish this today!

Private Sub Form_AfterInsert() Dim strSql$ MsgBox "Nova Peça Criada" srtSQL = "INSERT INTO tblVerificacao (Verificação,ID_Peça) VALUES (""1"",'" & Me!TxtID_Peça & "')" CurrentDb.Execute strSql End Sub Table not found, but this linked table from my backend is correct. What is wrong?

Yeah! It worked! Thanks

ok, I will make a new database and split. If it is ok, I will tell you. Thanks!

3 archives. 1- relations in backend 2- relations in frontend 3- error creating form all portuguese , sorry. what is NA´s?

42 These items are checked in 2 or 3 days. About 14 items per day. Occur at most 3 total checks of the product to get approval of the 42 items We produce over 60 products a day, and only use a form on paper to record the 3 possible checks. I thought of creating the form equal to what is on...

Ok, I will try to show. I work in a factory that manufactured each product goes through a quality control with 42 checked items required. Each item can have 3 status: approved, disapproved or not applicable. In case any of these items are disapproved, there is a second check of all 42...

Yeah, maybe I just need to make only 1 table with this 100 fields. That´s ok, but, why relations is not working properly on my front end db?

Yes, I can open my tables from frontend and backend. For instance: I just make a new db, with 2 tables. Made a relation between them. Split with Access Database Split button. Open relations on front end , and the relation is there. On front end. On backend is too. When I delete my linked...

I think I discovered this in the net: "Rebuilding your file by importing everything into a new database is quite quick. The most time consuming part is laying out your relationship diagram again after every import. To avoid that problem, Stephen Lebans has a free utility to save and restore...

I created a query on my backend and it works, with all three tables. When I try to make the same thing on my front end, I can´t. I will use FK on table 2 and 3, you are right on that.

Yes, I move it all to my notebook to continue working on it. I delete my linked tables (with little arrow) from my front end, the linked it all again. I made same other basic forms, using only 1 table. These 3 tables are related 1 to 1 . Table 1 IdProduct pk more 10 fields Table 2 (related...

I see my tables with little arrows next to it. I split tables by the access database split button.

In my front end db, my tables arent related, but on the back end are all related. I tried to delete my linked tables on the front end, and link again from back end, but didnt work.

I was creating a form by form wizard that has fields from 3 tables that is located on my back end db. When I finished the process, it informs that I don´t have relationship between the tables and then I was dropped in mey front end relationship tab. These tables are all related in my back end...