Recent content by vinzz

  1. V

    Dynamic Ribbon & Runtime Errors

    First of all, I know that the last reply in this thread was a while ago. Nevertheless I think my reply has got a small contribution for this thread, here it is: thanks for the code to retrieve the HandleID! I placed the HandleID in the persistent access properties and made the ribbon...
  2. V

    DLOOKUP error 2471

    So you're trying to get some information from the table "users" and you only get the value from the column "UserID" wich should be numeric (long). You filter this with the colum Username (wich is a string) and check it with a combobox 'cboUsername' on your form. What is the referenced...
  3. V

    How to call private sub proc XXXX

    try this: i needed this to make a combobx scroll with the form_mousewheel function Private Sub Form_MouseWheel(ByVal Page As Boolean, ByVal count As Long) 'Some personal code... If Me.ActiveControl.OnChange = "[Event Procedure]" Then txt = Me.ActiveControl.EventProcPrefix &...
  4. V

    how to exclude data from other table?

    it did the trick, thanks ByteMyzer
  5. V

    how to exclude data from other table?

    yes i have, but it didn't help me out.
  6. V

    how to exclude data from other table?

    hello, i'm having a problem with setting up a query that only needs to show data from one table that's not in the other one. I'll explain a little: I have 2 tables (i've got more but this are the ones i need for this query) called tblUsr and tblGameUsr In tblUsr i have 2 column called 'Id'...
  7. V

    Code to refresh form details after adding data in different form?

    You need the requery, do it like this under the command "After update" of "form_Close" forms!frmMovieDetails.form.frmMovieDetailsSubform.form.cboAddStarToMovie.requery Or just reload the whole (sub)form forms!frmMovieDetails.form.frmMovieDetailsSubform.requery
  8. V

    Tired of using double protection

    nice explanation! My second suggestion won't work indeed, i was a bit too fast.
  9. V

    Tired of using double protection

    just use this: if me.avalue <> "" then .... or if not me.avalue <> "" then ... this does the same trick, take the one you need :P
  10. V

    Insert Into error with ' in strings.

    Thanks, i'll check it out
  11. V

    Insert Into error with ' in strings.

    Hello, I have a problem when i want to insert a string into a table using SQL Insert Into statement example: set db = currentdb() set rs = db.openrecordset(AnSQLstr, dbopensnapshot,dbfailonerror) rs .... .... 'examplefield: RS!afield has this string = "an example that has an ' inside" when i...
  12. V

    Notify Tech If Serial Is Missing Numbers

    Do you mean something like this: Dim StrSN As String StrSN = "CN-0T6116-71618-123-A2C3" 'or a me.the_serial_txt_box If Left(StrSN, 2) = "CN" Then If Not Len(StrSN) = 24 Then MsgBox ("Invalid serial")if the serial begins with CN then check if the length is 24, if not then warn the tech.
  13. V

    Pass-Trough Qry ODBC 3151 error (informix db)

    i've tried that, does'nt work, I get the same error 3151 :s even tried dsn=;DRIVER=.... but doesn't work either. It's just strange, when i input a ODBC system dsn to an informix server, and i delete it immediately after i created it. it will work (also if no static dsn is setted...
  14. V

    Pass-Trough Qry ODBC 3151 error (informix db)

    Hi, I'm working with an Informix 3.32 32 BIT dbserver and want to connect my pass trough queries dsnless by setting the .connect parameter in the querydefs. here's my odbc connection method (with pass-trough queries). I have one table in my Mdb file with the diffrent connect type's (to...
  15. V

    Maximizing Word Ap

    Use this code to be sure it's maximized: ... wordapp.Documents.Parent.Visible = True wordapp.Application.WindowState = 1 ' or wdWindowStateMaximize wordapp.ActiveWindow.WindowState = 1 ' or wdWindowStateMaximize AppActivate "Microsoft Word" ...
See more
Top Bottom