Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. veronica

    criteria: date(11/09/2000) < textdate(20001110) (TRUE)

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

    Problem Code Here: How To Do A Multiple Deletion From A Form

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

    A Simulated Log of Transactions

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

    Getting Started With Web Access

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

    2 Seperate Table columns, to one other table's single column?

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

    2 Seperate Table columns, to one other table's single column?

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

    cant open my database !!

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

    Key violation error

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

    Problems with ado

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

    deleting a table record from a form

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

    Key violation error

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

    SQl & Automatic Emailing

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

    Data control error message

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

    deleting record on form from button on subform

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

    HP 720c DeskJet Won't Install...

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

Part and Inventory Search

Back
Top