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!

  • Congratulations bkrike 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: *

  • Users: xenofoob
  • Content: Threads
  • Order by date
  1. xenofoob

    (Access) Close all open forms.

    Hello, tried to search the forum but no threads found. Is there a way to close all the open forms? HAve tried something like this: Dim i As Integer MsgBox (Forms.Count) For i = 0 To i = Forms.Count MsgBox (i) Next i but it didn't work like I expected to. Thanks a lot!
  2. xenofoob

    walk through results from query

    Hello, I have a query that get results from my database. Database 1 +------------------------------------+ | ID | OrderId | Name | AMOUT | Type | +------------------------------------+ I have another database with the total items in stock Database 2 +---------------------------+ | ID | Name...
  3. xenofoob

    Via VB delete row from SubForm -- Weird stuff??

    heya I have a subform with the products from my table. Next to each row there is a little button. Onclick that button results that the following code will be executed:Private Sub Knop14_Click() On Error GoTo Err_Knop14_Click Dim strSQL As String Dim l_cmdTmp As New ADODB.Command...
  4. xenofoob

    Subform refresh after query with weird delay :S

    heya I have a subform with the products from my table. Next to each row there is a little button. Onclick that button the following code will be executed:Private Sub btnDelete_Click() On Error GoTo Err_btnDelete_Click 'Dim some vars Dim strSQL As String Dim l_cmdTmp As New...
  5. xenofoob

    How to close a form in sub Form_Open()

    Hello, My Title is clear enough I hope ^o^ This is my piece of code: Private Sub Form_Open(Cancel As Integer) If IsNull([factuur_datum]) Then 'null Else Dim value As Integer value = MsgBox("Date = Null", vbOKCancel) If value = 2 Then...
  6. xenofoob

    How to close a form in sub Form_Open()

    Hello, My Title is clear enough I hope ^o^ This is my piece of code: Private Sub Form_Open(Cancel As Integer) If IsNull([factuur_datum]) Then 'null Else Dim value As Integer value = MsgBox("Date = Null", vbOKCancel) If value = 2 Then...
  7. xenofoob

    Access a variable (global?) in any form (MS Access)

    Heya, Is there any way to access a variable in a form where the variable is not created? This is my layout (simply explained): mainform: Dim bLogin As Boolean loginform: MsgBox bLogin (result: empty msgbox) The mainform is being closed after loginform has been opened. Is there anyway...
  8. xenofoob

    Macro is making form empty

    Hey, I've recorded a macro with the use of a form. It is working correctly, with adding one extra new row with textfields when hitting tab at the last field. Over and over again :) BUT.... the information I've entered in the fields is being cleared! Is there somekind of commando that doesn't...
  9. xenofoob

    Automaticly add Textfield (forms) at new table row after adding

    Hello, I hope my subject is clear enough :) I've got a form with some fields. It is actually a document where I want to fill in some products per line. Product name | Amount | Price When hitting the TAB button after filling in the price there should be a table row added with an...
  10. xenofoob

    Noob q. How to output a variable?

    Hi everybody, Me and my mate are busy for school and have to create a simple assembly program. How do we output a value to the screen. Our value is set in BL and contains 55. We already print sims text onscreen by using msg. This is our simple source code: #make_com# ORG 100H MOV BL,0 add...

Part and Inventory Search

Back
Top