Search results for query: *

Try with that: Dim sDate1 as String date1 = #11/09/2000# sdate1 = year(date1) & day(date1) & month(date1) My e-mail is: vzudaire@yahoo.com

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...

Use: xp_sendmail @recipients = "emailadress@server.com", @message = "Your message", @subject = "Your subject" @copy_recipients = "emailadress@server.com", @with = 250 My e-mail is: vzudaire@yahoo.com

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...

What are you getting for eroor messages? Possible corrupt driver? not a win2k problem?