If your IdProject is numeric, you don´t put "'".
Are you sure that Me![Combo1] displayed the current Id??
Try to that code:
Private Sub CmdDelByProj_Click()
Dim SQLstr As String, txtProject As String
txtProject = Me![Combo1] 'The current displayed ID
SQLstr = "DELETE * FROM...
Juan Carlos:
Do you speak spanish?? I don´t speak english very well. If you speak spanish tell me because I wan´t speak with you about your project. I program in Access, Visual Basic and SQL, but I don´t understand how do you want to do this without querys and events in any form.
Veronica.
My...
I don't know what that you need to do, but this is a way to conect to web pages.
You can define a hiperlink fiel in the table and then put this field in the form. The users can clik this hiperlink and conect to this web page. My e-mail is: vzudaire@yahoo.com
I'm sorry, the User field is a boolean field, but I write that in my language. I don't now a better form to do this, but, if you find another one, please tell me.
Greetings, Verónica My e-mail is: vzudaire@yahoo.com
Try with this design
Table Users: Table GroupsUsers: Table Groups:
IdUser IdGroupsUsers |---- IdGroups
UserName IdGroups ---------| GroupName
User (S/N)
Whith the field GroupsUsers.User you know if the field...
Hello, try to change your code with that connection string:
Dim x As ADODB.Connection
Set x = New ADODB.Connection
x.Provider = "microsoft.jet.oledb.3.51;"
x.ConnectionString = "Persist Security Info=False;Data Source=a:\myvbproject\school2.mdb;Jet OLEDB:Database...
Hello,
Open the relationships window, and then right click on the blak line (the relationship line) and select modify realtionship. This action open the properties page of the relationship.
good luck...
Vero.
My e-mail is: vzudaire@yahoo.com
Can you specify what say the error message??
If the error is like that:
Can't create the object.
run MDAC_TYP.EXE file My e-mail is: vzudaire@yahoo.com
You could do this: on the event 'on close' of the form:
codeDB.Execute "DELETE * FROM fd_inspector WHERE delete"
My e-mail is: vzudaire@yahoo.com
If your table "Visit" have any relationship with another table, and you force referential integrity (sorry, but i don`t sure how translate "Integridad referencial"), you must put in the field who is part of the relation, one value who exist in the other table.
For Example...
Hi,
Your ADO Data Control have incorrect data source. Look in the properties page of the ADO data control and change the connection string. When you choose the database field, select the new path for your database.
Sorry, I don´t speak english very well, but I wont try to help you...
Bye...
HI,
Try with this code after the exist code in the DELETE button in the versions subform.
dim sSQL as string
dim rsAux as recordset
sSQL = "SELECT * FROM Table_Versions WHERE IdVersion = " & Me.ControlNameOf_IdVersion
set rsAux = codedb.openrecordset(sSQL)
IF (rsaux.EOF and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.